Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jun 2010
    Location
    blue springs, mo, usa
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have recently started receiving a message when I load a spreadsheet that says...

    "Variable uses an Automation type not supported in Visual Basic."

    What is this really telling me?

    DennisK

  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Does the spreadsheet have any Macros (VBA) running in it?
    If so, it could be one of many things.
    A cause of this is sometimes when a VB routine tries to reference
    an application but the library is not available

    A line like Set oWD=CreateObject("Word.Application") can be the cause.
    It has been reported that the error can be caused by references to MYSQL databases with data types not supported by VB

    Are you using this on a different PC than previously.
    Maybe it references something that is no longer installed.

    First port of call is to look and see what Macros (if any) are running, and what is in them

    If there are no macros then this is behaviour I have not encountered before.
    Andrew

  3. #3
    New Lounger
    Join Date
    Jun 2010
    Location
    blue springs, mo, usa
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Interestingly... it has now stopped doing it. There are several macros for several different functions. I have not changed any settings so don't know what was the original cause. Thanx for your input.

    DennisK

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •