Random Compile Error

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
Since yesterday we've been getting occurances of this (and other) errors. I haven't been able to track down the source but I'm thinking that it's to do with the latest win7 updates. What's not shown in the screen shot is that DocumentType is highlighted in the 8th line of code. Prior to this we were getting an Error highlighting ThisApplication in the 4th line. The strange thing is that this works on one machine but not another, a couple of restarts later and maybe they both work, later yet and maybe the errors switch machines, totally random from what I can see. This makes me think that it's Windows based and not VBA based but I'm relatively inexperienced when it comes to error tracking (and code writing for that matter). Maybe one of you super code jockeys could take a look and give me some hints on where to look next. BTW, this module has been in operation for the last two years without issue although in an effort to find the problem I did clean up the module importation/insertion section this morning.
I've included the entire Module in .txt format.