Runtime error 424 in Windows 8 environment

[jan120253]

I have downloaded a workbook with some macros from an insurance company. It runs perfectly well on both Excel 2007 and 2010 on a Windows 7 platform, but when I try it on a Windows 8 platform, I get Runtime error 424 in both Excel versions.

The code is password protected so I can't debug. The insurance company can't or won't help.

Has something changed from Windows 7 to 8, like names of DLL libraries or something like that?

Jan

 

[Auric__]

I have downloaded a workbook with some macros from an insurance company.
It runs perfectly well on both Excel 2007 and 2010 on a Windows 7
platform, but when I try it on a Windows 8 platform, I get Runtime error
424 in both Excel versions.

The code is password protected so I can't debug. The insurance company
can't or won't help.

Has something changed from Windows 7 to 8, like names of DLL libraries
or something like that?

Not in such a way that would prevent macros from running... I *think.*

If you're willing, send the spreadsheet to me at auric.auric [at] gmail and
I'll take a look at it. I'm curious about this.

 

[isabelle]

hi Jan,

have you checked if there are missing libraries (menu/ tools/references)?

isabelle

Le 2013-08-18 05:14, (e-mail address removed) a écrit :

I have downloaded a workbook with some macros from an insurance company.

It runs perfectly well on both Excel 2007 and 2010 on a Windows 7
platform, but when

I try it on a Windows 8 platform, I get Runtime error 424 in both
Excel versions.

 

[isabelle]

if there are missing libraries, uncheck them and save your file

isabelle

Le 2013-08-19 00:38, isabelle a écrit :

 

[jan120253]

Den mandag den 19. august 2013 06.44.36 UTC+2 skrev isabelle:

if there are missing libraries, uncheck them and save your file



isabelle



Le 2013-08-19 00:38, isabelle a écrit :

As the VBA code is password protected, I can't get to References under Tools - and that is my main problem.

Jan

 

[jan120253]

Den mandag den 19. august 2013 00.18.38 UTC+2 skrev Auric__:

jan120253 wrote:

I have downloaded a workbook with some macros from an insurance company.

It runs perfectly well on both Excel 2007 and 2010 on a Windows 7

platform, but when I try it on a Windows 8 platform, I get Runtime error

424 in both Excel versions.

The code is password protected so I can't debug. The insurance company

can't or won't help.

Has something changed from Windows 7 to 8, like names of DLL libraries

or something like that?

Not in such a way that would prevent macros from running... I *think.*



If you're willing, send the spreadsheet to me at auric.auric [at] gmail and

I'll take a look at it. I'm curious about this.

I have send it to your adress.

Jan

 

[GS]

As the VBA code is password protected, I can't get to References under Tools

- and that is my main problem.

Where can this workbook be downloaded from?

--
Garry

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

 

[Auric__]

Den mandag den 19. august 2013 00.18.38 UTC+2 skrev Auric__:

I have downloaded a workbook with some macros from an insurance
company. It runs perfectly well on both Excel 2007 and 2010 on a
Windows 7 platform, but when I try it on a Windows 8 platform, I get
Runtime error 424 in both Excel versions.

The code is password protected so I can't debug. The insurance
company can't or won't help.

Has something changed from Windows 7 to 8, like names of DLL
libraries or something like that?

Not in such a way that would prevent macros from running... I *think.*

If you're willing, send the spreadsheet to me at auric.auric [at] gmail
and I'll take a look at it. I'm curious about this.

I have send it to your adress.

(Sorry for the delay answering; my internet connection imploded.)

I was unable to break the password for the spreadsheet. Passware says
"Invalid format" for the encrypted VBA content. Sorry.

 

[GS]

Den mandag den 19. august 2013 00.18.38 UTC+2 skrev Auric__:

jan120253 wrote:

I have downloaded a workbook with some macros from an insurance
company. It runs perfectly well on both Excel 2007 and 2010 on a
Windows 7 platform, but when I try it on a Windows 8 platform, I
get Runtime error 424 in both Excel versions.

The code is password protected so I can't debug. The insurance
company can't or won't help.

Has something changed from Windows 7 to 8, like names of DLL
libraries or something like that?

Not in such a way that would prevent macros from running... I
*think.*

If you're willing, send the spreadsheet to me at auric.auric [at]
gmail and I'll take a look at it. I'm curious about this.

I have send it to your adress.

(Sorry for the delay answering; my internet connection imploded.)

I was unable to break the password for the spreadsheet. Passware says
"Invalid format" for the encrypted VBA content. Sorry.

I'd like to give it a shot! Where can I download the workbook?

--
Garry

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

 

[Auric__]

I'd like to give it a shot! Where can I download the workbook?

Send me an email at auric.auric at gmail and I'll forward you the one I have.

 

[GS]

Send me an email at auric.auric at gmail and I'll forward you the one
I have.

Given our findings on the file being corrupt.., it's best IMO that the
OP urge the author to revise the project for Win8 runtime
compatibility.

--
Garry

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

 

[isabelle]

you can load your file here: www.cjoint.com
it's free and you don't have to register.
once done, just come back here and give us the download link

isabelle

Le 2013-08-19 10:20, (e-mail address removed) a écrit :

 

[GS]

you can load your file here: www.cjoint.com

it's free and you don't have to register.
once done, just come back here and give us the download link

Isabelle, the file is corrupt and so there's not much we can do with
it!

--
Garry

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

 

[isabelle]

Le 2013-08-25 21:39, GS a écrit :

Isabelle, the file is corrupt and so there's not much we can do with it!

ho! thank you Garry to telling me, i'll pass

isabelle

 

[Auric__]

Send me an email at auric.auric at gmail and I'll forward you the one
I have.

Given our findings on the file being corrupt.., it's best IMO that the
OP urge the author to revise the project for Win8 runtime
compatibility.

So it *is* corrupt? I wasn't willing to actually let the macros run...

 

[GS]

GS wrote:

I'd like to give it a shot! Where can I download the workbook?

Send me an email at auric.auric at gmail and I'll forward you the
one I have.

Given our findings on the file being corrupt.., it's best IMO that
the OP urge the author to revise the project for Win8 runtime
compatibility.

So it *is* corrupt? I wasn't willing to actually let the macros
run...

Yes! As I mentioned in my email.., I suspect this was done deliberately
so the file could not be manipulated or tampered with!

--
Garry

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