Hi all,
I thought I'd seen the last of having to integrate Word and Excel reports with Lotus Notes but sadly not!
Here's the problem. We use an electronic document and record management system (EDRMS) called TRIM that basically forces users to save their Word and Excel documents in a central storage facility rather than on their own hard drives.
Some of our Lotus Notes applications have functions for exporting data in Word or Excel format and while TRIM always catches Word documents created in this way, it doesn't do the same for Excel spreadsheets. I've been asked to find out why since I wrote the export facilities in the first place (although I found the Excel one on bluestream.org at the time).
I don't know if this is an Excel problem, a TRIM problem or a Notes problem but I thought it was worth asking if anyone here had any ideas. I'll post the same question on the notes.net forum and see if that helps too. Here's the code that launches Excel:
[vba]Set xl = CreateObject("Excel.application")
Set xlWbk = xl.Workbooks.Add
Set xlSheet = xlWbk.Worksheets(1)
Call xlSheet.Activate[/vba]
That looks like pretty standard code to me so I'd be surprised if there's some other way of doing it that would make a difference in this situation.
Is there something I'm missing? Excel opens fine and saves fine to the local machine. TRIM should intercept any save of a new Office document and it does, when an Excel spreadsheet is created manually. It just doesn't seem to catch it when Excel is launched programatically.
Any thoughts or suggestions gratefully appreciated!