I would like to take an existing text file (approx 4 megs in size) and manipulate it with VB or VBA (from inside Access in that case) and then ideally place it inside a table format, at the very ...

If you want to accomplish the same thing from inside Excel—for instance, display and populate an appointment while working in Excel—you’ll need a bit of VBA magic.

I need to be able to get a date value stored in an Excel spreadsheet (say, C Temp\file.xls) in cell B28, and put that value into a variable to then use it in a VBA module in MS Access. <BR><BR>I ...

Excel Online doesn’t support VBA. Where the procedure goes The first thing to get out of the way is this: You can’t store this procedure in just any workbook.