I'm trying to save a new workbook and I get the following error:
Run-time error 1004
Microsoft Excel cannot access the file 'C:\6A3EF000".
The code is:
Dim WB As Workbook
Set WB = Workbooks.Add
WB.SaveAs "C:\Report.xlsx"
I also tried:
ActiveWorkbook.SaveAs "C:\Report.xlsx"
Same result, just the file name changes in the error message because is creating a new workbook.
Any idea of what can be wrong?
Thanks
Run-time error 1004
Microsoft Excel cannot access the file 'C:\6A3EF000".
The code is:
Dim WB As Workbook
Set WB = Workbooks.Add
WB.SaveAs "C:\Report.xlsx"
I also tried:
ActiveWorkbook.SaveAs "C:\Report.xlsx"
Same result, just the file name changes in the error message because is creating a new workbook.
Any idea of what can be wrong?
Thanks