asked on

Excel 2007 'File Save As' Macro

I need assistance in writing macro code that will do the following:

Save the contents of a print range and automatically give it a file name based on a specific cell name.

Dave

Do you mean save the contents of a preset print range (on a single sheet?) to a new file?
Cheers
Dave

miasha

ASKER

Basically, I already have written that queries info in my workbook, then based on criteria I set, it copies the results into a specific area on my worksheet. This result is what I will print out. However, I will query multiple times for different info, so the same print range will contain different info each time. So - what I want to do is have the macro save the print range each time and automatically save the file with the name that is in a specific cell. For example, I want the macro to use cell 'U1' as the name of the file (the info in cell 'U1' will change each time I do a query - which is why I want the macro to automatically assign the file name using the contents of cel 'U1.' So basically, I want the macro to:

1) Save the present print range to a new file
2) Automatically assign it the file name of the cell contents in 'U1'.

ASKER CERTIFIED SOLUTION

Dave

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Dave

My solution is valid.

I suggest Excel ZA review if you want a second opinion

Regards

Dave