importing excel files

[any_west]

I can get access to import a specific excel file using VBA. But i want the user to be able to specify which file it is they want to import. Is there an access VBA command that works like the .GetOpenFilename in excel?

 

[aziz rasul]

I have acquired code obtained from this wonderful forum which allows the user to select any file by browsing. If you are interested let me know and I'll email it to you.

HTH
Aziz

 

[any_west]

if you could send me that it would be a great help.

Thanks alot

 

[aziz rasul]

I have emailed it to you.

 

[George Too]

Cold I have a copy of the code too?

Hi, I have been searching the forum for a solution to this particular issue. Thru code I have been able to have access format the Excel file but have not been abel to import it. Could I have a copy of the code you both any_west and aziz rasul are talking about? Or point me to the right directions will be likewise much appreciated.

Thank you,

George