PDA

View Full Version : Visual Basic For Application [VBA] Question.


Novak
31-10-2006, 08:06 PM
Hello all,

I know that this forum got nothing to do with VBA, But I have some question
about VBA. And I hope someone can help me further with this.

I have a Excel file with a form in it. the form starts up when I open the excel-File.
On the form there is a command bottom. Know what I want when I click on the command
Bottom, then it must open a specific word document that I created earlier.

Is this possible??

Thanks allot for reading...


Greetz and regards,
Novak

Twiel
07-11-2006, 10:33 PM
Strange place to ask :)
I think the easy way would be for the button to open a hyperlink to your ".doc" file. Assuming word is your standard app for documents this would open word and your document. You can use this code behind your button for example:

ActiveWorkbook.FollowHyperlink Address:="f:/whereveryourdocis"

Greetings, Groeten,

Twiel

Novak
08-11-2006, 07:10 PM
Thanks Twiel,

But I have the solution already.. And yeh I know, it's a wierd place to ask.. :D

Thanks..

Greetz,
Novak