Auto Generating File Name

[ncgreyfriars]

Can any body help

I have created a automatic invoice generator which will print the invoice and then clear the invoice and generate the next invoice number

The worksheet consists of 3 spreadsheets Invoice Lookup tables which store the products and clients Invoice list with get a grandtotal of invoice plus key information ie name etc

The Invoice no is situated in cells D1 to E1 but what i would like the macro to do is to copy the invoice only and save it in a directory C:\oldinvoices with a file name of the invoice no ie cells D1 - E1 this will enable me to be able to recreate an old invoice if needs be

I cannot see how this can be done and would appreciate any advise that yon can give me

[tweek333]

Hi there NC

Marco to save a file as a cell thats in your excel sheet is as follows. A1 range would be the directory you want to save in C:/Invoice or whatever and the A2 would be your invoice number

Please Login or Register  to view this content.

But the other things you want it to do is to complex for little old me

Ta

Tweek