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,

[tdf-discuss] Macro Difficulties

2013-03-07 Thread Charles Jenkins
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 Microsoft Excel. B1 has a toolbar button

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