Document save question

P

Patrick C. Simonds

Hi I would like to re-ask this question:

I need some code which will allow me to save the active document to
C:\Temp, the name of the document will include contents of TextBox1
(which will be located on UserForm8, which will be open) and then some
standard naming. Something like this:

C:\Temp\XXXXX, Eligibility Data.doc

XXXXX would of course be the contents of TextBox1 on UserForm8.




---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 000756-1, 07/13/2007
Tested on: 7/14/2007 3:01:43 PM
avast! - copyright (c) 1988-2007 ALWIL Software.
http://www.avast.com
 
D

Doug Robbins - Word MVP

In my previous response, I thought you were using a document with
FormFields. If TextBox1 is a control on a userform, then you would use

ActiveDocument.SaveAs "C:\Temp\" & TextBox1.Text & "Standard wording that
would be better if it did not include a comma.doc"

I would also suggest that you change the names of the controls on your
userform to ones that indicated their purpose.

--
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
 
R

R. Choate

Hi,

You can also have it save to a network drive or have it open the save dialog for the user to browse to the save location.
Additionally, you can open the save dialog (programmatically) and automatically select part of the path for the user.

Richard
--
RMC,CPA


Hi I would like to re-ask this question:

I need some code which will allow me to save the active document to
C:\Temp, the name of the document will include contents of TextBox1
(which will be located on UserForm8, which will be open) and then some
standard naming. Something like this:

C:\Temp\XXXXX, Eligibility Data.doc

XXXXX would of course be the contents of TextBox1 on UserForm8.




---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 000756-1, 07/13/2007
Tested on: 7/14/2007 3:01:43 PM
avast! - copyright (c) 1988-2007 ALWIL Software.
http://www.avast.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Saving a document 3
Calendar output 1
Multipage UserForm 3
Spell check a TextBox 2
Set ActiveDocument Variable 13
How do you hide ..... 2
Template macro 0
outlook 2003 inbox 2

Top