Get file name syntax

[Norman Goldsmith]

I wnat to prompt a user to locate an Excel file so that I can use the file
name to input the data using a pre-defined map. I can't figure out the
syntax that will return the just the filename and not try to import the
Excel data. Can someone help?

Thank you for any help,

Norm

 

[Rod Gill]

Hi,

Unfortunately Project does not have Excel VBA's GetFileOpenName so you need
to use a Windows API. Try www.mvps.org/access and look at their API samples.
They have a file open one that works in Project as well. Failing that, my
book has an example!

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com

 

[Norman Goldsmith]

Rod,

Thank you, I suspected that was the real answer. I'll browse the site while I
await delivery of your book.

Thanks,
Norm