dynamic filenames

[kemperohlmeyer]

I am writing a macro that saves multiple sheets after each one is calculated from a list.

ie, the sheet calculates, is exported as a webpage, new data pulled, calculated, exported etc.

How do i make the filename it is exported as reflect the data pulled in. For example if the data is from a company called KO the file should be named KO.

Thoughts?

Kemper

 

[lozzablake]

you define a variable as a string. You assign the company name to the string (plus any other test you want) and then save the file using the variable as the filename eg:

Dim strFileName as String

strFileName=Range("a1")

thisworkbook.saveas filename:=strFileName

etc