Hi all,
I'm working on a macro to copy data from excel to powerpoint.
All ok! Charts are copied and resized, I managed to save the PPT file where I wanted. I got stuck in one point.
I'm using the line below to save the file where I want and with the name "I almost Want".
With pptPres
.SaveAs "\\psf\Home\Desktop\ALL\Results\Results_Week_xx.pptx
End With
Can I somehow specify the file to save instead of Week_xx.pptx to save it as
Results_Week_02.pptx?
knowing that the 02 would be referenced from a cell in excel?
For example in my excel file, sheet 1, cell M36 has a week counter, how can I have the value in this cell to be added to the file name when saving?! to get the save as to be Results_Week_02 and so on...
thanks
I'm working on a macro to copy data from excel to powerpoint.
All ok! Charts are copied and resized, I managed to save the PPT file where I wanted. I got stuck in one point.
I'm using the line below to save the file where I want and with the name "I almost Want".
With pptPres
.SaveAs "\\psf\Home\Desktop\ALL\Results\Results_Week_xx.pptx
End With
Can I somehow specify the file to save instead of Week_xx.pptx to save it as
Results_Week_02.pptx?
knowing that the 02 would be referenced from a cell in excel? For example in my excel file, sheet 1, cell M36 has a week counter, how can I have the value in this cell to be added to the file name when saving?! to get the save as to be Results_Week_02 and so on...
thanks
