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.

Nintendo Switch review: Hands on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Here's what should be coming to Adobe Project Felix in 2017

Apple AirPods review: Apple's beautiful new Bluetooth headphones bring true intelligence to…