Results 1 to 3 of 3

Thread: VBA in MS Access needs Excel reference

  1. Dec 6th, 2005, 02:42 PM #1
    MattSharp
    MattSharp is offline

    Thread Starter
    New Member
    Join Date
    Sep 2005
    Posts
    6

    VBA in MS Access needs Excel reference

    So I wrote some code in Access VBA to build a spreadsheet. It obviously needs a refernce added for MS Excel. The problem is when I give this to someone who doesn't have the same version of Excel it doesn't seem to work. Is there anyway aroundd this?
    Reply With Quote Reply With Quote
  2. Dec 6th, 2005, 02:43 PM #2
    DKenny
    DKenny is offline
    Frenzied Member DKenny's Avatar
    Join Date
    Sep 2005
    Location
    on the good ship oblivion..
    Posts
    1,171

    Re: VBA in MS Access needs Excel reference

    Search this forum for "late binding". This is the best way to avoid these types of issues.
    Declan

    Don't forget to mark your Thread as resolved.
    Take a moment to rate posts that you think are helpful
    Reply With Quote Reply With Quote
  3. Dec 6th, 2005, 02:56 PM #3
    DKenny
    DKenny is offline
    Frenzied Member DKenny's Avatar
    Join Date
    Sep 2005
    Location
    on the good ship oblivion..
    Posts
    1,171

    Re: VBA in MS Access needs Excel reference

    The following post is a pretty good one, and has a link to an external site that explains the difference between early and late binding

    http://www.vbforums.com/showthread.php?t=362347
    Declan

    Don't forget to mark your Thread as resolved.
    Take a moment to rate posts that you think are helpful
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width