Good afternoon all,
So I have been searching for a bit now and haven't found anything to help so I've decided to ask the experts.
The code I was using worked fine until our company upgraded to Excel 365 and now all it does is crash. To be exact, I can get the dialog box to open, file name is prefilled, but when I hit save the workbook crashes. However, when I reopen said workbook, I can use the VBA code and it works just fine, it's just that first time saving that is causing problems.
I feel like there must be new code to use or a work around to keep it from hanging. I currently have Version 2002 (12527.20242).
Here's the code: (I pared it down a LOT to hopefully find the snag, but it didn't work)
Nice and simple and it did just what I wanted it to do, until now!
Not looking for anything Read-Only, I just want this to work again.
What should it do:
If someone clicks the SAVE button, the dialog box will open, the extracted name will be inserted as the SaveAs file name, the user can save to their preferred location.