You’re offline. This is a read only version of the page.
Announcements
5
I am trying to close multiple instances of Excel while saving them into a folder.
My Problem - I am not able to make the UI dynamic so that PADesktop closes the currently active excel file.
I have tried customizing the UI using a dynamic filename by creating a list but it did not work.
Can someone please help me or point me in the right direction.
Thanks
Chandeep
Inside your loop, put this:
It will get the window title: typically Boo1 - Excel.
Windowtitle.Trimmed will make it Book1 or Book1.xlsx...not sure, but it works.
Then, Close Excel saving it to whereever you need calling it whatever you want. If this is a loop for several workbooks, I am sure you have a variable that you would like to put in the filename.
Good luck.
Share
Report
All responses (
Answers (
