Control Excel from Word

[ryguy7272]

In a newly created Word document, I created a reference to ‘Normal’ under
Tools > References > Normal. I was experimenting with a few different
techniques to use Word to open an Excel file. I got the macro working, but
now I can no longer use Ctrl+C to copy text!! I tried to end the reference
to Normal and I tried to remove the VBA module…nothing seems to work!! This
probably wouldn’t be a problem at all, except for the fact that all every
single word.doc seems to be affected by this macro. My question is a
two-parter:

Does anyone have any suggestions as to how to end the Ctrl+C problem, and
just basically restore my word documents to the way they were before.

Also, does anyone have any suggestions as to how to open an Excel file from
a Word document? I tried things such as Insert > Hyperlink, and Insert >
Object. None of these things worked. What I really want to do is simply
open an Excel file on a network drive. I don’t want to import the data from
the Excel file into my Word document.


Cordially,
Ryan---

PS, sorry if this posts twice; I didn't see it show up in the list even
though I could swear that I posted it earlier this morning... Also, sorry
for posting on the Word DG and now the Excel DG, but I didn't get a response
on the other DG.

 

[John Bundy]

Not sure about your ctl-C issue, but I can tell you how to open Excel
Dim ExcelSheet As Object
Set ExcelSheet = CreateObject("Excel.Sheet")
ExcelSheet.Application.Visible = True

if you type createobject in your helpbar MS returns some nice instructions
on working with this

 

[ryguy7272]

I found the cause fo the problem:
Tools > Customize > Keyboard > Current Keys > Remove

Thanks for the code John.