Macro Runs IN Debug but Not In Automatic

[SteWilf]

Hi All,

I'm wondering if someone can help me. I must admit I have been using these forums for awhile as a guest and been searching for answers instead of posting but could not find anything to solve this.

I have recently written a VBA procedure that activates upon open then goes off to a google drive and opens a file to check against the value in Cell A1. The filename of the file being checked contains the revision number and the check is to ensure a user is using the correct file revision.

In Debug mode the macro works perfectly but in auto mode it crashes after open event from Google with the error code execution has been interrupted. I've tried adding pauses and do loops but to no avail.

Anyone have any suggestions?

Many thanks in advance,
Steve

Please Login or Register  to view this content.

[Philb1]

Hi SteWilf
I would think it's because the way you're getting the data from the worksheets etc. You're activating & selecting worksheet/cells etc, so the workbook/worksheet you're wanting to read isn't active