Re: [tdf-discuss] Macro Difficulties

2013-03-13 Thread Christian Lohmaier
Hi Charles, *, On Wed, Mar 13, 2013 at 4:36 PM, Charles Jenkins 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 convert to C

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 perfe

Re: [tdf-discuss] Macro Difficulties

2013-03-12 Thread Christian Lohmaier
Hi Charles, *, On Tue, Mar 12, 2013 at 1:07 PM, Charles Jenkins 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 properties, you

Re: [tdf-discuss] Macro Difficulties

2013-03-12 Thread Charles Jenkins
Thank you very much, Eduardo and Christian. I guess I misread that post I linked to, because it left me with the impression that creating those properties couldn't be done in regular VB. Now if only I can find a way to convert my tab-separated .txt file to a comma-separated .csv file, I think

Re: [tdf-discuss] Macro Difficulties

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

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 ' The Excel method that doesn't work ' under LO, and which I don't own copyright to exit sub Fail1: resume Attempt2 Attempt2:

Re: [tdf-discuss] Macro Difficulties

2013-03-11 Thread Charles Jenkins
Thank you, everyone who offered help with my macro problem in trying to make a worksheet that will open another file as a worksheet. With the live doc link, I found what I think I need and altered the existing macro to try the Excel way first, then with the help of ON ERROR GOTO, try to open t

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 placeho

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 Micros

Re: [tdf-discuss] Macro Difficulties

2013-03-07 Thread Johnny Rosenberg
2013/3/7 Tony Pursell : > On 7 March 2013 16:43, Charles Jenkins 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

Re: [tdf-discuss] Macro Difficulties

2013-03-07 Thread Tony Pursell
On 7 March 2013 16:43, Charles Jenkins 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 expensive li