Re: Impoting excel sheet to new workbook

's Computer Specifications

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

's Computer Specifications

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!

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
impoting Access Data to Excel	celica06	Microsoft Access VBA Modules	1	12th Jul 2008 02:45 PM
Impoting photos7 in Excel VBA	Sb	Microsoft Excel Discussion	1	4th Apr 2008 11:33 PM
Impoting data from Sheet 1 to Sheet 2	=?Utf-8?B?YS1sZWFubw==?=	Microsoft Excel Misc	1	20th Apr 2005 01:05 AM
impoting table content to Excel	nilesh	Microsoft Access External Data	1	28th Sep 2004 12:58 PM
Impoting a text file - Excel 2000 VS. 2003	=?Utf-8?B?VG9tZXI=?=	Microsoft Excel Programming	0	29th Dec 2003 02:06 PM