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

C

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,
 
S

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 <--
 
D

Dirk Goldgar

ChuckW said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top