Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / January 2006

Tip: Looking for answers? Try searching our database.

Using quotes in the documents.open command

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Edward - 24 Jan 2006 02:25 GMT
When I capture the file:open sequence in a macro, it shows the filename: in a
triple set of quotes.
I'm writing a macro to cycle through a bunch of files, opening each one,
adding headers and footers, and closing and saving, and wanted to use the
code captured in the macro recorder for file:open in the macro.  I had to
choose a file to  open to  be able to end the macro recorder, and when I
looked at the generated macro code, there ws the filename in a triple set of
"""quotes"""

Do I need to use any quotes?  One set? Two sets? No sets?  Why did the macro
generate three sets of quotes?

Also, isn't it possible to use dot notation to set the filename ?

Thanks
Signature

Phantom Researcher

Doug Robbins - Word MVP - 24 Jan 2006 05:07 GMT
Modify the code in the article "Find & ReplaceAll on a batch of documents in
the same folder" at:

http://www.word.mvps.org/FAQs/MacrosVBA/BatchFR.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> When I capture the file:open sequence in a macro, it shows the filename:
> in a
[quoted text clipped - 14 lines]
>
> Thanks
Edward - 24 Jan 2006 16:03 GMT
Actually, I have a working algorithm, but was just curious about the weird
syntax of three sets of quotes.  Turns out I discovered that the variable
holding the filename doesn't need to be in quotes, which makes sense, but
three sets of quotes around a filename is really confusing.
Signature

Phantom Researcher

> Modify the code in the article "Find & ReplaceAll on a batch of documents in
> the same folder" at:
[quoted text clipped - 19 lines]
> >
> > Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.