Help - How to open a Word file in VBA for Excel

  Newuser3443 21:16 24 Oct 05
Locked

I have a macro in Excel (without going in to long detail it does need to be in Excel), the start of which requests a file name from the user and validates that it exists.

From the Excel macro I know how to open Word, but I don't know how to get Word to open my text file document from the same Excel macro.

Any asssistance would be much appreciated.

Thanks, Rob

  mammak 21:36 24 Oct 05

In interest bump.

  Simsy 09:22 25 Oct 05

but just to be clear, when you say;

"how to get Word to open my text file document from the same Excel macro"

does "text file document" mean a word document?


You want a macro to run in Excel, and this macro checks if a document exists, and if it does then it opens said document in WORD.

Have I got that correct?


Regards,

Simsy

  Simsy 09:34 25 Oct 05

but I suspect this will have the information you seek...

click here

Good luck,

Regards,

Simsy

  VoG II 19:17 26 Oct 05

This thread is now locked and can not be replied to.

Hands-on: Acer Predator Triton 700 review

D&AD Awards 2017: see the best design, advertising, illustration, animation and VR of the past year

How to lose weight with an Apple Watch