Looking for a Macro expert

[joelanin]

Any one here know anything about macros in excel?

Would really appreciate a heads up.

 

[Michael M]

Quite a few members here are pretty handy with VBA.....what are you after ??

 

[mirabeau]

A contributor to this forum, Hiker95, gives an excellent list of references in post#3 here
http://www.mrexcel.com/forum/showthread.php?t=628659.

That, and looking at some of the macros written by members of this forum in response to specific problems, should give a pretty good idea how to proceed.

 

[joelanin]

Thanks for your reply.
here's my code.

ActiveWorkbook.SaveAs Filename:=myfilename
MsgBox ("File Saved.")

The above code works fine if the "myfilename" doent exists. When the filename already exists, a display allerts message pops up that says"filename exists. Do you want to replace it? if user clicks OK, the code works fine as is. But when the button NO or CANCEL is clicked, the program displays error message,,, end or debug..... I want to terminate the code when NO or CANCEL is selected, how is it done? thanks

 

[Oeldere]

I'm not a VBA expert.

You help the forummember is you put you whole code.

 

[MARK858]

Thanks for your reply.
here's my code.

ActiveWorkbook.SaveAs Filename:=myfilename
MsgBox ("File Saved.")

The above code works fine if the "myfilename" doent exists. When the filename already exists, a display allerts message pops up that says"filename exists. Do you want to replace it? if user clicks OK, the code works fine as is. But when the button NO or CANCEL is clicked, the program displays error message,,, end or debug..... I want to terminate the code when NO or CANCEL is selected, how is it done? thanks

See duplicate post http://www.mrexcel.com/forum/showthread.php?t=639475

 

[GTO]

Any one here know anything about macros in excel?

Very Smooth...​

​

I have seen everything here from nice API examples from Jafaar, to Rory's "Cool" reminders of quicker ways of changing PageSetup through old style 4.0 code, to stellar string operations from PGC01, and all sorts of incredible worksheet formula (do I even have to mention Aladin?), to incredibly patient explanations, to great donations of time and effort (Richard Schollar's HTML maker easily comes to mind), to Norie's wit, etc., etc..

See duplicate post http://www.mrexcel.com/forum/showthread.php?t=639475

Thank you I like your signature!

I'm not a VBA expert.

You help the forummember is you put you whole code.

It would also help if you would use code tags.

Thanks for your reply.
here's my code.

ActiveWorkbook.SaveAs Filename:=myfilename
MsgBox ("File Saved.")

The above code works fine if the "myfilename" doent exists. When the filename already exists, a display allerts message pops up that says"filename exists. Do you want to replace it? if user clicks OK, the code works fine as is. But when the button NO or CANCEL is clicked, the program displays error message,,, end or debug..... I want to terminate the code when NO or CANCEL is selected, how is it done? thanks

Presuming the code is fired by a user's choice (I pushed a button, clicked somewhere, used a shortcut key combo - something other than the PC "willed" it), or even if not, why not just check to see if the file already exists before the .SaveAs?

Mark