Excel Macros updated
Budget: £20 – £250 GBP
Need the following completed:
1. I have a macro that runs to update certain cells in a spreadsheet.
2. i need it updated so that it downloads xlsx attachments from a number of emails from the INBOX in a certain Outlook mailbox into a "working" folder on the computer.
3. then each excel spreadsheet in that "working folder" needs the macro to run against it to calculate and update the various cells
4. then archives all the emails into an "archive folder" in that Outlook mailbox
4. then create a folder on the computer (one for each month in the year eg May2021, June2021, etc), and save the files to this different folder on the computer
5. then remove the files from the "working folder"
The text file shows the calculations and changes that are made by the first script
The first script I have does the changes to the calculations and changes to the OPEN excel spreadsheet - this needs to be run on all the excel spreadsheets in the working folder +-90 of them
this first script has been modified in attempt to do what is required but it doesnt work correctly - this is the 2nd script
the zip files show the spreadsheets before macro is run and after macro is run
1. I have a macro that runs to update certain cells in a spreadsheet.
2. i need it updated so that it downloads xlsx attachments from a number of emails from the INBOX in a certain Outlook mailbox into a "working" folder on the computer.
3. then each excel spreadsheet in that "working folder" needs the macro to run against it to calculate and update the various cells
4. then archives all the emails into an "archive folder" in that Outlook mailbox
4. then create a folder on the computer (one for each month in the year eg May2021, June2021, etc), and save the files to this different folder on the computer
5. then remove the files from the "working folder"
The text file shows the calculations and changes that are made by the first script
The first script I have does the changes to the calculations and changes to the OPEN excel spreadsheet - this needs to be run on all the excel spreadsheets in the working folder +-90 of them
this first script has been modified in attempt to do what is required but it doesnt work correctly - this is the 2nd script
the zip files show the spreadsheets before macro is run and after macro is run