Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP! Macro stuck-"Invalid Object"
I walked this through the recorder yesterday using two documents and it
worked fine. I put it into a major macro routine and made some minor changes - and now it hangs! But it hangs where yesterday it worked fine! Workbooks.Open Filename:="C:\NWACCESS\DATA\Sent Updates\Warning.xls" Cells.Select Selection.Copy With wb3.Sheets(3) Cells.Select ActiveSheet.Paste ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True End With Application.DisplayAlerts = False Workbook.Activate Filename:="C:\NWACCESS\DATA\Sent Updates\Warning.xls" Workbook.Close Application.DisplayAlerts = True The changes I made were to change the target workbook to wb3, which was declared at the beginning and has been used all throughout this routine - and that isn't the problem. Somehow, I can't call back the first workbook ("Warning.xls") to close it. It's hung up saying "Invalid Object". I did have Workbooks.Close Filename:=etc, but it didn't go, so I tried what's in there now. It doesn't work either. Any help? Ed |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP! Macro stuck-"Invalid Object"
Ed,
Try: Workbooks("Warning.xls").Activate ActiveWorkbook.Close Or better still: Workbooks("Warning.xls").Close (there's no need to activate a workbook before closing it) HTH Henry "Ed" wrote in message ... I walked this through the recorder yesterday using two documents and it worked fine. I put it into a major macro routine and made some minor changes - and now it hangs! But it hangs where yesterday it worked fine! Workbooks.Open Filename:="C:\NWACCESS\DATA\Sent Updates\Warning.xls" Cells.Select Selection.Copy With wb3.Sheets(3) Cells.Select ActiveSheet.Paste ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True End With Application.DisplayAlerts = False Workbook.Activate Filename:="C:\NWACCESS\DATA\Sent Updates\Warning.xls" Workbook.Close Application.DisplayAlerts = True The changes I made were to change the target workbook to wb3, which was declared at the beginning and has been used all throughout this routine - and that isn't the problem. Somehow, I can't call back the first workbook ("Warning.xls") to close it. It's hung up saying "Invalid Object". I did have Workbooks.Close Filename:=etc, but it didn't go, so I tried what's in there now. It doesn't work either. Any help? Ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why do i "sometimes" need to "edit chart object" before "source da | Charts and Charting in Excel | |||
Macro to Create New Worksheet and Reference Cell in Old Worksheet As Tab Name - "Object Required" Error | Excel Discussion (Misc queries) | |||
How do I remove a flash object "stuck on" my spreadsheet? | Excel Discussion (Misc queries) | |||
Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
How do I "unassign" a deleted Macro from an object in Excel? | Excel Discussion (Misc queries) |