Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Where are macros stored?
I'm using Excel 2000.
When I open a workbook, I have some vba functions that I wrote some time ago available to me i.e. they're stored in a separate file somewhere. When I open the vb editor, I see my currently open workbooks, as well as a VBAProject that contains my functions. It's listed as "VBAProject (Excel functions.xla)". My question is, where is this stored? What is the filename? I have tried searching my system for "Excel fuctions.xla", and also "personal.xls"-- neither was found anywhere on my system. I need to know where this file is so I can make sure it is being backed up. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Where are macros stored?
Open Excel (and that "excel functions.xla" workbook)
Open the VBE Hit ctrl-g to see the immediate window. Type this: ?workbooks("excel functions.xla").fullname I'm guessing that you meant functions and not fuctions--but match whatever you see in the project explorer. You can also use: ?workbooks("excel functions.xla").path to see just the folder name. Frank Marousek wrote: I'm using Excel 2000. When I open a workbook, I have some vba functions that I wrote some time ago available to me i.e. they're stored in a separate file somewhere. When I open the vb editor, I see my currently open workbooks, as well as a VBAProject that contains my functions. It's listed as "VBAProject (Excel functions.xla)". My question is, where is this stored? What is the filename? I have tried searching my system for "Excel fuctions.xla", and also "personal.xls"-- neither was found anywhere on my system. I need to know where this file is so I can make sure it is being backed up. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Where are macros stored?
"Dave Peterson" wrote in message
... Open Excel (and that "excel functions.xla" workbook) Open the VBE Hit ctrl-g to see the immediate window. Type this: ?workbooks("excel functions.xla").fullname Worked great... thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use displayed value, not stored value? | Excel Worksheet Functions | |||
where are toolbar changes stored? | Excel Discussion (Misc queries) | |||
Pivotcharts and stored procedures | Charts and Charting in Excel | |||
Where are Macros stored? | Excel Discussion (Misc queries) | |||
Number stored as text | Excel Discussion (Misc queries) |