VB6 and Office 2013

[Opv]

I have searched for information pertaining to the implications of upgrading to Office 2013 and the effects such an upgrade has on existing VBA script written in VB6 (Office 2000). I find conflicting reports as to how and to what extent OFfice 2013 is suppose to support VBA scripting. Can someone please advise in layman's terms whether my scripts written in Office 2000 will (or should) work under Office 2013?

[Aflatoon]

They should be largely compatible. There are some deprecated items since Office 2000 such as Application.Filesearch but 90% should work, as long as you are not switching to 64bit Office.

[Opv]

Thanks. I think the 64 bit issue may be an issue, if that indeed effects the VB6 functionality.

[Aflatoon]

It's fine for the majority of things other than non-MSForms activex controls (where you are largely out of luck) and windows API calls which need to be rewritten to use PtrSafe, LongPtr and LongLong as applicable. Note that this refers to Office being 64bit, not Windows.

[Opv]

Thanks. I think I'm going to resist upgrading as long as possible. Excel 2000 does everything I need and want.