Tranfser Spreadsheet - browse for file to import

  • Thread starter Thread starter Paul A
  • Start date Start date
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?
 
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
 
Back
Top