How do I break links in a Word doc from Access?

[Guest]

Hello,

I have been learning to control Excel and Word from Access using VBA and
references to these two apps. I've had pretty good success, but I ran into
one, stubborn problem. My Access application uses the TransferSpreadsheet
method to populate some Excel worksheets. It then opens Word docs that have
tables which are linked to those Excel worksheets. After all that happpens,
I need to save the Word docs under a different name and break the links to
the Excel worksheets. I got the first part with this code:
ActiveDocument.SaveAs ("Copy of Document Name"). But I can't figure out how
to break the links in the Copy of document. Can anyone help?

Thanks, Jeff.

 

[Dave Patrick]

You'll probably have better luck asking here.

http://www.microsoft.com/communitie...1af-b60d-427b-a26a-ec014efb374b&lang=en&cr=US

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
| Hello,
|
| I have been learning to control Excel and Word from Access using VBA and
| references to these two apps. I've had pretty good success, but I ran
into
| one, stubborn problem. My Access application uses the TransferSpreadsheet
| method to populate some Excel worksheets. It then opens Word docs that
have
| tables which are linked to those Excel worksheets. After all that
happpens,
| I need to save the Word docs under a different name and break the links to
| the Excel worksheets. I got the first part with this code:
| ActiveDocument.SaveAs ("Copy of Document Name"). But I can't figure out
how
| to break the links in the Copy of document. Can anyone help?
|
| Thanks, Jeff.