Thanks for your replies.

I have
..LookIn = "C:\my excel path"
It is hard coded in. How do I get the path programatically?

Thanks
Mike





"Steve Danielson [MS]" wrote in message
...
Hi Mike,

Take a look at the Application.GetOpenFilename method and see if that does
what you need. It provides a UI for the user to browse and select files,
and then returns the file for your macro to process as desired.

For information and sample code for integrating Office with Visual Basic,
Visual C++, Internet Scripts, and other programming languages, please see
http://msdn.microsoft.com/library/te...SOfficeDev.htm. This site
contains the most up-to-date information for using developer tools for
Office integration and extensibility.

Best regards,
Steve Danielson
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no
rights.

Are you secure? Please visit the Microsoft Security & Privacy Center
(http://www.microsoft.com/security) for the latest news on security
updates.