Word -->> Excel

[trillicomm]

Hi,

I have Word open with a file. Need to create a macro in Word that does this:

Select All
Copy
Launch new Excel workbook
Paste

The macro needs to sit on the Word dashboard menu.

Is that possible?

Thanks for your valuable time!

t.

 

[Macropod]

Hi trillicomm,

Have you done a search for the vba code to do this - there are many examples of this sort of thing on the web. As for assigning the code to a button on a menu, that process is described in Word's Help file.

 

[trillicomm]

Sub OpenExcel()

' OpenExcel Macro

Shell ("D:\Program Files\Microsoft Office\Office10\excel.exe")

End Sub


That should work. Thank you.