Good morning.
I have a workbook in which all the VBA code is in. I use the code to extract SAP data which then opens a new workbook when it downloads the data. The workbook name will be different each week as the data is downloaded weekly. Below is the spreadsheet in the workbook which calculates a dynamic name for the new file that's downloaded based on the week number. All coding up to this point works perfectly.
When i want the code to save the file (Which is open and has a name), the code gets stuck here where i have set a dimensions which reads the cell as indicated above.
When i replace the dimension with the name of the workbook, the code works fine. I however have to automate the name as it changes on a weekly basis.
I please need assistance with this error to either find a workaround or getting the code to work.
Thanks
FWK
I have a workbook in which all the VBA code is in. I use the code to extract SAP data which then opens a new workbook when it downloads the data. The workbook name will be different each week as the data is downloaded weekly. Below is the spreadsheet in the workbook which calculates a dynamic name for the new file that's downloaded based on the week number. All coding up to this point works perfectly.
When i want the code to save the file (Which is open and has a name), the code gets stuck here where i have set a dimensions which reads the cell as indicated above.
When i replace the dimension with the name of the workbook, the code works fine. I however have to automate the name as it changes on a weekly basis.
I please need assistance with this error to either find a workaround or getting the code to work.
Thanks
FWK
