Thread: Access Macro in a Module
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
joel[_37_] joel[_37_] is offline
external usenet poster
  
Posts: 1
Default Access Macro in a Module

Excel won't look for names in another workbook unless you tell it where
it is located. what si tthe error you are getting and at which lin eof
code.


aAccess.DoCmd.OpenModule "AFMA_Green.mdb!Load AFMA Data", _
"GetNewAFMAGreen"


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=145834

Reply With QuoteReply With Quote