Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Jason Perry   on Oct 07 In MS Office Category.

  
Question Answered By: Quinn Johnson   on Oct 07

The hour glass is from

xlApp.Cursor = xlWait

The way to eliminate it is with the

xlApp.Cursor = xlDefault

I can't think why you would be getting a compile  error on this - especially
as the xlWait one clearly works OK.

Is it xlApp or xlDefault it thinks isn't defined? (It will highlight the
offender.)

I'm wondering if your 2002 problem is to do with your references. Go to
Tools/References in the VB environment. The ticked ones will all be at the
top. In my case, I have five ticked:

Visual Basic For Applications
Microsoft Project 10.0 Object Library
OLE Automation
Microsoft Office 11.0 Object Library
Microsoft Excel 11.0 Object Library

I'm using Project 2002 which is 10.0, but the rest of my Office is 2003
(11.0).

If you're using 2002 throughout, then you'll presumably need to be seeing
the 10.0 libraries ticked.

If you see "missing" against any of them, you know you've got a problem.
Untick those and find and tick the appropriate ones further down your list.
(Much further :-) it's an alphabetical list apart from the ticked ones..)

Share: 

 

This Question has 9 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Compile Error Or get search suggestion and latest updates.


Tagged: