Tranfser Spreadsheet - browse for file to import

P

Paul A

I would like to use the transfer spreadsheet macro, and
have it allow the user browse for the excel file to
open. Is there a way to do this without using VB?
 
J

Jim/Chris

You could launch the macro from a command button on a form
referencing the excel file name from a control on that
form. I have done this and it works. The control on the
form would be utilizing the "Windows File Open/Save dialog
box". This can be found at
http://www.mvps.org/access/api/api0001.htm

Jim
 

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
How can I get a Shareable URL via VBA code to a OneDrive image? 0
You'll need a new app to open this about link 1
Insert multiple objects at once ? 3
Cannot open any folders (pinned or recent) from Word 365 Open Dialogue/Backstage 0
Mail Merge Directory Conditional Page Break 0
Outlook 2016: recent change to add account. No browse for data file. 0
Excel does not accept text format! 0

Top