Page 2 of 2

Re: [Solved] Calc: copy data from a spreadsheet to another

Posted: Tue Oct 13, 2015 2:45 pm
by MATT.B
Dim Doc
Dim url as string
dim myfilename as string
dim mypath as string
mypath = "c:\foldername\"
myfilename = "filename"
url = ConvertToUrl(MyPath & MyFilename & ".ods") ,OR url = ConvertToUrl("c:\PATH\FILENAME.ODS")
Doc = starDeskTop.loadComponentFromUrl (Url, "_blank", 0, Array())