Hello,
I am trying to run reports in Access 2007 Database (output is an Excel file) one after the other.
The first report works perfectly, but when I try to run the second report, I get the error
"Run Time Error 1004: Method Range of Object _Global Failed"
(Both of these reports are same except the first report is for 1Month Sales and Second Report is for 6 Months).
I have to close and re-open the database every time I need to run these reports one after the other.
Here is the code:
'Rearrange Columns
.Range("E:F").Select
.Selection.Cut
.Range("M:N").Select
.ActiveSheet.Paste
.Range("G:N").Select
.Selection.Cut Destination:=Range("E:L") (This is where code fails when the second report is run with the above error message)
I have googled the error but couldn't find a satisfactory answer...