| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating macro that works in any open workbook?
I can setup and record macros without a problem normally. But I can't figure
out how to setup one that will work no matter what file I have open. I just need it to copy a few different areas to a known template, but the sheet being copied will always be a different file. The marco I've setup always has an error because it looks for the same file that I originally created the macro to copy from. Can anyone help out on this??? I know it has to be a simple fix, I'm just over thinking it!!! Thanks for the help in advance...... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
creating macro that works in any open workbook?
save the file in Excel's startup or alternative startup folders, so that
Excel will open it as soon as you launch Excel "Don" wrote in message ... I can setup and record macros without a problem normally. But I can't figure out how to setup one that will work no matter what file I have open. I just need it to copy a few different areas to a known template, but the sheet being copied will always be a different file. The marco I've setup always has an error because it looks for the same file that I originally created the macro to copy from. Can anyone help out on this??? I know it has to be a simple fix, I'm just over thinking it!!! Thanks for the help in advance...... |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
creating macro that works in any open workbook?
This site has some info that might help.
http://personal-computer-tutor.com/personalxls.htm "Don" wrote in message ... I can setup and record macros without a problem normally. But I can't figure out how to setup one that will work no matter what file I have open. I just need it to copy a few different areas to a known template, but the sheet being copied will always be a different file. The marco I've setup always has an error because it looks for the same file that I originally created the macro to copy from. Can anyone help out on this??? I know it has to be a simple fix, I'm just over thinking it!!! Thanks for the help in advance...... |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
creating macro that works in any open workbook?
Store the macro in your Personal.xls(b) file.
In the macro make sure you use "activeworkbook" and/or "activesheet" not a hard-coded file/sheet name. Gord Dibben MS Excel MVP On Tue, 19 May 2009 07:44:09 -0700, Don wrote: I can setup and record macros without a problem normally. But I can't figure out how to setup one that will work no matter what file I have open. I just need it to copy a few different areas to a known template, but the sheet being copied will always be a different file. The marco I've setup always has an error because it looks for the same file that I originally created the macro to copy from. Can anyone help out on this??? I know it has to be a simple fix, I'm just over thinking it!!! Thanks for the help in advance...... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel workbook wants to open with Works | Excel Discussion (Misc queries) | |||
| Excel Addin works that works on a template workbook | Excel Programming | |||
| Macro works in one workbook but not in another | Excel Programming | |||
| Runtime error for macro that works in workbook created in | Excel Discussion (Misc queries) | |||
| Creating Menu to open workbook | Excel Worksheet Functions | |||
Linear Mode
