so here i have my snippet of code; just need to program the debug.print to display the file name and path.
i did some google searching for application.findfile but didn't find a reference with all the subcodes (like .newsearch, etc). so im not sure what to put in my debug.print line.
Please Login or Register to view this content.
thoughts?
Not sure what you're trying to do.
Application.FindFile does not search for a file. It is a file selector dialog where the user selects a file to open. It only returns True\False depending if a file was opened or not.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
thanks alphafrog, how can i search for a file then?
can anyone help me with this?
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks