Hello all!
I am making a macro to specify a location for my teammates to save files too. I put the following code in a button to run a few macros to format the data and then prompt them to save the file. Everything seems to work fine opening the dialog boxes, but after i click Save, nothing happens.
Please Login or Register to view this content.
Last edited by MOz; 07-18-2023 at 02:51 PM.
You should add .Execute after .Show
Because workbook contains macro, you should save it as .xlsm rather then .xlsxPlease Login or Register to view this content.
Please Login or Register to view this content.
Please Login or Register to view this content.
Experience trumps academics every day of the week and twice on Sunday.
oEx, everybody on this forum is free to give suggestions - without being questioned or criticized.
If you have a problem with a post, take it up with a mod or admin
And please remember that common courtesy is the order of the day.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Ouf!!
Thank you FDibbins, I was waiting for such support to Jolivanes.
What a good day!
- Battle without fear gives no glory - Just try
Thanks Ford for the backup and merci beaucoup PCI
I don't have a problem with a useful suggestion, but with a redundant and stupid suggestion.Originally Posted by FDibbins
I didn't ban anyone from posting, but rather pointing out reasons why they shouldn't do it.
People should know when to talk and when to be silent, even more.
@oEx
Your opinion of other solutions offered is neither relevant nor needed. Anybody can offer any solution at any point in the thread.
Keep your opinions to yourself, please. As Ford has advised, use the Report Button if you feel someone has added something completely irrelevant to a thread, but do NOT tackle it yourself: that is something that only Moderators and Administrators should be doing.
Not from you. Mind your own business, please, unless you wish to be banned from posting here altogether. Thank you.People should know when to talk and when to be silent, even more.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks