Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to copy active worksheet to new workbook
Hi,
I want to create a macro that will allow me to use a shortcut that will: (1) copy the values & the format (i.e. not the formulas) of the active worksheet to a new workbook; and (2) save that new workbook as "Claim" in a specified file location. Hope someone can help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to copy active worksheet to new workbook
Is there something specific you need here? You'll get more help if you
post some code and ask for specific help, rather than asking for the code to be written for you. To start, try recording your steps to see what the recorded code looks like. You would then need to generalize the macro to always act on the active workbook. --JP On May 25, 12:34 am, Macca wrote: Hi, I want to create a macro that will allow me to use a shortcut that will: (1) copy the values & the format (i.e. not the formulas) of the active worksheet to a new workbook; and (2) save that new workbook as "Claim" in a specified file location. Hope someone can help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy name from active sheet to cell - using macro or function | Excel Worksheet Functions | |||
copy active cell value,find the pasted value in different worksheet | Excel Worksheet Functions | |||
I want to copy the active workbook name to a cell... | Excel Discussion (Misc queries) | |||
Macro: Exit active workbook without save? | Excel Worksheet Functions | |||
copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions |