kemperohlmeyer
Board Regular
- Joined
- Oct 4, 2006
- Messages
- 73
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
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