Is It Possible to Update Cells of Multiple Files?

**elgourmet** · 07-27-2010, 02:07 AM

hello again

the last time i was posting here, i had a question about updating headers in multiple worksheets. Teylyn offered me some great advice - at this point I'd like to say thanks again. I built up a lot on this code, and it really helps me every day.

I'm still working on multiple updates of various tables, sheets, cells, headers....
however, today i've come across a challenge which I am not able to pass alone

I'm trying to achieve the following:
I have 5 excel FILES in a folder.
what i would like to do now is to update a certain cell (or the header, doesnt matter..) in all 5 files. is this even possible with VBA?

starting with the code from the last post, i think the line with the activeworkbook-code is where the change has to be. the problem is that i don't know where to start

any help or advice would be very much appreciated!

Please Login or Register  to view this content.

**antoka05** · 07-27-2010, 02:56 AM

You could use this code:

Please Login or Register  to view this content.

Regards,
Antonio

**elgourmet** · 07-27-2010, 08:06 AM

thank you very very much, antonio!

unfortunately, i'm always getting the error "Path not found", even I am sure that the path is 100% correct.

any ideas?

**elgourmet** · 07-29-2010, 01:50 AM

i've managed to fix the path problem

one more question though: is there a way to define the path to an exact file in excel which shall then be upated?

**elgourmet** · 08-02-2010, 01:47 AM

anyone?

**ajaykgarg** · 08-02-2010, 02:06 AM

Your question isn't clear.

**elgourmet** · 08-02-2010, 02:17 AM

oh ok, sorry!

i'll try to explain it a little bit more detailed:

Please Login or Register  to view this content.

i'd like the path to be replaced by a variable.
like having the path in cell A1

Please Login or Register  to view this content.

i'm sure this is rather simple, yet these simple things are sometimes upon me

**ajaykgarg** · 08-02-2010, 02:22 AM

This should do it

Please Login or Register  to view this content.

hth
Ajay

**elgourmet** · 08-02-2010, 02:43 AM

thank you so much! you just made my day :D
one last question though: how can I update a cell instead of the header?

Please Login or Register  to view this content.

**ajaykgarg** · 08-02-2010, 02:47 AM

I am not sure what you mean by "instead of the header", but following will update/set a cell value:-

Please Login or Register  to view this content.

hth
Ajay

**elgourmet** · 08-02-2010, 02:54 AM

mhmm, thanks. i thought so, but somehow it doesnt work:
ws.Range("A2") = ActiveWorkbook.Sheets("Tabelle1").Range("=A20")

i dont get an error, but it just doesnt work

**ajaykgarg** · 08-02-2010, 03:08 AM

replace Range("=A20") with Range("A20")

**elgourmet** · 08-02-2010, 03:38 AM

this didnt work either

i'll post the whole macro once again, maybe you can spot the error? :-/

Please Login or Register  to view this content.

**ajaykgarg** · 08-02-2010, 04:18 AM

Sorry, I am not sure why this does not work.

**elgourmet** · 08-02-2010, 05:14 AM

ok. still, thanks a lot for your input!!

**elgourmet** · 08-02-2010, 09:14 AM

i've managed to fix the problem! my bad

you can mark this thread as SOLVED. thanks again for all the help, you are great!

**ajaykgarg** · 08-02-2010, 09:23 AM

You need to mark this thread as SOLVED by editing first post in advanced mode.

Is It Possible to Update Cells of Multiple Files?

LinkBack

Thread Tools

Rate This Thread

Display

Is It Possible to Update Cells of Multiple Files?

Re: Is It Possible to Update Cells of Multiple Files?

Re: Is It Possible to Update Cells of Multiple Files?

Re: Is It Possible to Update Cells of Multiple Files?

Re: Is It Possible to Update Cells of Multiple Files?

Re: Is It Possible to Update Cells of Multiple Files?

Re: Is It Possible to Update Cells of Multiple Files?

Re: Is It Possible to Update Cells of Multiple Files?

Re: Is It Possible to Update Cells of Multiple Files?

Re: Is It Possible to Update Cells of Multiple Files?

Re: Is It Possible to Update Cells of Multiple Files?

Re: Is It Possible to Update Cells of Multiple Files?

Re: Is It Possible to Update Cells of Multiple Files?

Re: Is It Possible to Update Cells of Multiple Files?

Re: Is It Possible to Update Cells of Multiple Files?

Re: Is It Possible to Update Cells of Multiple Files?

Re: Is It Possible to Update Cells of Multiple Files?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions