Impoting excel sheet to new workbook

K

kumark

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 m
desktop and import all the 7 sheets from the source Workbook.


Regards
Kuma
 
D

Don Guillett

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

Have you considered using saveAS
 
K

kumark

Auric__;1604188 said:
Don Guillett wrote:
-

Or copying the existing file?






Sub ImportTemplate()
FileCopy "c:\Adventure.xlsm", _
ActiveWorkbook.Path & "Adventureworks.xlsm"

Name "C:\WorkedAdventist.xlsm" As "C:\Documents and Settings\Al
users\Desktop\Adventist.xlsm"
End Su
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top