Variable Storing a Document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve C - 24 Aug 2005 17:21 GMT

I wish to use a variable to identify and insert an existing Word document
(7A.doc) into another. 7A.doc is stored in the location G:\Sample. If my
variable is called Category and stores the value "7A.doc", I am experiencing
a "Run-time error 5174 File could not be found" when I use it as follows:

Selection.InsertFile FileName:="G:\Sample\Category", Range:="",
ConfirmConversions:=False, Link:=False, Attachment:=False

What am I doing wrong? Thanks!

Steve C

Reply to this Message

Chuck Henrich - 24 Aug 2005 17:40 GMT

FileName:="G:\Sample\Category" means you want to insert a file named
"Category" in the G:\Sample directory.

Your variable "Category" would need to be a string (because the FileName
parameter is a string, so you'd need to declare it properly:

Dim Category as String
Category = "G:\Sample\7A.doc"

Then you'd use it as follows:

Selection.InsertFile _
FileName:=Category, _
Range:="", _
ConfirmConversions:=False, _
Link:=False, _
Attachment:=False

(note: no quotes around Category).

Signature

Chuck Henrich
www.ProductivityApps.com

> I wish to use a variable to identify and insert an existing Word document
> (7A.doc) into another. 7A.doc is stored in the location G:\Sample. If my
[quoted text clipped - 7 lines]
>
> Steve C

Reply to this Message

Steve C - 24 Aug 2005 18:38 GMT

Thanks for the help, Chuck!

> FileName:="G:\Sample\Category" means you want to insert a file named
> "Category" in the G:\Sample directory.
[quoted text clipped - 27 lines]
> >
> > Steve C

Reply to this Message

Rate this thread: