Hi,
I was wondering if I could get some help in changing the contents of one single formula for 200 different excel files in the same directory.
I'm new to VBA and I was wondering if you could give me some indications on how to do this. Links would work great too.
Thanks in advance.
Vasco
What is the formula that needs changing? Is it in the same specific cell in all files? Maybe you can attach a couple of the 200 files so we can understand your exact requirements.
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Thanks. I actually just found the answer here.
http://www.rondebruin.nl/copy4.htm
Vasco
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks