I have a real brain twister here....hope someone can shed some light on this.
Workbook created in Excel 11 [office 2003]
Has a sub form that communicates with a device. There's a button to start the device. It has worked in Win2k, Vista, WinXP, Win7, Win 8 up to now. It has worked in Office 2003, 2007, Xp, Office 2010. I have never come across this problem...
When opened in Excel 2013, when the start button for the device runs it's code, Excel throws an error 13 type mismatch. I remoted inot the box and checked that all the libraries are loaded. Naturally it's loading Excel 2013 libraries where the version I send is using Excel 11 but the other 4 libraries are all matching.
Visual Basic for Applications
Microsoft Excel 11.0 Object Lib [his are for his version but should work]
Ole Automation
Microsoft Forms 2.0
Microsoft DAO 3.6
Now...this was working even on this computer but with a hickup on first opening the workbook that said "some objects not available". But the form would fire up the digital box and it worked.
In an effort to get rid of that hickup I sent him a spreadsheet that was supposed to remove and MISSING references. I didn't want to give access to the VBA code.
That workbook locked his Excel. After that, my workbook started this Error 13 problem.
I installed software to allow me to view and run his computer. I checked the libraries. I checked his macro security to verify it has access to VBA projects, etc., etc. etc.
I can find nothing in his configuration that is wrong. I had him send me the workbook and I opened it on my Win7 Excell 11 box....works perfectly.
There can be no data mismatch as the error suggests that I can think of. On startup it's simply running code that fires the box up. I blows up every time on .dqsample which is a sample rate for the box.
The box comes with it's own native software and works fine under that.
I verified comm port settings and sample rate are correct.
Does anyone have any ideas????
This is win 8 with office 2013. It will a cold day in you know where before i ever switch to win 8.... Guess I'm old...