Macro not working in Excel2013

[justdream]

Dears,

Please I need your urgent support, Below Macro is working well in Excel 2007
but always give me this error message in Excel 2013

Run Time error '9':
Subscript out of range

Could you advice how to correct it,
Many Thanks

[patel]

very bad share site !

[justdream]

sorry, uploaded directly to our forum

[justdream]

I think the main problem is that Macro code contains below line:

Rem AddIns("Internet Assistant VBA").Installed = True

and Excel2013 doesn't contains this AddIns
Do you know how to add it?

[patel]

a line beginning with rem is not active

[justdream]

a line beginning with rem is not active

mm, sorry I'm newbie - what does it mean?

[Aussiebear]

Any string on the right side of the word "Rem" will not be read by the system, so the following statement:
Rem AddIns("Internet Assistant VBA").Installed = True
is simply ignored by the system.

[Dave]

Just read this post at Mr. Excel. Please post a link and maybe read the forum rules. Dave

[Aussiebear]

Run Time error '9':
Subscript out of range

Could you advice how to correct it,

Subscript out of range normally refers to Excel being unable to locate an object such as a specific named sheet or range

[justdream]

Subscript out of range normally refers to Excel being unable to locate an object such as a specific named sheet or range

Yes Excel 2013 is unable to locate this AddIns as it's not included in Excel 2013,
so is there a way to sort this issue out?

[Aussiebear]

Do you have access to the Addin?

[justdream]

Do you have access to the Addin?

I've enabled all AddIns, I've found as shown below

[Aussiebear]

Try here for advice
http://office.microsoft.com/en-au/excel-help/add-in-programs-included-with-excel-HP005198554.aspx

[Simon Lloyd]

There will be a typo with a sheet name, your workbook code project is password protected so we cant see what we need to fix!

[justdream]

There will be a typo with a sheet name, your workbook code project is password protected so we cant see what we need to fix!

I'm not macro creator, it's very old one
I just want to use it using Excel 2013 :(

[shrivallabha]

Since we can't see the macro. I hope you can, see where this "Internet Assistant VBA" is required.

For version 2010 this add-in is not required:
http://social.msdn.microsoft.com/Forums/pl/exceldev/thread/64a21007-8eb0-4862-969f-0908f503ece3

So I'd think same applies for 2013 so you may have to step through the code where it was previously referring to internet VBA assistant and work out the solution.