import data.xls to an existing excel file

**haidai222** · 09-12-2006, 03:55 PM

I have an existing excel file that I need to update the data in it weekly.

the new data I download weekly is also in .xls format, but contains more column titles than I need. I usually look for the matching column title in the new data file, then copy+paste it manually column by column into my existing file.

I would like to know how I can automate this process?

thanks in advance.

**raypayette** · 09-13-2006, 05:47 AM

Make sure that the new files are structured in a systematic way. Then use the macro recorder to make a macro that you will activate each week.

**haidai222** · 09-14-2006, 03:00 PM

I was thinking if it's possible use VBA to "import data"?

**raypayette** · 09-14-2006, 05:42 PM

Of course VBA can be used to import data such as .XLS files. Use the recorder to mimic what you want, edit the macro and you should get what you want!

import data.xls to an existing excel file

LinkBack

Thread Tools

Rate This Thread

Display

import data.xls to an existing excel file

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions