|
-
Jan 16th, 2000, 12:47 PM
#1
Thread Starter
Lively Member
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
-
Jan 16th, 2000, 12:56 PM
#2
Member
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).]
-
Jan 16th, 2000, 01:57 PM
#3
Thread Starter
Lively Member
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
-
Jan 16th, 2000, 02:08 PM
#4
Lively Member
not sure of your code i have something similar i wrote
Filename = Filename & ".doc"
that DOES work
later,
Iceman
-
Jan 16th, 2000, 02:34 PM
#5
Lively Member
that error means that the object variable "newname" does not exist.
-
Jan 16th, 2000, 04:29 PM
#6
Lively Member
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]
-----------------------
-
Jan 17th, 2000, 03:11 AM
#7
Thread Starter
Lively Member
Thanks marting the file helped show me the error of my ways.
Mike
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|