Re: [tdf-discuss] Macro Difficulties

2013-03-13 Thread Charles Jenkins
Christian, You're right. My attempt to fool with options didn't work at first because I misidentified the file's character set, so I thought the csv in the filter name was significant and embarked on the quest to convert to CSV. Now that I have the right character set, everything works

Re: [tdf-discuss] Macro Difficulties

2013-03-13 Thread Christian Lohmaier
Hi Charles, *, On Wed, Mar 13, 2013 at 4:36 PM, Charles Jenkins cejw...@gmail.com wrote: You're right. My attempt to fool with options didn't work at first because I misidentified the file's character set, so I thought the csv in the filter name was significant and embarked on the quest to

Re: [tdf-discuss] Macro Difficulties

2013-03-12 Thread Christian Lohmaier
Hi Charles, *, On Tue, Mar 12, 2013 at 1:07 PM, Charles Jenkins cejw...@gmail.com wrote: Now if only I can find a way to convert my tab-separated .txt file to a comma-separated .csv file, I think all would be golden. Hmm. Either I'm completely missing the point here, or you do :-) With the

Re: [tdf-discuss] Macro Difficulties

2013-03-11 Thread Charles Jenkins
I'm making some progress. Here's my code so far: == Public Sub OpenExcelFile(excelPath As String) Attempt1: on error goto Fail1 ' snip The Excel method that doesn't work ' under LO, and which I don't own copyright to exit sub Fail1: resume Attempt2

Re: [tdf-discuss] Macro Difficulties

2013-03-11 Thread Christian Lohmaier
Hi Charles, *, On Mon, Mar 11, 2013 at 3:55 PM, Charles Jenkins cejw...@gmail.com wrote: dim dummy() ' Empty array of parameters starDesktop = createUnoService(com.sun.star.frame.Desktop) url = ConvertToUrl( ExcelPath ) doc = starDesktop.loadComponentFromURL( url, _blank, 0,

Re: [tdf-discuss] Macro Difficulties

2013-03-07 Thread Tony Pursell
On 7 March 2013 16:43, Charles Jenkins cejw...@gmail.com wrote: This is a story about the usability of LO BASIC and the documentation thereof. And also a plea for help. I'm trying to get LibreOffice to work with SAP Business One (hereafter called B1) in order to eliminate the need to pay for

Re: [tdf-discuss] Macro Difficulties

2013-03-07 Thread Johnny Rosenberg
2013/3/7 Tony Pursell a...@princeswalk.fsnet.co.uk: On 7 March 2013 16:43, Charles Jenkins cejw...@gmail.com wrote: This is a story about the usability of LO BASIC and the documentation thereof. And also a plea for help. I'm trying to get LibreOffice to work with SAP Business One (hereafter

Re: [tdf-discuss] Macro Difficulties

2013-03-07 Thread Regina Henschel
Hi Charles, Charles Jenkins schrieb: This is a story about the usability of LO BASIC and the documentation thereof. And also a plea for help. I'm trying to get LibreOffice to work with SAP Business One (hereafter called B1) in order to eliminate the need to pay for expensive licenses for

Re: [tdf-discuss] Macro Difficulties

2013-03-07 Thread Jean Weber
The documentation on LO BASIC is so sparse that I can't find anything about opening spreadsheets. The LO help file promises documentation at OpenOffice.org; but clicking that link takes me instead to https://wiki.documentfoundation.org/Documentation/BASIC_Guide, which is a placeholder page