I have a question. I'm trying to modify some code I wrote for bulk loading phones.
The phone format is the same across phones, but I need them in individual files.
In my code I loop through cells for each phone and create files.
Set fso = CreateObject("scripting.Filesystemobject")
If CP7911 = True Then
Set objphone = fso.createtextfile("C:\temp\Ph7911.txt")
Set objuserLine = fso.createtextfile("C:\temp\UserLine7911.txt")
Set objuserUpdate = fso.createtextfile("C:\temp\UserUpdate7911.txt")
There are 25 different phones so I have create data sets and file names for all
I load the phone type in a varible is there away I can create something like this:
Set objuserLine = fso.createtextfile("C:\temp\UserLine<phone varible>.txt")
That way I can create the phone type files on the fly.
any ideas?
Thanks,
Mike
Bookmarks