Combine two codes to vbYesNo, "Notification

[zplugger]

Can I combine two codes into one too shorten process? Both codes are run from commandbutton,if I can get first code into second code I could get rid of a button in process. So
commandbutton 12 code would run if vbYesNo is yes and if no it would use misc folder like now.
Thanks for any help or suggestions.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[gmr4evr1]

Hello again,

I THINK you can call one sub from within the other sub using Call. And, I THINK it would go in your IF or Then part of your statement. There is probably more to it then just that, but again, I only know enough to mess code up really bad.

[zplugger]

Would it be better to call the other macro or add to code?

[gmr4evr1]

Better? I do not know. It might be easier to call the other macro because (I THINK) if you add the code, one or both of the codes would have to be modified more.

[zplugger]

This is hard, ran into problems making Dir. with existing code.

[gmr4evr1]

Did you try adding the code, or calling it?

[zplugger]

Tried making it, my first code only add folder if dir is there.This is going to be harder then expected.Both button's run the code perfect, going to take time to add together.

[gmr4evr1]

I am still learning too, so I am not very good at troubleshooting yet.
If you decide to try to call it, after Else, instead of exit sub, put

Please Login or Register  to view this content.

This might not even be the proper way to call a Sub, but this is the way I would do it.

[zplugger]

I'm not sure if this is going to be possible, lot going on with the codes. If I say yes to call commandbutton12 then it should create dir,but if I say no then it should give me option to save to misc.? Simple
vba I can make work but this is more complex.

[zplugger]

Got this to work, not sure if its the cleanest and best way.

Please Login or Register  to view this content.

[gmr4evr1]

Glad you were able to get it to work. As for the "best" or "cleanest" way......We may have to rely on LJMetzger and/or berlan to answer that.

[zplugger]

Trying to add, changed vbyesno to vbyesnocancel
If MSG = vbCancel Then
Exit Sub

not sure where to put in code?

[gmr4evr1]

Try to put it in the line before IF MSG = vbYes then

[zplugger]

still brings up save box?

[zplugger]

Got it finally lol

Please Login or Register  to view this content.

[gmr4evr1]

Nice. glad you got it, I wasn't sure of placement.