Microsoft Word Help

[Ivan Howard]

Hi All,

I am looking for some help in Microsoft Word...

Using VBA, I need to stop all "Save" or "SaveAs" commands... and if possible - I need to stop all copy text commands.

I am unable to write/convert the file to PDF.

Any ideas?

Thanks very much.

 

[NdNoviceHlp]

Maybe this will help? Dave
http://www.vbaexpress.com/forum/showthread.php?t=16174

 

[Ivan Howard]

Thanks very much Dave - some good reading and lost of helpfull stuff here!

Take care.

 

[Ivan Howard]

Hi All,

I am running a mail merge from an Excel based dataset. There are over 3000 documents (2 pages each) that are to be produced through the merge.

As per the previous post in this thread, I would like to stop people from editing the documents before printing. I have the code to stop saving, selecting all, copying and cutting, etc, but it only works when in the document that you put the code in.

My question is, that as the mail merge currently (and successfully) creates a NEW separate file (using code in the mail merge document) for each of the merged documents, is there a way to merge the data into a 'template' which already contains the saving/copying/cutting code?

I don't know too much about Normal.dot - would this be part of the answer?

Thanks for your help.

 

[NdNoviceHlp]

Maybe create a single report .doc that contains the macros. Code to have the user view the contents of the original document in the report .doc (ie. copy the original contents to the report .doc). It depends on your needs, but a similair process has worked for me. HTH. Dave

 

[Macropod]

Hi All,

I am running a mail merge from an Excel based dataset. There are over 3000 documents (2 pages each) that are to be produced through the merge.

As per the previous post in this thread, I would like to stop people from editing the documents before printing. I have the code to stop saving, selecting all, copying and cutting, etc, but it only works when in the document that you put the code in.

My question is, that as the mail merge currently (and successfully) creates a NEW separate file (using code in the mail merge document) for each of the merged documents, is there a way to merge the data into a 'template' which already contains the saving/copying/cutting code?

I don't know too much about Normal.dot - would this be part of the answer?

Thanks for your help.

Hi Ivan,

You can obviate the need to itercept commands for saving etc, by using code like the following to intercept the mailmerge process itself:

Sub Mailmerge()
With ActiveDocument.Mailmerge
  .Destination = wdSendToPrinter
  .Execute
End With
End Sub

This sends the output direct to the printer, regardless of whether the user wants Word to save the output. Nothing is retained for the user to edit.

 

[Ivan Howard]

Thanks very much Paul and Dave.

The report.doc idea sounds good, but as over 120 people will receive selected merged files, I am not sure if this would work.

I think the solution, albeit something amazing happening, will be producing protected documents in Word and issuing strict instructions that they cannot be changed/Saved As, etc... Oh for an ideal world!

Thanks again for your help.

 

[Ivan Howard]

Hi All,

This post has been answered at the following address:

http://vbaexpress.com/forum/showthread.php?t=35815

Thanks everyone for your help.