| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Impoting excel sheet to new workbook
HI All,
I have a excel workbook which contains 6-7 sheets. i want to write a vba code .. so that when i run, it should create a new work book on my desktop and import all the 7 sheets from the source Workbook. Regards Kumar |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Impoting excel sheet to new workbook
On Monday, July 30, 2012 2:55:51 AM UTC-5, kumark wrote:
HI All, I have a excel workbook which contains 6-7 sheets. i want to write a vba code .. so that when i run, it should create a new work book on my desktop and import all the 7 sheets from the source Workbook. Regards Kumar -- kumark Have you considered using saveAS |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Impoting excel sheet to new workbook
Don Guillett wrote:
On Monday, July 30, 2012 2:55:51 AM UTC-5, kumark wrote: I have a excel workbook which contains 6-7 sheets. i want to write a vba code .. so that when i run, it should create a new work book on my desktop and import all the 7 sheets from the source Workbook. Have you considered using saveAS Or copying the existing file? -- Forest? What forest? I just see a bunch of trees! |
|
#4
|
|||
|
|||
|
Quote:
Sub ImportTemplate() FileCopy "c:\Adventure.xlsm", _ ActiveWorkbook.Path & "Adventureworks.xlsm" Name "C:\WorkedAdventist.xlsm" As "C:\Documents and Settings\All users\Desktop\Adventist.xlsm" End Sub |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save each sheet of multi-sheet workbook as a single-sheet workbook | Excel Programming | |||
| code for impoting userform and module | Excel Programming | |||
| Problem with the format of cells after impoting from Access | Excel Discussion (Misc queries) | |||
| Impoting data from Sheet 1 to Sheet 2 | Excel Discussion (Misc queries) | |||
| Impoting a text file - Excel 2000 VS. 2003 | Excel Programming | |||
Linear Mode
