K
Ken
I am having a problem copying a sheet from a web based spreadsheet to a
local workbook. When I try and run a macro locally and go to the web based
sheet it sometimes does not recognize the web based sheet. I can run a
macro and add a sheet to the web based spreadsheet, move data from the first
sheet to the new sheet, format, etc; the new sheet. Results looks good. I
then want to copy the new sheet to a local workbook and save the sheet with
all its data and formating. The web based workbook is named "byname.asp"
the original sheet is "byname". I have added a sheet named
"OvertimeSummary".
I am trying to copy the sheet with the command:
Workbooks("byname.asp").Sheets("OvertimeSummary").Copy
If I run the Macro from the local workbook, either calling the Macro from
the menu or with a button on the spreadsheet, it makes a copy of the sheet
as a new sheet within the web based workbook. If I run the Macro from the
VBA editor, it makes a new local workbook "Book1" with the sheet just as I
want.
I don't want the have to run from the VBA editor!
What causes the difference? Also, I can not "Activate" the web based
workbooks. Not allowed.........
Ken
local workbook. When I try and run a macro locally and go to the web based
sheet it sometimes does not recognize the web based sheet. I can run a
macro and add a sheet to the web based spreadsheet, move data from the first
sheet to the new sheet, format, etc; the new sheet. Results looks good. I
then want to copy the new sheet to a local workbook and save the sheet with
all its data and formating. The web based workbook is named "byname.asp"
the original sheet is "byname". I have added a sheet named
"OvertimeSummary".
I am trying to copy the sheet with the command:
Workbooks("byname.asp").Sheets("OvertimeSummary").Copy
If I run the Macro from the local workbook, either calling the Macro from
the menu or with a button on the spreadsheet, it makes a copy of the sheet
as a new sheet within the web based workbook. If I run the Macro from the
VBA editor, it makes a new local workbook "Book1" with the sheet just as I
want.
I don't want the have to run from the VBA editor!
What causes the difference? Also, I can not "Activate" the web based
workbooks. Not allowed.........
Ken