VB Help WORD/EXCEL LINK

  • Thread starter Thread starter ChrisMattock
  • Start date Start date
C

ChrisMattock

I have an excel spreadhseet that updates an word document that we use t
generate letters from an excel form. I need to make a macro that load
up the word document, updates the links then breaks them all (breaklin
comand I believe!) but I suck at Visual Basic and have no idea how to d
it. If someone was to help I would be eternally grateful ;) THANKS :
 
Welcome
-----Original Message-----
From: Chris Mattock [mailto:[email protected]]
Sent: Thursday, May 04, 2006 2:54 AM
To: (e-mail address removed)
Subject: RE: Excel=>Word


Wow thanks a lot, I will try my best now! Thanks again!




----------------------------------------------------------------------------
From: "KC Cheung" <[email protected]>
To: <[email protected]>
Subject: Excel=>Word
Date: Wed, 3 May 2006 11:39:54 +0800
We have created for your review
a sample Letter of Acceptance, loa.doc
and a quotation spreadsheet, quotes.xls

step 1, put the loa.doc in directory c:\01

step 2, open quotes.xls,
enable macro,
in VB editor, tools/references, select Microsoft Word

step 3, try the button,
all letters of acceptance generated are in directory c:\01

Cheers
"ChrisMattock" <[email protected]>
wrote in message
 

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

Back
Top