Using VBA

[Craige Harper]

Hello,
Working with Excel 2003.......
Need to know how to create a new file using the following to create the new file name
1. Cell C4 Value
2. Constant "_"
3. Current Date expressed as MMDDYY
4. Constant "_"
5. Cell C7 Value

I know nothing about VBA, but I'm willing to leaning.
Thanks

 

[kpark91]

Well, you can first take a look at

Application.SaveAs

to concatenate those five values:

strPath = Range("C4").Value & "_" & NOW() & "_" & Range("C7").Value

You will need to find out how to get current date expressed in MMDDYY without NOW()

 

[njimack]

You will need to find out how to get current date expressed in MMDDYY without NOW()

Fomat(Date,"MMDDYY")