Save As Automatically

[macspie]

All,

I have the following code:
-------------------------------------
Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

Please Login or Register  to view this content.

------------------------------------------------

This code works to save as with a customer file name but since I'm looping this through several hundred files, I'd like the dialog box to only come up the first time to set the location, then not show up every other time. Any thoughts?

Thanks,

macspie

[6StringJazzer]

You are currently asking the user for a filename. If you want to prompt for the location only, one time, what are you going to use for the file names?

[macspie]

My b on not tagging it.

I figured it out though. I just removed the application.getsaveasfilename loop and replaced the fname with the cell address in each new workbook.

Thanks guys.