Excel SaveAs Autogenerated Reference

[TortolaChris]

I’m trying to automatically save quotations generated in Excel in a logical way.

1. Is there a way that I can get Excel to auto suggest a filename based on data in the spreadsheet?

2. Can I pick up the two digit day, month, year and then concatenate that with other info?

3. Is there a way of picking up the upper case letters in a text string and concatenating that with the other info? I’d like to use the originator initials in the filename too.

I am really very stuck!

Thanks for any help

Chris

 

[xlbo]

yup, yup and yup
Use the saveas method
workbook.saveas _ name:="whatevertextstringyouwanttogenerate.xls"

To save as todays date for example

mDate = format(today(),"ddmmyy&quot

mString = "GB"

activeworkbook.saveas name:= mString & mDate

If you give more specifics, I can probably help you but this should give you an indication of what to do

HTH
Geoff

 

[TortolaChris]

Thanks for your advice Geoff. Sorry for not thanking you earlier - been moving.
Thanks again
Chris