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
--
-John
Please rate when your question is answered to help us and others know what
is helpful.
"ryguy7272" wrote:
> 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.
> --
> RyGuy
> --
> RyGuy
|
Similar Threads
