Quote:
Originally Posted by Auric__
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!
|
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