Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Event When the excel opens
Dear Friends,
I need to run a set of codes when ever excel is opened and another set of codes when ever excel is closed, is this possible..? Thanks in Advance Regards Thyagaraj |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Event When the excel opens
Thyagaraj,
Your Personal.xls WB is open/closed along with Excel, so any code in it's Workbook_Open/BeforeClose events will fire. NickHK "Thyagaraj" wrote in message oups.com... Dear Friends, I need to run a set of codes when ever excel is opened and another set of codes when ever excel is closed, is this possible..? Thanks in Advance Regards Thyagaraj |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Event When the excel opens
how to store macro in personal xls?
i only get options 1 all open worksbooks 2 this worksbook 3 book1 -- hemu "NickHK" wrote: Thyagaraj, Your Personal.xls WB is open/closed along with Excel, so any code in it's Workbook_Open/BeforeClose events will fire. NickHK "Thyagaraj" wrote in message oups.com... Dear Friends, I need to run a set of codes when ever excel is opened and another set of codes when ever excel is closed, is this possible..? Thanks in Advance Regards Thyagaraj |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Event When the excel opens
Not sure what you looking at, but in the VBA IDE, ViewProject Explorer,
will bring up a window, showing the worksheets/userforms/modules for all open workbook. Select Personal.xls, then add where necessary. NickHK "Hemant_india" wrote in message ... how to store macro in personal xls? i only get options 1 all open worksbooks 2 this worksbook 3 book1 -- hemu "NickHK" wrote: Thyagaraj, Your Personal.xls WB is open/closed along with Excel, so any code in it's Workbook_Open/BeforeClose events will fire. NickHK "Thyagaraj" wrote in message oups.com... Dear Friends, I need to run a set of codes when ever excel is opened and another set of codes when ever excel is closed, is this possible..? Thanks in Advance Regards Thyagaraj |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Event When the excel opens
nick
i do not see word personal anywhere what could be wrong? -- hemu "NickHK" wrote: Not sure what you looking at, but in the VBA IDE, ViewProject Explorer, will bring up a window, showing the worksheets/userforms/modules for all open workbook. Select Personal.xls, then add where necessary. NickHK "Hemant_india" wrote in message ... how to store macro in personal xls? i only get options 1 all open worksbooks 2 this worksbook 3 book1 -- hemu "NickHK" wrote: Thyagaraj, Your Personal.xls WB is open/closed along with Excel, so any code in it's Workbook_Open/BeforeClose events will fire. NickHK "Thyagaraj" wrote in message oups.com... Dear Friends, I need to run a set of codes when ever excel is opened and another set of codes when ever excel is closed, is this possible..? Thanks in Advance Regards Thyagaraj |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Event When the excel opens
Which version of Excel are you using ?
Search your computer for this file, "Personal.xls". NickHK "Hemant_india" wrote in message ... nick i do not see word personal anywhere what could be wrong? -- hemu "NickHK" wrote: Not sure what you looking at, but in the VBA IDE, ViewProject Explorer, will bring up a window, showing the worksheets/userforms/modules for all open workbook. Select Personal.xls, then add where necessary. NickHK "Hemant_india" wrote in message ... how to store macro in personal xls? i only get options 1 all open worksbooks 2 this worksbook 3 book1 -- hemu "NickHK" wrote: Thyagaraj, Your Personal.xls WB is open/closed along with Excel, so any code in it's Workbook_Open/BeforeClose events will fire. NickHK "Thyagaraj" wrote in message oups.com... Dear Friends, I need to run a set of codes when ever excel is opened and another set of codes when ever excel is closed, is this possible..? Thanks in Advance Regards Thyagaraj |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Event When the excel opens
It is quite possible that the personal.xls workbook has not yet
been created. Record a new macro, what it does is irrelevant, and change the "Store macro in" setting to "Personal Macro Workbook". This will create the file and then save the macro to that file. "NickHK" wrote in message ... Which version of Excel are you using ? Search your computer for this file, "Personal.xls". NickHK "Hemant_india" wrote in message ... nick i do not see word personal anywhere what could be wrong? -- hemu "NickHK" wrote: Not sure what you looking at, but in the VBA IDE, ViewProject Explorer, will bring up a window, showing the worksheets/userforms/modules for all open workbook. Select Personal.xls, then add where necessary. NickHK "Hemant_india" wrote in message ... how to store macro in personal xls? i only get options 1 all open worksbooks 2 this worksbook 3 book1 -- hemu "NickHK" wrote: Thyagaraj, Your Personal.xls WB is open/closed along with Excel, so any code in it's Workbook_Open/BeforeClose events will fire. NickHK "Thyagaraj" wrote in message oups.com... Dear Friends, I need to run a set of codes when ever excel is opened and another set of codes when ever excel is closed, is this possible..? Thanks in Advance Regards Thyagaraj |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel opens in Autosave.How do I delete it so it opens in Book1? | Setting up and Configuration of Excel | |||
Excel file opens and opens and opens | Excel Discussion (Misc queries) | |||
Excel opens correct view - web (used frontpg) opens it wrong | Excel Discussion (Misc queries) | |||
Personal workbook opens when Excel opens | Excel Discussion (Misc queries) | |||
How to register an event handler when excel opens | Excel Programming |