Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() I HAVE excel 97.Don t know any MVB. I have never used Excel before. , but want to use it to clean up a query that I made in Access. So I exported the query in access as a microsoft excel 97 file, and imported it inio excel. I then went to tools, macro, record new macro..,gave the macro the name "macro1",stored the macro in “this workbook”, and made changes to the document. When I finished the changes, I clicked on stop recording and the macro box disappeared. I assume the macro was safely stored for next time. I reimported a file, went to tools, macro, the macro screen came up, I typed in "this work book ", and the macro name “macro1 ”, but I can t get it to play. Anyone got any ideas.I am using windows 98, but I don t think that matters. Any advise would be appreciated. Thank You Nipper -- Nipper ------------------------------------------------------------------------ Nipper's Profile: http://www.excelforum.com/member.php...o&userid=28494 View this thread: http://www.excelforum.com/showthread...hreadid=480986 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Closing File Error | Excel Discussion (Misc queries) | |||
macro with F9 | Excel Discussion (Misc queries) | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) |