Hi,
I am stuck with this bit of my code. Any help would be greatly appreciated!
The macro I am running loops through a list of values, does some calculations and then generates a report of these calculations. After saving this report it loops back to the next value in my list and repeats the process. So far so good.
I would like the saving to be automated, but I can't figure out how to do that.
What I want is the following:
'ask user for save folder (the destination in which all report files should be saved)
'save this destination as a variable
'do a bunch of stuf
'generate report name
'generate save path by pasting the destination variable and the report name (savefileas destination&"/"&reportname)
'save it!
I can't figure out how to get the destination-variable without any unnecessary lines attached.
Any suggestions?
I am stuck with this bit of my code. Any help would be greatly appreciated!
The macro I am running loops through a list of values, does some calculations and then generates a report of these calculations. After saving this report it loops back to the next value in my list and repeats the process. So far so good.
I would like the saving to be automated, but I can't figure out how to do that.
What I want is the following:
'ask user for save folder (the destination in which all report files should be saved)
'save this destination as a variable
'do a bunch of stuf
'generate report name
'generate save path by pasting the destination variable and the report name (savefileas destination&"/"&reportname)
'save it!
I can't figure out how to get the destination-variable without any unnecessary lines attached.
Any suggestions?