VBA in Excel to Ask which file to use?

[Joycelet]

Hi

I have module that imports data from another workbook into a new spreadsheet in my master workbook. which I have working fine - but the users don't also call the workbook the same name so I'm looking how to get the code to prompt the user to select the file they want to import?

Any ideas greatly received.

Thanks

 

[firefytr]

Hi there,

The GetOpenFileName method is what you're asking for. Would you mind posting your code?

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[KenPuls]

Hi Joycelet,

One weakness of GetOpenFilename is that it opens up where it wants (actually last directory you got a file from.) If you want to have it open at a specific place every time, you may want to check out my article here:

http://www.excelguru.ca/node/48

PS... Heya Zack!

Ken Puls, CMA

http://www.excelguru.ca