| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I record a Macro that can be used on any spreadsheet?
I am unable find and open something called "Workbook start up folder" If I
record a macro in this does it allow me to use the macro for any future spreadsheets with the same layout and headings? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I record a Macro that can be used on any spreadsheet?
It is the XLSTART folder (may be XLSTART10 or XLSTART11).
Since spreads in here are always loaded, your subs are available. -- Gary's Student gsnu200703 "Eqa" wrote: I am unable find and open something called "Workbook start up folder" If I record a macro in this does it allow me to use the macro for any future spreadsheets with the same layout and headings? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I record a Macro that can be used on any spreadsheet?
In the VBIDE immediate window use
?Application.StarupPath to get the name of the directory. -- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) "Eqa" wrote in message ... I am unable find and open something called "Workbook start up folder" If I record a macro in this does it allow me to use the macro for any future spreadsheets with the same layout and headings? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I record a Macro that can be used on any spreadsheet?
?Application.StarTupPath
(for the want of a T, the war was lost???????) Bob Phillips wrote: In the VBIDE immediate window use ?Application.StarupPath to get the name of the directory. -- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) "Eqa" wrote in message ... I am unable find and open something called "Workbook start up folder" If I record a macro in this does it allow me to use the macro for any future spreadsheets with the same layout and headings? -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I record a Macro that can be used on any spreadsheet?
I am taking a different tack on this question.
When you go to ToolsMacroRecord New Macro a dialog box will open to name the macro. Also where to store it. Select "Personal Macro Workbook" to record to. This will record the macro into Personal.xls which is stored by Excel in your XLSTART folder. Gord Dibben MS Excel MVP On Fri, 2 Feb 2007 21:14:00 -0800, Eqa wrote: I am unable find and open something called "Workbook start up folder" If I record a macro in this does it allow me to use the macro for any future spreadsheets with the same layout and headings? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro hot button in Spreadsheet | Excel Worksheet Functions | |||
| Appending data from one spreadsheet to another using a macro | Excel Discussion (Misc queries) | |||
| Closing File Error | Excel Discussion (Misc queries) | |||
| How do I stop macro alerts for a spreadsheet with no macros in it | Excel Discussion (Misc queries) | |||
| Record Macro Relative does not work? | Excel Discussion (Misc queries) | |||
Hybrid Mode
