Using VBScript with CF

[kathryn]

Good morning, all.

Excuse the very basic nature of this question, but how do I use VBScript with ColdFusion? All the documentation says that the <Script> tag only is for JavaScript.

I am writing a custom tag to put on our server which will convert uploaded MS Office documents to HTML. I know that there are products that do this, but purchasing anything now is not an option. My boss does not like the &quot;Save as HTML&quot; option in Word, and our users are spoiled and have gotten use to posting MS Word and MS Excel documents directly.

The custom tag will:

call VBScript code to create the HTML pages
preview the HTML pages to the user for approval
save the approved pages to the appropriate directory
create a link to the new HTML document on the appropriate WaMuLink page

The VBScript will:
determine the document type
open the document
if the document is Excel
run htmconvert from htm.xla add-in
if the document is Word
get the template name that the document is based on
create one or more text files with embedded HTML tags. The file(s) will then be renamed with an &quot;htm&quot; extension.
create a HTML table of contents page, if more than one HTML page was created

Do I save the VBScript file as a text file of some kind, and then call it like a *.js file?

Any references, resources or war stories on this would be greatly appreciated.

Kathryn

 

[calista]

I'm not sure which version of CF you have,(I've worked with 4.5 and 5.0), but according to my documentation, <SCRIPT> has a language attribute, and VBScript is one of the ones you can specify. JavaScript is the default if a language is not specified.

<script language=&quot;VBScript&quot;>
   your code here
</script>

I've use a little JavaScript, but I've never tried VBScript, so I can't make any promises, but it should work. Calista :-X
Jedi Knight,
Champion of the Force