I'm trying to debug a macro that was written by someone else who is no longer with my company. My VBA skills are "ok", but I'm running into a problem.
The section of code where I'm running into the error is:
I get the error atPlease Login or Register to view this content.
calc is a variable representing a specific sheet within the workbookPlease Login or Register to view this content.
master_wb_name is set as a string equal to ActiveWorkbook.Name
Rev_Rec_Cal_Button2 is a call to another sub within the workbook
This workbook is hosted on a sharing site within my organization. Usually it runs just fine. Where the error comes in is when someone downloads the file even though they already have a version in their download folder. This changes the name of the workbook to "Workbook Name (1)", or "Workbook Name (2)", etc.
Is there a way to solve for this error without trying to explain to the folks that download the file that they already have a version downloaded?
Bookmarks