Referencing filename in a saveas function

I have several hundred spreadsheets that have some minor editing (removing columns and such) that is the same across the board. I had no problems getting a macro setup to do this. Then I thought rather than saving every file manually with "Revised" after the filename, I could build this into the macro.

The problem is, I don't know how to get the filename in as a variable. Everything I have seen has referenced the file name as a static, or worse yet, user inputtable value. Yikes!

While we are on the subject, what is needed to get the macro sets up so it opens a file, runs through the steps, saves, closes, and moves on to the next in the directory?

If you looping through workbooks maybe

Please Login or Register  to view this content.

VBA Noob

When I try above, it generates "Compile Error: Expected Function or variable".

See attached error screen... thoughts?