Hello to everybody!!! As you can get from the title of my post, i’m very angry!!! I’ve lost all the working day to solve the following problems wasting my time:1) i have a form where a user can create a file excel from, in the excel file there must be the tool to convert it in PDF…so one have to install PDFmaker…but when you open the excel file through script with OLE, well, PDF icons don’t appear on excel Bar!!!
- solution: i create the excel file with OLE so i can also populate it with some values from notes, then, i close excel and re-open it (in the same sub of course…)with shell API that seems to open it correctly. PROBLEM: Excel task is always active unless i esc from script!! So shell API can’t open the file from disk 'cause OLE creation still leave a task active.
I used Excel.quit, excel.application.quit, wotkbooks.close(false,“”,false)…nothing!!
If someone has a solution…i’ll be glad to offer him some good pints of beer.
Have a nice week-end…i’m exausted and i’ll drink over it for sure.
Regards, Daniele
Subject: look in Notes/Domino 4 & 5 forum
for example this thread
Subject: RE: look in Notes/Domino 4 & 5 forum
Thanks for your help Andrey, i tested the script you linked me to, and it works in the sense that it detect an Excel window still open.
Anyway, the problem now would be to find an appropriate API function to close this window (i tried “DestroyWindow” but it doesn’t seem to work) and this could ask some time…so i’ll probably give up following the solution i posted previously in this thread…I appreciate your help anyway and i thank you once again.
Regards, Daniele.
Subject: How about attaching the Excel file?
Instead of using OLE, how about using LotusScript to create an Excel file (containing the appropriate values from Notes) and ATTACH it to the Notes document. Then the user can open the file (in Excel) and run the PDFmaker.
Subject: RE: How about attaching the Excel file?
Thanks for your response Lawrence. you’re right, it’s exactly what i’m going to do…i can’t see any other solutions…well, maybe someone better than me in programming could work around the problems i raised…just to make Notes always a better and performing tool.
Anyway, have a nice week guys, see you soon.
Regards, Daniele.