Selasa, 27 Desember 2011

Re: [ExcelVBA] hi

 

Nishu, it is possible to be flourish with the aid of vba. I suggest you do the following: start with Excel open, press the Macro Record button, and then do all the copying and pasting from your twelve workbooks into the thirteenth one. When all completed, press the Stop recording button. Save you new workbook, and exit Excel, making sure to save your Personal Macro workbook you created the macro in.

Open Excel again, call your macro you recorded with the key shortcut you defined, and celebrate.

Sent from my iPad

On 27/12/2011, at 9:14 AM, "Nishu Kumar" <contactmanish_panwar@yahoo.com> wrote:

> it takes much to open workbook one by one and copy and then past in a new work book. so is it possible to be flourish with the help of VBA codings?
>
> Best Regards,
> Nishu
>
> ________________________________
> From: Nishu Kumar <contactmanish_panwar@yahoo.com>
> To: "ExcelVBA@yahoogroups.com" <ExcelVBA@yahoogroups.com>
> Sent: Tuesday, 27 December 2011 12:28 AM
> Subject: Re: [ExcelVBA] hi
>
>
> Hi David,
>
> Many thanks for writing in and accept my sincere apologies for delay in response.!!!!
>
> kindly checkout the thing which i exactly require:
>
> A procedure where in i can take out a consolidate twelve excel sheets' data simultaneously and store in 13Th excel (which is a blank excel sheet) sheet separately.
>
> Please revert in case i can provide you further information in this regard.
>
> Thanks and regards,
> Nishu
>
> ________________________________
> From: David Grugeon <yahoo@grugeon.com.au>
> To: ExcelVBA@yahoogroups.com
> Sent: Sunday, 11 December 2011 4:11 AM
> Subject: RE: [ExcelVBA] hi
>
>
>
> Needs more info. What do you want to do in the target workbook from the
> source workbook?
> Is the second workbook open when you start the procedure?
> What do you want to start the procedure? A button? An event? If an event
> what event?
>
> Best Regards
> David Grugeon
> Excel VBA Group Moderator
>
> -----Original Message-----
> From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf
> Of Nishu
> Sent: Sunday, 11 December 2011 5:01 AM
> To: ExcelVBA@yahoogroups.com
> Subject: [ExcelVBA] hi
>
> my hearteous greetings to my group,
>
> hello everyone,
>
> since i am writing first time to get knowledge on how to automate one excel
> workbook to another.
>
> would be great assistance if you suggest me with the example and coding as
> well.
>
> Thanks for your all support.
>
> Best Regards,
> nishu
>
> ------------------------------------
>
> ----------------------------------
> Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go
> here: http://www.mousetrax.com/techtrax to enter the ezine, then search the
> ARCHIVES for EXCEL VBA.
>
> ----------------------------------
> Visit our ExcelVBA group home page for more info and support files:
> http://groups.yahoo.com/group/ExcelVBA
>
> ----------------------------------
> More free tutorials and resources available at:
> http://www.mousetrax.com
>
> ----------------------------------Yahoo! Groups Links
>
> [Non-text portions of this message have been removed]
>
>

[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar