Issue with Macro Stopping, need help

[MeridianFrog]

Hello everyone, new to forums. Ive done some searching around but I can not find a real good answer as to a) why this happens, and b) how to work around it. Code first, problem after that.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

First, I know, my code is not the cleanest in the world. I accept that, I understand that. But that isnt really the issue. Here is what we deal with. Its a simple Time Sheet. It pulls all the hours for the employees into this Master Sheet, Hit the Macro button, boom, easy to do payroll. However we have 1 guy (Jonathan) who works remotely. He gets paid based on what he bills for.

We use Spiceworks for our ticket system. My code breaks when dealing with Jonathan. The way it works is, I export the Spiceworks file, saved as Excel. The Macro is suppose to run where it breaks apart the Hours and Minutes, then gives me the total at the bottom of the spiceworks Excel sheet. Then the Macro is suppose to pull that information back into the Master Template and fill in Jonathan's stuff.

Easy flow of how it works:
1) Run Macro
2) Get to Jonathan
3) Window pops up to select Spiceworks File
4) Do Hours and Minutes stuff on the Spiceworks file
5) Pull info back to Template
6) Resume with everyone elses stuff.

How it actually works
1) Run Macro
2) Get to Jonathan
3) Window pops up, select SW file
4) Do Hours and minutes stuff on SW file
5) Macro STOPS - Does not pull information back over.

Its as though when having to do it on another sheet, the system forgets that a macro was working and running.

Any thoughts on how to stop this from happening?

[davo3286]

Hi MeridianFrog,

The best thing for you to do is edit your post and then click the '#' icon from the message editor ribbon and then put each of your codes in separate #'s.

This then displays the code with your tabs and indents like VBA.

For example:

Please Login or Register  to view this content.

What would work even better is to post a desensitised version of your document

[rorya]

Please put your code into code tags, per the forum rules.

In the meantime, I'm surprised your code will run at all - it shouldn't compile.

[MeridianFrog]

Hey there, Code tags put in. Sorry about that.

[rorya]

I’m still surprised it runs. This line:

Please Login or Register  to view this content.

should be:

Please Login or Register  to view this content.

and this:

Please Login or Register  to view this content.

makes no sense to me unless you have a public routine called mwkb in the thisworkbook module.

[MeridianFrog]

The Activeworkbook.mwkb was an attempt as a workaround to reset the workbook to the timesheet, to try and get the macro to continue working. As it stands right now, it runs through just fine for 'Jeff', but when it hits Jonathan, it does what its suppose to, goes to FileOpener. Opens the selected file, runs the code, but once it finishes with FileOpener, it doesnt return to the InfoPuller Function.

[rorya]

My point really was that you should get an error with that code.

I don't see why you pass Mwkb (which is Nothing) to that code. Also, is the file you open in that code the same one that the code then tries to open after that sub returns?