[libreoffice-users] Trying to make a macro

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: users+unsubscribe@global.libreoffice.org
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