Macro to open file, copy paste as values and save as excel html

Hi, any help with the following would be greatly appreciated:

I have a folder containing 40 single sheet excel workbooks and I would like to automate following tasks:
- Open each excel file (need to open the file so as to update it since it gets the data from another workbook through =formulas)
- Copy paste as values
- Save this as excel html in the same folder as original excel files (keeping the original file name)
- Close (original excel file should not be changed ie formulas should remain in place, only the html file will contain values)
- Since there will always be xHtml files with same name need the macro to replace the excisting file

My abilities with excel are limited to functions, no VBA knowledge other than finding ready codes and pasting them in the module.

Since this routine is to be run almost daily the macro should run all files, instead of one by one.

I just hope that I am not asking too much for excel to handle and I hope that explanation is clear.

George

Windows XP Pro, Office Pro 2003

Note: I wonder whether a solution could be to record a macro for each file and create another macro to run all the others. But then again I need help with the macro to run the other macros.

Put this code into a new module in a blank workbook, then run it. Be sure to edit the fPath at the top of the macro to the correct path to your files.

Please Login or Register  to view this content.

My fPath had a \ at the end. Did yours?

Download the code above again, I made a small tweak that may help.

Try again:

Please Login or Register  to view this content.

Sorry, I have no idea.

Glad to help where I could.

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated. It is found across from the "time" in each of our posts.)

i need to run a macro to open more than 1000 excel files in one folder to add 3 rows in diff location at each file and save the file and open the next file to do the same
note all file are protected with one password "same at all files"

i wish to receive your replay asap

thx in advance

worth mentioning that my knowldage wit
h VB is 0

Originally Posted by moh_zah99

i wish to receive your replay asap

Is that your wish? Then why did you post question where virtually no one will ever see it? In someone else's thread? Not only is that against the rule, you shot yourself in the foot. New threads gets the most attention, not ones with 10 replies already on the original topic.

First of all, welcome to the forum. Secondly, be sure to read through the Forum Rules so you can use and follow them effectively. You broken rule #2 on your first post, not a good start, eh?