Variable into new file name

K

krayten

Hi everyone,

I am using UserForm3 to gather information for the procedure below.
UserForm3.TextBox4.Text is the filename which my user will have chosen
to use.


I am assigning it a variable name ( filename = UserForm3.TextBox4.Text
).


Please, can someone tell me how to get that variable into the
CreateTextFile
action below, as I am currently stuck using a fixed filename of
customscan.cmd which
is inflexible.


I know that this code is probably extremely ugly - but I am just
starting with xlVBA and
learning all the time :))


scan_with_sccs:
' Create the custom scanner .cmd file & populate with choices from
userform3
Set fs = CreateObject("Scripting.FileSystemObject")
Set a = fs.CreateTextFile("C:\Hotfixer\customscan.cmd", True)
a.WriteLine "cd \Hotfixer"
a.WriteLine ""
a.WriteLine "HfNetChk -h " & HostName _
& " -u " & UserID _
& " -p " & Pass _
& " -s 2 -nosum" _
& " -fq ""C:\Hotfixer\sccsignore.txt""" _
& " -f ""C:\Hotfixer\Results\customscan" & ".txt""" _
& " -x ""C:\Hotfixer\mssecure.xml"""
a.Close
GoTo scan_now


Many thanks,


Stuart
 
B

Bob Phillips

& " -f ""C:\Hotfixer\Results\" & filename & ".txt""" _

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
M

Martin Yirrell

Have you tried

Set a = fs.CreateTextFile("C:\Hotfixer\" & filename, True)

Martin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top