Good evening:
I try to make a macro in Calc to insert a sheet from a file in .txt
format or .csv using the LO process: Record macro.
I did it but the macro run and stop in the directory where the file is,
but not record the select and not open the sheet although I did when I
recorded the macro.
The code that the process wrotten is this, would you please guide me to
finish:
REM ***** BASIC *****
sub Main
rem
----------------------------------------------------------------------
rem define variables
dim document as object
dim dispatcher as object
rem
----------------------------------------------------------------------
rem get access to the document
document = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
rem
----------------------------------------------------------------------
rem dispatcher.executeDispatch(document, ".uno:InsertSheetFromFile", "",
0, Array())
end sub
I use LibreOffice version 4.2.8.2 on Ubuntu 14.04 LTS
Thanks and Regards,
--
Atentamente,
Jorge RodrÃguez
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
