Save As FileName

[nousername]

Here is my problem.

If a user selects "save as," I want to pre-populate with a value. The value should come from C2, B2 and A2.

C2 = systemName
B2 = string
A2 = date (user inputed. Format: mm/dd/yyyy Example: 03/11/2008)

I want the fileName format to be C2_B2_A2.xls

How can this be accomplished?

Thanks in advance for any help!

[shg]

Maybe like this in the ThisWorkbook module:

Please Login or Register  to view this content.

A2 = date (user inputed. Format: mm/dd/yyyy Example: 03/11/2008)

You can't have slashes in filenames.

[nousername]

Your code works great.

Is there a way to prevent this code from being called if one of the cells (A2,B2 or C3) are null (empty)?

[shg]

Please Login or Register  to view this content.

returns True if the cell is empty. Can you handle it from there?

[nousername]

Sadly I am not a Excel guru, so I cannot handle it from here. I tried adding the code, but it failed.

If any of the fields (A2, B2, C2) are empty then the default workbook name should be displayed.

Please Login or Register  to view this content.

[shg]

Time to start learning:

Please Login or Register  to view this content.

You fill in the blanks.

[nousername]

This code works:

Please Login or Register  to view this content.

[shg]

Good job