I am looking for a solution to import a word file into a Notes document. I have been searching this forum for solutions to link Lotus Notes and Excel and found some code which allows to send e-mails directly from Excel.
Nonetheless, my objective is not to send an e-mail but to leave that document in a Notes database. Final result should include the excel in attachment and the whole content in the "body" of the document.
Because i would like the final document to have text and tables i used the similar code has the one in the thread in this forum to include text from excel as Ritch text that used a temporary word file.
If i import this file (via File>Import in notes) i get what i want, but i would like to do everything in one step without having to go to lotus notes and do it manualy. If i use Paste in the body, the final result will appear with the excel greedline.
Does anyone has a solution? I now that Lotus notes 8.5 uses a command name [FileImport] but i am unable to make it run under VBA.
Thanks in advance
Bookmarks