Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Saving the Macro for all workbooks
Hi,
I have a code which I have wrtitten seperately which now I to be accessible by all workbooks, I have heard that there is a hidden file where we can save this, but I am not able to find it, can anyone please guide me how to go about it. -- Regards, Pranay Shah |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Saving the Macro for all workbooks
Personal.xls.
Personal.xls is located in the XLStart directory, and is used to store macros and things that you want to be available to all workbooks, whenever you start Excel. By default, it is hidden in Excel, but if you go to the VBE, you use it as you can with any other open workbook (you don't have to unhide it). You can create it by - goto ToolsMacrosRecord New Macro... - Choose Personal Macro Workbook form the dropdown - OK - click the Stop button on the toolbar that pops-up You now have a Personal.xls workbook. It is not visible though, it is hidden by default (WindowsUnhide) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Pranay Shah" wrote in message ... Hi, I have a code which I have wrtitten seperately which now I to be accessible by all workbooks, I have heard that there is a hidden file where we can save this, but I am not able to find it, can anyone please guide me how to go about it. -- Regards, Pranay Shah |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Saving the Macro for all workbooks
Hi Bob,
Thanks for the replying back. I was able to find the Personal.xls file and i had added the code in the module also but when i tried to use it some other workbook it didn't worked. Can you please help me out how to go about it. -- Regards, Pranay Shah "Bob Phillips" wrote: Personal.xls. Personal.xls is located in the XLStart directory, and is used to store macros and things that you want to be available to all workbooks, whenever you start Excel. By default, it is hidden in Excel, but if you go to the VBE, you use it as you can with any other open workbook (you don't have to unhide it). You can create it by - goto ToolsMacrosRecord New Macro... - Choose Personal Macro Workbook form the dropdown - OK - click the Stop button on the toolbar that pops-up You now have a Personal.xls workbook. It is not visible though, it is hidden by default (WindowsUnhide) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Pranay Shah" wrote in message ... Hi, I have a code which I have wrtitten seperately which now I to be accessible by all workbooks, I have heard that there is a hidden file where we can save this, but I am not able to find it, can anyone please guide me how to go about it. -- Regards, Pranay Shah |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Saving the Macro for all workbooks
If you want to use a macro in another workbook, you need Application.Run
Application.Run "Personal.xls!test_macro" .... with parameters Application.Run "Personal.xls!test_macro", 4, 8 -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Pranay Shah" wrote in message ... Hi Bob, Thanks for the replying back. I was able to find the Personal.xls file and i had added the code in the module also but when i tried to use it some other workbook it didn't worked. Can you please help me out how to go about it. -- Regards, Pranay Shah "Bob Phillips" wrote: Personal.xls. Personal.xls is located in the XLStart directory, and is used to store macros and things that you want to be available to all workbooks, whenever you start Excel. By default, it is hidden in Excel, but if you go to the VBE, you use it as you can with any other open workbook (you don't have to unhide it). You can create it by - goto ToolsMacrosRecord New Macro... - Choose Personal Macro Workbook form the dropdown - OK - click the Stop button on the toolbar that pops-up You now have a Personal.xls workbook. It is not visible though, it is hidden by default (WindowsUnhide) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Pranay Shah" wrote in message ... Hi, I have a code which I have wrtitten seperately which now I to be accessible by all workbooks, I have heard that there is a hidden file where we can save this, but I am not able to find it, can anyone please guide me how to go about it. -- Regards, Pranay Shah |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Saving the Macro for all workbooks
Hi Bob,
How do I use the Application.Run and where do i add this in my workbook? Sorry, I new to this field so please bear with me. :) Thanks. -- Regards, Pranay Shah "Bob Phillips" wrote: If you want to use a macro in another workbook, you need Application.Run Application.Run "Personal.xls!test_macro" .... with parameters Application.Run "Personal.xls!test_macro", 4, 8 -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Pranay Shah" wrote in message ... Hi Bob, Thanks for the replying back. I was able to find the Personal.xls file and i had added the code in the module also but when i tried to use it some other workbook it didn't worked. Can you please help me out how to go about it. -- Regards, Pranay Shah "Bob Phillips" wrote: Personal.xls. Personal.xls is located in the XLStart directory, and is used to store macros and things that you want to be available to all workbooks, whenever you start Excel. By default, it is hidden in Excel, but if you go to the VBE, you use it as you can with any other open workbook (you don't have to unhide it). You can create it by - goto ToolsMacrosRecord New Macro... - Choose Personal Macro Workbook form the dropdown - OK - click the Stop button on the toolbar that pops-up You now have a Personal.xls workbook. It is not visible though, it is hidden by default (WindowsUnhide) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Pranay Shah" wrote in message ... Hi, I have a code which I have wrtitten seperately which now I to be accessible by all workbooks, I have heard that there is a hidden file where we can save this, but I am not able to find it, can anyone please guide me how to go about it. -- Regards, Pranay Shah |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Saving the Macro for all workbooks
where you are currently trying to call the macro
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Pranay Shah" wrote in message ... Hi Bob, How do I use the Application.Run and where do i add this in my workbook? Sorry, I new to this field so please bear with me. :) Thanks. -- Regards, Pranay Shah "Bob Phillips" wrote: If you want to use a macro in another workbook, you need Application.Run Application.Run "Personal.xls!test_macro" .... with parameters Application.Run "Personal.xls!test_macro", 4, 8 -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Pranay Shah" wrote in message ... Hi Bob, Thanks for the replying back. I was able to find the Personal.xls file and i had added the code in the module also but when i tried to use it some other workbook it didn't worked. Can you please help me out how to go about it. -- Regards, Pranay Shah "Bob Phillips" wrote: Personal.xls. Personal.xls is located in the XLStart directory, and is used to store macros and things that you want to be available to all workbooks, whenever you start Excel. By default, it is hidden in Excel, but if you go to the VBE, you use it as you can with any other open workbook (you don't have to unhide it). You can create it by - goto ToolsMacrosRecord New Macro... - Choose Personal Macro Workbook form the dropdown - OK - click the Stop button on the toolbar that pops-up You now have a Personal.xls workbook. It is not visible though, it is hidden by default (WindowsUnhide) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Pranay Shah" wrote in message ... Hi, I have a code which I have wrtitten seperately which now I to be accessible by all workbooks, I have heard that there is a hidden file where we can save this, but I am not able to find it, can anyone please guide me how to go about it. -- Regards, Pranay Shah |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Saving the Macro for all workbooks
If you're trying to use a function that you created and stored in personal.xls
in a cell in a worksheet, you'd use something like: =personal.xls!yourfunctionnamehere(...) Pranay Shah wrote: Hi Bob, Thanks for the replying back. I was able to find the Personal.xls file and i had added the code in the module also but when i tried to use it some other workbook it didn't worked. Can you please help me out how to go about it. -- Regards, Pranay Shah "Bob Phillips" wrote: Personal.xls. Personal.xls is located in the XLStart directory, and is used to store macros and things that you want to be available to all workbooks, whenever you start Excel. By default, it is hidden in Excel, but if you go to the VBE, you use it as you can with any other open workbook (you don't have to unhide it). You can create it by - goto ToolsMacrosRecord New Macro... - Choose Personal Macro Workbook form the dropdown - OK - click the Stop button on the toolbar that pops-up You now have a Personal.xls workbook. It is not visible though, it is hidden by default (WindowsUnhide) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Pranay Shah" wrote in message ... Hi, I have a code which I have wrtitten seperately which now I to be accessible by all workbooks, I have heard that there is a hidden file where we can save this, but I am not able to find it, can anyone please guide me how to go about it. -- Regards, Pranay Shah -- Dave Peterson |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Saving the Macro for all workbooks
Pranay
Create an Add-in with your macros. Then load the add-in through ToolsAdd-ins. You won't have to use the Personal.xls! or Application.Run method Gord Dibben MS Excel MVP On Thu, 19 Jul 2007 07:33:25 -0500, Dave Peterson wrote: If you're trying to use a function that you created and stored in personal.xls in a cell in a worksheet, you'd use something like: =personal.xls!yourfunctionnamehere(...) Pranay Shah wrote: Hi Bob, Thanks for the replying back. I was able to find the Personal.xls file and i had added the code in the module also but when i tried to use it some other workbook it didn't worked. Can you please help me out how to go about it. -- Regards, Pranay Shah "Bob Phillips" wrote: Personal.xls. Personal.xls is located in the XLStart directory, and is used to store macros and things that you want to be available to all workbooks, whenever you start Excel. By default, it is hidden in Excel, but if you go to the VBE, you use it as you can with any other open workbook (you don't have to unhide it). You can create it by - goto ToolsMacrosRecord New Macro... - Choose Personal Macro Workbook form the dropdown - OK - click the Stop button on the toolbar that pops-up You now have a Personal.xls workbook. It is not visible though, it is hidden by default (WindowsUnhide) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Pranay Shah" wrote in message ... Hi, I have a code which I have wrtitten seperately which now I to be accessible by all workbooks, I have heard that there is a hidden file where we can save this, but I am not able to find it, can anyone please guide me how to go about it. -- Regards, Pranay Shah |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving Workbooks w/ Charts | Excel Discussion (Misc queries) | |||
Shared Workbooks Saving | Excel Discussion (Misc queries) | |||
SAVING DATA TO CLOSED WORKBOOKS | Excel Worksheet Functions | |||
Saving changes in shared workbooks | Excel Discussion (Misc queries) | |||
Renaming and saving workbooks but macro still deletes | Excel Worksheet Functions |