Hi, The code below will save a xlsm file as a xlsx file using the same name. I need it to prompt me with the name highlighted in blue so I can change it slightly if needed before saving.
Can anyone help, thanks in advance.
Please Login or Register to view this content.
Last edited by ccpsc; 05-09-2012 at 03:34 AM.
You could just use the Application.FileDialog to do this e.g:
Please Login or Register to view this content.
For testing your Regular Expression patterns, try my Regular Expression Pattern Testing add-in!
For notes on how to use it - see here.
You need to use the GetSaveasFilename dialog.
Please Login or Register to view this content.
Thanks Firefly that worked. What code do I need to turn off file type warning.
Thanks Andy that did it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks