Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004
    Posts
    49

    Unanswered: declare variable

    we upgraded to 2003 access. Now in a code getting the msg that I need to
    declare a variable for:xlexcel9795
    here is how it is in the code. what do I put?
    FileFormat:=xlexcel9795

  2. #2
    Join Date
    Nov 2003
    Location
    LONDON
    Posts
    238
    You need to make sure you have a reference to the Microsoft Excel 11.0 Object library in your VBA code. xlExcel9795 is an Excel variable, not an Access variable. During your upgrade you might have missing references to the old version of Office.

    Check by going Tools, References in the VBA code window

    Regards
    Justin

  3. #3
    Join Date
    Jul 2004
    Posts
    49

    Thanks!!!!

    Yes! that was it. I sure appreciate your help. Thank you so much!

Posting Permissions

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