Why would a macro just 'stop'???

[gharding14]

I just do not understand why THIS happens...

Please Login or Register  to view this content.

OK - here is a tricky one. Once I get to this point, my macro "STOPS" after the Workbooks.Open and does not continue. I can do a 'step into' and get it going, but it just ends, and I see Design mode lit. Do I need to return 'focus' to it, in order for the macro to continue?

Dont understand.... Please help...

[patel45]

your code works well, attach please a sample file

[Norie]

Is there any code in the workbook you are opening that would be triggered when you open it?

[staggers47]

Sorry to butt in, but as a quick aside, I think that all of the following variables will be variants:

UserName, OpenString, SavePath, YY, DD, D2, M2, LastRow, I, Protocol, ProjNum, ErrorCode, ErrorRange.

This is because you have only defined the data type of the last variable in each row, whereas you have to define each one separately.

[JosephP]

are you running your macro from a shortcut key combination including the Shift key? if so, don't :-)

[gharding14]

Thanks for the hints. I will try it this morning. Have a great day folks!

Gary

[gharding14]

Thanks JosephP. It ran without the damn shortcut...

Just have to logistically set it up differently. Thanks and cheers,

Gary