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

ThisWorkbook.Name

VBA Noob

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

See attached error screen... thoughts?