Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_open Event
Hi All,
How I can run macro when only CSV format file opened. Thanks Hassan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_open Event
Public WithEvents App As Application Private Sub App_WorkbookOpen(ByVal Wb As Workbook) If Wb.FileFormat = xlCSV Then Call myMacro End If End Sub Private Sub Workbook_Open() Set App = Application End Sub 'This is workbook event code. 'To input this code, right click on the Excel icon on the worksheet '(or next to the File menu if you maximise your workbooks), 'select View Code from the menu, and paste the code -- __________________________________ HTH Bob "Hassan" wrote in message ... Hi All, How I can run macro when only CSV format file opened. Thanks Hassan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_open Event
Dear Bob,
Thnx for reply, I tried but its not working, my macro name is Module2. when i saved the procedure which given by you, then new window open asking for macro, when i select from the Module2 from list but next time its not running macro automatically. Please help me "Bob Phillips" wrote: Public WithEvents App As Application Private Sub App_WorkbookOpen(ByVal Wb As Workbook) If Wb.FileFormat = xlCSV Then Call myMacro End If End Sub Private Sub Workbook_Open() Set App = Application End Sub 'This is workbook event code. 'To input this code, right click on the Excel icon on the worksheet '(or next to the File menu if you maximise your workbooks), 'select View Code from the menu, and paste the code -- __________________________________ HTH Bob "Hassan" wrote in message ... Hi All, How I can run macro when only CSV format file opened. Thanks Hassan |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_open Event
I have no idea what you mean. Why is you macro called Module2, that sounds
like a module name? Why do you have to pick anything, you should use the name that you presumably know already. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Hassan" wrote in message ... Dear Bob, Thnx for reply, I tried but its not working, my macro name is Module2. when i saved the procedure which given by you, then new window open asking for macro, when i select from the Module2 from list but next time its not running macro automatically. Please help me "Bob Phillips" wrote: Public WithEvents App As Application Private Sub App_WorkbookOpen(ByVal Wb As Workbook) If Wb.FileFormat = xlCSV Then Call myMacro End If End Sub Private Sub Workbook_Open() Set App = Application End Sub 'This is workbook event code. 'To input this code, right click on the Excel icon on the worksheet '(or next to the File menu if you maximise your workbooks), 'select View Code from the menu, and paste the code -- __________________________________ HTH Bob "Hassan" wrote in message ... Hi All, How I can run macro when only CSV format file opened. Thanks Hassan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
WORKBOOK_OPEN event | Excel Programming | |||
Workbook_Open() Event | Excel Discussion (Misc queries) | |||
Workbook_Open Event | Excel Programming | |||
WorkBook_Open Event | Excel Programming | |||
OnTime event not firing in Workbook_Open event procedure | Excel Programming |