Saving VBA code as a module and then running it in a macro

[ChuckW]

Hello,

Someone sent me some vba code in a word document. I want to save it somehow
(as a module?) and then run it in a macro. I went to modules and selected
new and pasted the code into the vba code screen. It appeared to save it as
Module1. I then closed the window and went back to the main Access menu that
lists tables, queries, reports and modules but nothing appears under modules.
When I go to macros and select open module there is nothing that appears
there. Can someone help me with this?

Thanks,

 

[Stefan Hoffmann]

hi Chuck,

Someone sent me some vba code in a word document. I want to save it somehow
(as a module?) and then run it in a macro. I went to modules and selected
new and pasted the code into the vba code screen.

The modules section in Access or Word?


mfG
--> stefan <--

 

[Dirk Goldgar]

Hello,

Someone sent me some vba code in a word document. I want to save it
somehow (as a module?) and then run it in a macro. I went to modules
and selected new and pasted the code into the vba code screen. It
appeared to save it as Module1. I then closed the window and went
back to the main Access menu that lists tables, queries, reports and
modules but nothing appears under modules. When I go to macros and
select open module there is nothing that appears there. Can someone
help me with this?

While in the VB Editor, did you click the Save button? Just closing the
VB window doesn't cause the module to be saved, though you'll get a
prompt to save or cancel if you close the database.