Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Container in Auto open macro
Hi,
I have an excel file which is embedded in some application. I ahve a macro written in the excel file. I want the macro to run automatically as soon as I open the excel sheet. For this I used the Workbook_Open macro. But inside this macro if I try to call the Container method, I am getting an error. <code Private Sub Workbook_Open() Dim x As Object Worksheets("Sheet1").Activate Set x = ThisWorkbook.Container End Sub </code But, instead of using the Workbook_Open macro, I use some other macro, say macro1, and then run that macro manucally after opening the excel sheet, I get no error. Does anyone have any idea why it does not work when I use Workbook_Open macro? I want the macro to run as soon as I open the excel sheet. <code Private Sub macro1() Dim x As Object Worksheets("Sheet1").Activate Set x = ThisWorkbook.Container End Sub </code Regards, AA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can a Macro open workbooks on a SharePoint Site? | Excel Discussion (Misc queries) | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Auto Run a Macro | Excel Discussion (Misc queries) | |||
Macro that will add data from multiple workbooks to the 1st open r | Excel Discussion (Misc queries) | |||
open file (as variable) from macro | Excel Discussion (Misc queries) |