Results 1 to 3 of 3

Thread: Calling Access VBA code from Excel

  1. May 9th, 2007, 11:23 AM #1
    Fonty
    Fonty is offline

    Thread Starter
    Addicted Member Fonty's Avatar
    Join Date
    May 2006
    Location
    New York
    Posts
    173

    Post Calling Access VBA code from Excel

    I found in the forum a way to call an Access macro from Excel:
    http://vbforums.com/showthread.php?&...00#post1907700
    But how can I call a procedure embeded in some module in Access from Excel?
    Last edited by Fonty; May 9th, 2007 at 11:28 AM.
    Reply With Quote Reply With Quote
  2. May 9th, 2007, 01:30 PM #2
    Fonty
    Fonty is offline

    Thread Starter
    Addicted Member Fonty's Avatar
    Join Date
    May 2006
    Location
    New York
    Posts
    173

    Re: Calling Access VBA code from Excel

    I have been trying to use Docmd.RunCode but it doesn't recognize .RunCode like a valid method.
    Reply With Quote Reply With Quote
  3. May 10th, 2007, 07:28 AM #3
    salvelinus
    salvelinus is offline
    Frenzied Member
    Join Date
    Feb 2003
    Location
    Argentina
    Posts
    1,950

    Re: Calling Access VBA code from Excel

    I'm not sure whether you can do what you want or not. You can automate Access from Excel, which would allow you to use Access methods, functions, etc. But I don't know if you can get at user created subs.
    Try a search on Access automation.
    Tengo mas preguntas que contestas
    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