Hi Everyone,
I need help on how to EXPORT files from View using MS Excel 2007. You see, there’s no lotus 123 available in ms 2007.
Any idea on how to do this?
Thanks so much in advance.
Appreciate your help
Subject: Problem Exporting to Excel
Hi,I wrote a 2 parts article in the march/april issue of The View. In this article I describe a tool that allows import and export to and from Notes databases, using OpenOffice.
If you are not a subscriber, you cannot read this articles, but you can download the database containing it (free) at the following address:
You need to install OpenOffice on your workstation (or on a server) to use the tool.
Subject: Problem Exporting to Excel
Hi , I’m confused … are you looking to export documents to Excel or attachements in the documents to excel ?
Subject: RE: Problem Exporting to Excel
Hi Ravi,
Im also having the similar problem,
will it be possible to export attachments?
If so, could you please let me know.
Regs
Gov
Subject: RE: Problem Exporting to Excel
Hi , Yes , It is possible.You would need to detach the attachments to local drive to achieve this.You can use OLEObjects class with method ADD to attach the file to excel.
I’m not pretty sure with the parameters of this function.You can search in MS sites or you can try with Excel macro.
Subject: RE: Problem Exporting to Excel
Hi , Yes , this can be possible using ActiveSheet.OLEObjects.Add methods.I don’t exactly remember the urguements . You can search for the sytax.
You would need to detach the attachments to the local drive first in order to attach those to excel as object.Better detach to data directory and delete the file after exporting to Excel
Subject: RE: Problem Exporting to Excel
Hi Ravi,
Now atleast I got some idea on how to handle.
thank you so much for your kind information.
Regs
Gov