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

[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())