Jump to content
Sign in to follow this  
Ujo

Excel Help

Recommended Posts

Ujo

Hello all,

All this while i was just reading the scripts - and to tell you frankly i am addicted to this forum.

I need a small script - i have a folder containing many MS Excel files the script i am looking for should copy the contents of all individual files and paste them in one master excel file

Thanks

Ujwal

Share this post


Link to post
Share on other sites
flyingboz

Your problem description is vague or nonexistent.

One relatively simple method would be to:

Open DestinationFile

for each xls file:

open w/ excel

Append file contents to DestinationFile

close xls file


Reading the help file before you post... Not only will it make you look smarter, it will make you smarter.

Share this post


Link to post
Share on other sites
PsaltyDS

All this while i was just reading the scripts - and to tell you frankly i am addicted to this forum.

I need a small script - i have a folder containing many MS Excel files the script i am looking for should copy the contents of all individual files and paste them in one master excel file.

If you want somebody to write it for you, go to Rent-a-Coder in my sig.

If you want to learn to write it yourself, tell us where you are on the project:

Have you coded a loop to search the folder and list the files to operate on?

Have you used the ExeclCOM_UDF from Locodarwin?

Have you ever used COM objects before?

:)


Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law

Share this post


Link to post
Share on other sites
Paulie

Hello all,

All this while i was just reading the scripts - and to tell you frankly i am addicted to this forum.

I need a small script - i have a folder containing many MS Excel files the script i am looking for should copy the contents of all individual files and paste them in one master excel file

Thanks

Ujwal

Oddly, i have created a program that does just this for work before.

Make sure you are writing to the next empty cell and not overwriting anything.

The _ExcelCOM UDF Lib. from Locodarwin is DEFINITELY the way to go.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.