Can I assign the value of a variable to a filename ?

[Ronny Sigo]

Hello all,
I have made a form which takes input from the user (things like name,adress,
reference number and so on). After filling in the form, the user presses a
button. The program then takes all the values out of the controls, opens MS
Word and uses these values to compose a letter with all the data pre-filled
in. Now my question is : Can I make a variable, containing some text which
comes out of the controls of the form and use this variable to define the
filename?
do it would look like :
*****
Me!Myform!Textbox1.value = "Myname"
Me!Myform!Textbox2.value= "EG"
Me!Myform!Textbox3.value= "JK"
Dim sNameFile as String
sNameFile = Me!Myform!Textbox1.value & "_"& Me!Myform!Textbox2.value & _
"_" & Me!Myform!Textbox3.value
*****
So now sNameFile contains the name with which the file shoul be saved. Thus
on disk, in the explorer the file should look like : Myname_EG_JK.doc
Is this possible and what is the correct syntax ?
Save as .............
Can anybody help me with this ?
Thanks !!!!

[Pieter Linden]

"Ronny Sigo" <ro********@skynet.be> wrote in message news:<3f***********************@reader0.news.skyne t.be>...

Hello all,
I have made a form which takes input from the user (things like name,adress,
reference number and so on). After filling in the form, the user presses a
button. The program then takes all the values out of the controls, opens MS
Word and uses these values to compose a letter with all the data pre-filled
in. Now my question is : Can I make a variable, containing some text which
comes out of the controls of the form and use this variable to define the
filename?
do it would look like :
*****
Me!Myform!Textbox1.value = "Myname"
Me!Myform!Textbox2.value= "EG"
Me!Myform!Textbox3.value= "JK"
Dim sNameFile as String
sNameFile = Me!Myform!Textbox1.value & "_"& Me!Myform!Textbox2.value & _
"_" & Me!Myform!Textbox3.value
*****
So now sNameFile contains the name with which the file shoul be saved. Thus
on disk, in the explorer the file should look like : Myname_EG_JK.doc
Is this possible and what is the correct syntax ?
Save as .............
Can anybody help me with this ?
Thanks !!!!

Ronny,
sure. This is cake. You just build the filename (be sure to include
the full path), so your full path would be something like:

C:\Dir1\SubDir1\Filename.doc

as long as you have that built, you can pass that value to your Word
automation stuff and just do something like

appWord.SaveAs strSaveFile

(Sorry, can't remember the exact syntax in Word...)

HTH a little,

Pieter

[Ronny Sigo]

Thank you :)
I will only be able to try this tomorrow, but I am sure this will work !

"Ronny Sigo" <ro********@skynet.be> wrote in message
news:3f***********************@reader0.news.skynet .be...

Hello all,
I have made a form which takes input from the user (things like name,adress, reference number and so on). After filling in the form, the user presses a
button. The program then takes all the values out of the controls, opens MS Word and uses these values to compose a letter with all the data pre-filled in. Now my question is : Can I make a variable, containing some text which
comes out of the controls of the form and use this variable to define the
filename?
do it would look like :
*****
Me!Myform!Textbox1.value = "Myname"
Me!Myform!Textbox2.value= "EG"
Me!Myform!Textbox3.value= "JK"
Dim sNameFile as String
sNameFile = Me!Myform!Textbox1.value & "_"& Me!Myform!Textbox2.value & _
"_" & Me!Myform!Textbox3.value
*****
So now sNameFile contains the name with which the file shoul be saved. Thus on disk, in the explorer the file should look like : Myname_EG_JK.doc
Is this possible and what is the correct syntax ?
Save as .............
Can anybody help me with this ?
Thanks !!!!