-
Evening Gentlemen,
I have a batch process program that I am creating, and I have hit a wall. I have a string that I created from a listbox and I need to rename it so the file will save as "samename" but with a .doc extension.
'Here is the string with filename
List2.list(cnr)
newname = (List2.List(cnr)_______.doc
Set swApp = Model.SaveAs2(newname, 0, True, True)
Any help would be greatly appreciated
Mike
-
Just use a & or + inbetween the name of the document and the extension.
------------------
David Underwood
Cannabatech Corporation
ICQ - 14028049
E-mail - [email protected]
[This message has been edited by X_Darknight_X (edited 01-17-2000).]
-
tried using this:
newname as Object
newname = (list2.list(cnr) + ".doc")
I get a "object variable or with block variable not set" Error Message
anything else to convert this please!!!!!
Mike
-
not sure of your code i have something similar i wrote
Filename = Filename & ".doc"
that DOES work
later,
Iceman
-
that error means that the object variable "newname" does not exist.
-
Copy the link below, past it into browser.
When there download the file called junk.exe
When done downloading, double click on it and it well extract itself.
In there is a test project that will demonstrate how to do what i think you are trying to do.
http://www.freedrive.com/ASP/PostFol...sp?fsc=2574178
Hope it helps.
------------------
-----------------------
Maartin
[email protected]
-----------------------
-
Thanks marting the file helped show me the error of my ways.
Mike