How do I customize a transferspreadsheet macro to prompt for file

D

dwyerst

I have a macro that imports data from a spreadsheet into a table in Access.
I would like to be able to customize the macro so that it prompts for the
spreadsheet name to be imported instead of having that as part of the macro.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
Using TransferSpreadsheet to import from Excel to Access with variable file names 1
VBA word change keys 0
Word macro that can call cells out of Excel for a find and replace 0
Mail Merge Directory Conditional Page Break 0
Grouping Names in Mail Merge 0
Importing via TransferSpreadsheet, receiving "type conversion fail 1
TransferSpreadsheet Plus a Function 5

Top