ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro from older version into Office 2013 on Windows 8 (https://www.excelbanter.com/excel-programming/449889-macro-older-version-into-office-2013-windows-8-a.html)

[email protected]

Macro from older version into Office 2013 on Windows 8
 
I am running a macro on my old machine in Windows 7 with Office 2010. I now got my new laptop with Windows 8 and office 2013, but the macro give me a "Error 424" every time halfway through.

I need this macro to work, otherwise I need to hang onto my old machine only for this.

Any suggestions?

GS[_2_]

Macro from older version into Office 2013 on Windows 8
 
I am running a macro on my old machine in Windows 7 with Office 2010.
I now got my new laptop with Windows 8 and office 2013, but the macro
give me a "Error 424" every time halfway through.

I need this macro to work, otherwise I need to hang onto my old
machine only for this.

Any suggestions?


Need more info!!
What line of code is raising the error?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion



Martin Brown

Macro from older version into Office 2013 on Windows 8
 
On 05/03/2014 14:34, wrote:
I am running a macro on my old machine in Windows 7 with Office 2010. I now got my new laptop with Windows 8 and office 2013, but the macro give me a "Error 424" every time halfway through.

I need this macro to work, otherwise I need to hang onto my old machine only for this.

Any suggestions?

A description of the line where it fails would be a start.

MS seem to go out of their way to break things in each new release :(

Though nothing has ever been quite as bad as the XL2003 to 2007 mess!

--
Regards,
Martin Brown

GS[_2_]

Macro from older version into Office 2013 on Windows 8
 
Note that as of v2010, MS Office uses VBA7 and so your VBA6 code may be
causing the trouble!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion




All times are GMT +1. The time now is 06:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com