I have the following code for assigning a filename to a string:
Is there anyway to have the default value in the file selection box be something such as the previous value of stPartnerFile. This would save the user (me) having to navigate to the file each time if it is the same file as previously used.
Please Login or Register to view this content.
GG
Do you have the filepath and filename of the previous stPartnerFile anywhere that you could link the code to? In a variable or a cell in your workbook?
Despite the high cost of living, it remains very popular.
Don't forget to mark threads SOLVED when you get an answer and rep all the geniouses that helped you today!
I don't unfortunately. I'd be happy at this point having a static "suggested" file name there.
Re: Showing a default file name in GetOpenFilename dialogue box?
Use instead the FileDialog property (see in VBA help) …
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks