VBA, Access, Excel - Changing lines of code in Excel from Access
Posted on 2014-08-07
Good Day Experts,
I have a 99 worksheet excel spreadsheet that has been handed to me. This workbook has several macro's in it that need to be run on a monthly basis. Prior to the macro, in the excel workbook, being run each month, there are 2 lines of code that need to be updated.
One line that needs to be updated, is a line that gives the number of last month, so, if it is August, I would need to change the number in the macro to june (6).
The other line is formatted like this. If last month had (4+8), it would need to be changed to (5+7).
so, the basic question is:
Can a person change some lines of code housed in an excel spreadsheet from an access database?