Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 2nd 05, 10:56 AM
Nipper
 
Posts: n/a
Default Can T Get Macro To Run!


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


  #2   Report Post  
Old November 3rd 05, 12:51 AM
exceluserforeman
 
Posts: n/a
Default Can't Get Macro To Run!

Hi,
Hmmm... what a dilemna!
Best to rename the macro or better yet record the macro agian but type in
anything bu macro1 as the name to record.
Save the workbook as "dooby.xls" (or whatever).
Right-click on the toolbars, select Customise, click attach, select macro1
copy to this workbook.
Save again.

Recorded macros are really only a guide to what you really want. Remember
that you started recording when you opened that first file. so that in the
macro, that file name would be the source file.

You can send me the recorded macro and maybe(?) I can clean it up a bit.

See my stuff at:
http://www.geocities.com/excelmarksway


- - Mark

"Nipper" wrote:


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


  #3   Report Post  
Old November 4th 05, 04:48 AM
Nipper
 
Posts: n/a
Default Can T Get Macro To Run!


I eventually discovered that I had a virus..I ran my Norton Ghost,
restored my system and everything works like it should.

So thanks again



Nipper


--
Nipper
------------------------------------------------------------------------
Nipper's Profile: http://www.excelforum.com/member.php...o&userid=28494
View this thread: http://www.excelforum.com/showthread...hreadid=480986



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Closing File Error jcliquidtension Excel Discussion (Misc queries) 4 October 20th 05 12:22 PM
macro with F9 Kenny Excel Discussion (Misc queries) 1 August 3rd 05 02:41 PM
Help with macro looping and color query function kevinm Excel Discussion (Misc queries) 10 May 26th 05 01:25 AM
Playing a macro from another workbook Jim Excel Discussion (Misc queries) 1 February 23rd 05 10:12 PM
Date macro Hiking Excel Discussion (Misc queries) 9 February 3rd 05 12:40 AM


All times are GMT +1. The time now is 03:47 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright ©2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017