Hi there,

i want to make a save as macro

the save file needs to have a pre set filename but it needs to include the weeknumber from a cell
in the cell i use a formula to get the weeknumber from a date.

Example:
when i click a macro button called Save File, there should be a save file created at a pre set location like a Desktop folder with a filename like Weeklist: including the weeknumber from lets say cell a1
so the filename will be: Weeklist: 49.xls


is it also possible to get the text of 2 different cell's
example:
a1 contains the weeknumber
a2 contains the name of a person

Filename will be Weeklist of: (a2) Week: (a1).xls