| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy a worksheet to another xls file
I have made a macro using with a VB function which generates a new
worksheet. I want to copy the generated worksheet into a new xls-file which I want to create by a dialog-save file. Can anyone give me some simple example code? Jac |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy a worksheet to another xls file
Jac,
Try something like the following: Dim FName As Variant ActiveSheet.Copy FName = Application.GetSaveAsFilename(filefilter:="Excel files (*.xls),*.xls") If FName < False Then ActiveWorkbook.SaveAs FName End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Jac" wrote in message .. . I have made a macro using with a VB function which generates a new worksheet. I want to copy the generated worksheet into a new xls-file which I want to create by a dialog-save file. Can anyone give me some simple example code? Jac |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy a worksheet to another xls file
Thanks
"Chip Pearson" schreef in bericht ... Jac, Try something like the following: Dim FName As Variant ActiveSheet.Copy FName = Application.GetSaveAsFilename(filefilter:="Excel files (*.xls),*.xls") If FName < False Then ActiveWorkbook.SaveAs FName End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Jac" wrote in message .. . I have made a macro using with a VB function which generates a new worksheet. I want to copy the generated worksheet into a new xls-file which I want to create by a dialog-save file. Can anyone give me some simple example code? Jac |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy a worksheet from one file to another | Excel Discussion (Misc queries) | |||
| Copy worksheet from one file to another | Excel Discussion (Misc queries) | |||
| copy worksheet without reference to old .xls file | Excel Discussion (Misc queries) | |||
| copy part of a worksheet into a worksheet in the same file/keepi. | Excel Worksheet Functions | |||
| How do I copy a worksheet from a workbook as csv file | Excel Discussion (Misc queries) | |||
![Jac[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
