> ... one of the associate in our org has done automation project ...
So talk to this associate and get a copy of what he has done. It will give
you far more information than a few e-mail replies could.
> ... on the same ...
Are you saying he's already done EXACTLY what you want to do? Then why are
you asking us? Ask him. !!!
Regards, Dave S
----- Original Message -----
From: "Nishu Kumar" <contactmanish_panwar@yahoo.com>
To: <ExcelVBA@yahoogroups.com>
Sent: Wednesday, July 11, 2012 12:44 AM
Subject: [ExcelVBA] Consolidation of Excel spread sheet
Hi Group,
Hope this mail finds you doing well!!
Would like to grab this opportunity to learn as how can i consolidate more
than 15 excel spreadsheet data into one workbook. Would also like to share
one experience that was seen by me, one of the associate in our org has done
automation project on the same which i have just said. so what the
automation is, i am now try to explain you in the below bullets:
1. He opens a workbook (automated one) and mentioned the path in a
particular cell (where all the excel sheets are residing with data).
2. He go to the another tab of the same workbook and press a button and
then.....'booom, all the spreadsheets open one by one, closed automatically
and stores the data in the automated workbook. Isn't so great...
In just two steps consolidation is done...and this is exactly i want to
learn through my group. Here is one thing i am very new to VBA and require
great assistance from your side.
Thanking in anticipation.
Regards,
Nishu
[Non-text portions of this message have been removed]
------------------------------------
----------------------------------
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
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1424 / Virus Database: 2437/5123 - Release Date: 07/10/12
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
----------------------------------
Tidak ada komentar:
Posting Komentar