Replies

Ok so I create a macro like this:

Dim xl As Object
Set xl = CreateObject(“Excel.Application”)
xl.Visible = True

When I run it with Excel minimised on the toolbar a window
flashes open and disappears. With out Excel running nothing
happens.

I don’t mind it running slowly but it I don’t think it’s doing what it should.

I hadn’t used forms before, yep that’ll do it. Thanks for that – so simple when you know what you’re doing
The only small problemis that the default form is a bit ugly. Is it possible to design your own that does the same thing?

WOooah … sounds a lot more complex than I was expecting. I’ve just been fooling with macros (recording then editing the recorded macro), I don’t really have any idea what I’m doing. I just thought opening Excel from Word would be easy
(it’s Office 2000 by the way on Win98)

Guess I’ll have to get myself a book and do it properly. What book would Woody recommend ?

WOooah … sounds a lot more complex than I was expecting. I’ve just been fooling with macros (recording then editing the recorded macro), I don’t really have any idea what I’m doing. I just thought opening Excel from Word would be easy

Guess I’ll have to get myself a book and do it properly. What book would Woody recommend ?