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.

What is Amazon Go and will it come to the UK? The store without checkouts or queues

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

Why ecommerce hasn't taken off on social media

New MacBook Pro 2016 review | MacBook Pro with Touch Bar review: Apple's expensive and powerful…