I'm trying to create a macro to open a file that can only be opened if it is correctly equal to "machinelijst_draaien"
With this macro he does not open anything, not even with the exact name and so always go to the msgbox 'Incorrect filename'
Please Login or Register to view this content.
Hi
Getopenfilename returns the full file path and name, not just the name.
Don
Please remember to mark your thread 'Solved' when appropriate.
Debug the code and determine what machinelijst_draaien equals before the msgbox.
I fear that I do not know how to do this or what and where I need to change
This might help.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Problem solved by now, you may consider the question as solved, but thank you for the comments
With kind regards, Fernand
If it's solved for you.
Please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks