Open Word from Excel

[chef]

Hi,

is it possible to open a word document from excel ?

I have text in G1,sheet2 with "staff record"..
in cell A1 I have a staff record no eg T123456

I have a series of staff records in a folder g/public/chef/staffrec, all based on unique staff number eg T123456.doc etc

I want to be able to click on "staff record" or a button on sheet2 and open up the staff file from word?

is this possible..

any help appreciated
many thanks
ian

 

[wigi]

If you would take the time to Google for the exact (!) topic title, you would immediately see:
http://www.exceltip.com/show_tip/Ap...m_Excel_using_VBA_in_Microsoft_Excel/465.html

 

[chef]

thanks..


my apoogies for using mr excel forum to obtain help and apology for obviously putting you out..

i can of course google and note your words of advice with my time

I have often found most people here more than helpful to nudge in right direction. why i come here.

tend to find if nothing constructive to say is to actually say nothing.

 

[wigi]

My aim is that you now spend time applying the code I pointed you to. And to learn from it...

If you speak about constructive or not, yes it is constructive to show good code rather than reinventing the wheel.

 

[VoG]

Try like this. In the VBE, in Tools > References tick Word Object library.

Change the path in red to suit.

For reasons I cannot fathom this opens the doc minimized to the taskbar. But as I said in your other thread, this is not my forte.

Sub OpenWord()
Dim wrdApp As Word.Application
Dim wrdDoc As Word.Document
Dim wdFileName As String
wdFileName = "C:\example\" & Sheets("Sheet2").Range("A1").Value & ".doc"
Set wrdApp = CreateObject("Word.Application")
wrdApp.Visible = True
wrdApp.WindowState = wdWindowStateMaximize
Set wrdDoc = wrdApp.Documents.Open(wdFileName)
End Sub

 

[chef]

Peter,

thank you for taking the time to try and help. I will try this at work tomorrow. This is more helpful and constructive advice.

Im not very good with vb and cant always fathom the vb logic and was looking for a quick solution rather than soundbites over someones aims or what I do with my time or learning ambitions.
Lazy, maybe and apols for that, but as I'm so busy was looking for a quick fix..thought that why mr excel was so helpful.

Appreciate your efforts to help Peter..no worries if I cant get this to work.

Your previous help was brilliant and very helpful to my dept.

As say, i sometimes need help, not lectures.

regards
ian