dbTalk Databases Forums  

vb script question

comp.databases.pick comp.databases.pick


Discuss vb script question in the comp.databases.pick forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Scott Ballinger
 
Posts: n/a

Default vb script question - 11-08-2005 , 04:30 PM






I have vb scripts (that get executed via accuterm) that include stuff
like...

Set objExcel = CreateObject("Excel.Application")
or
Set objWord = CreateObject("Word.Application")

I want to test these scripts using Open Office.... how do I specify a
non-microsoft spreadsheet or word processor? I'm guessing it's
somewhere in the registry; I've poked around but have can't seem to
find it.

TIA.

/Scott Ballinger
Pareto Corporation
Edmonds WA USA
206 713 6006


Reply With Quote
  #2  
Old   
Brian Speirs
 
Posts: n/a

Default Re: vb script question - 11-08-2005 , 10:23 PM






Wouldn't this be in your standard file associations?

Right click on a doc file, choose 'Open with' and select Open Office.
Tick the box to always use this application to open this type of file.

Cheers,

Brian Speirs

Scott Ballinger wrote:
Quote:
I have vb scripts (that get executed via accuterm) that include stuff
like...

Set objExcel = CreateObject("Excel.Application")
or
Set objWord = CreateObject("Word.Application")

I want to test these scripts using Open Office.... how do I specify a
non-microsoft spreadsheet or word processor? I'm guessing it's
somewhere in the registry; I've poked around but have can't seem to
find it.

TIA.

/Scott Ballinger
Pareto Corporation
Edmonds WA USA
206 713 6006

--
************************************************** *
Brian Speirs
h: (04) 479 9032 c: (021) 265 5906
e: bss59REMOVETHIS (AT) paradise (DOT) net.nz


Reply With Quote
  #3  
Old   
Luke Webber
 
Posts: n/a

Default Re: vb script question - 11-09-2005 , 11:06 PM



Scott Ballinger wrote:
Quote:
I have vb scripts (that get executed via accuterm) that include stuff
like...

Set objExcel = CreateObject("Excel.Application")
or
Set objWord = CreateObject("Word.Application")

I want to test these scripts using Open Office.... how do I specify a
non-microsoft spreadsheet or word processor? I'm guessing it's
somewhere in the registry; I've poked around but have can't seem to
find it.
Um, it's not straightforward. OOo is a very different animal from Microsoft
Office. it has a lot of advantages, but a simple API isn;t one of them.
It's complicated by the fact that OOo is designed to be able to be
driven as a server architecture, with API requests to perform the work
on a different box as required.

Download the OOo SDK and look for the VBScript example. Or if you like,
email me and I'll send it to you as an attachment. It'll be the 1.9.122
version, though.

HTH,
Luke


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.