Calling a value in a script 1

[staleb]

Hi

How is the syntax for calling a string-value from a vb-script.

I have:

Sub Document()
dim sPath as string = "\\myserver\test.doc"

Dim script as string
+++

script &= " set Doc = Word.Documents.Open('" & sPAth & "') " & vbCrLf

++++

Me.Page.RegisterStartupScript("Open", script)

End Sub


How do I refference the sPath in my scriptcode?
When I do the way I have described here I get error.
Does anyone know the right syntax

 

[PHV]

I get error
The usual way is to post the error message as, at least for me, the crystal bowls are in vacation.
Anyway, the code you posted is NOT VBScript.
What is your intent ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[staleb]

The error message is just: Syntax error.
Because the script-line is this when it get rendered:
set Doc = Word.Documents.Open('\\myserver\test.doc')

The code is a vb-script I only didnt paste the whole script. It was to long:

Dim script As String
script = "<script language=""vbscript"">" & vbCrLf
script &= " Dim Word" & vbCrLf
script &= " Dim Doc" & vbCrLf
script &= " Set Word = CreateObject (""Word.Application"") " & vbCrLf
script &= " Set Doc = CreateObject(""Word.Document"") " & vbCrLf
script &= " set Doc = Word.Documents.Open('" & sDokNavn & "') " & vbCrLf
script &= " Doc.SaveAs("" & sDokNavnLokalt & "")" & vbCrLf
script &= "</script>" & vbCrLf

Me.Page.RegisterStartupScript("Open", script)



This code is included in a a sub called Document.
And the script works fine if I adress the path directly, but I want to adress it through a variable since there a many documents

 

[PHV]

I didn't know that VBScript is accepting the &= and the Dim ... AS ... syntax...
Anyway, replace this:
script &= " Set Doc = CreateObject(""Word.Document"") " & vbCrLf
script &= " set Doc = Word.Documents.Open('" & sDokNavn & "') " & vbCrLf
By this:
script &= " Set Doc = Word.Documents.Open(""" & sDokNavn & """) " & vbCrLf

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[staleb]

Thanks

I thought I have tried many different syntax's, but I did think about putting three " in a row.
Thanks!!

 

[EBGreen]

So did it work? I still don't see how it could work both the As and the &= cause the script host to choke with compile errors.

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]