Not sure how you are presently performing the task. A macro can be writen to
open the file directly without doing any searches for example see below. Not
sure from youor description if the file(s) the data about the sales is the
same file that you want to do the Saveas or if you want to create a new file
with the updated info.

Folder = "C:\temp\"

for each Ws in thisworkbook.sheets
Invoice = Workbooks.open(filename:=Folder & Ws.name)

'perform your operations


Invoice.close

next Ws

"Bev" wrote:

I have a large number of worksheets (invoices!) I wish to save them to a
specific folder which as it happens has the same name (number) as the invoice
and already contains data about the sale. Is there anyway I can save these
worksheets without having to go through 'the save as' procedure and search
for a thousand files etc?
--
Bev