noob question: using a form to import spreadsheet?

[gestaltphoenix]

Suggestions on how to import a spreadsheet by typing the file path into the text box. A browse button would be even nicer )....Any suggestions???

Sorry for the noob question....

Thanx

 

[Gazer44]

Not sure if this is exactly what you need but you could set up a 'TransferSpreadsheet' macro and use a button-when clicked will run this macro and import the spreadsheet.

If there's more than 1 s/sheet, set up each macro individually and either have more than 1 button to run the import you want
OR
have 1 button (called 'select import')which opens a menu with different buttons on showing the the various imports available.
OR a drop down menu which, when selected, imports that particular s/sheet.