PC Review


Reply
Thread Tools Rate Thread

Re: Impoting excel sheet to new workbook

 
 
Don Guillett
Guest
Posts: n/a
 
      30th Jul 2012
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
 
Reply With Quote
 
 
 
 
Auric__
Guest
Posts: n/a
 
      30th Jul 2012
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!
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:32 PM.