Can an add-in affect how macros run?

nancyo · May 24th, 2002, 02:39 PM

I have an .XLA add-in that we "purchased" from a company about a year ago.

It was specifically for one workbook, which is automated to a very small degree compared to how I am setting up new workbooks.

I "inherited" this workbook, and now I am trying to use this add-in for other workbooks.

I have all my new workbooks set up have an automatic footer when the file is opened (some of the workbooks have a very large number of pages, >80). I also have the screenupdating = false set in this workbook macro, so when the file is opened a message box pops up that states "automatic footers...". The screen is usually white behind the message box while this occurs.

Ok. Now when I open the new workbook that has a call procedure for the add-in in a module, the message box appears, but the screenupdating is "on", even tho the code is correct. Also, as the file opens, there is a flash of a statment in the left-hand corner
about some version of excel?

As the add-in is protected, I cannot see any of the code. Could this be interfering with other macros in the workbook?

This is the only workbook I have used this add-in in so far, and the older file is "crude", so I havn't noticed any problems.

Any suggestions?

Jack in the UK · May 24th, 2002, 03:58 PM

If the XLA was custom made I would have demanded the source code as well, little help now I know, as most programmers protect so WE can nab their scripts, its not open source. But I would have made this in the deal, thus I could amend it of cause.

Add in depending on what they do can and can not effect other scripts,

Say target in public will over ride a command button script as it will re set straight after.

What does the xla do and what is it effecting/
Some older Excel macro can differ just that bit from newer versions say 95 used modules in sheets and not VBE. Also 97 can get grumpy with 2000 and XP

What version Excel do you run and what OP.

nancyo · May 28th, 2002, 07:10 AM

We use office 2000, so I suspect that the add-in is an earlier version of excel.

I spoke to the person that bought the add-in, has no info on it, and can't remember the person they bought it from. Hmmm.

I can live with the file as is, but I hate it when things don't work they way they are supposed to, for reasons I can't determine.

[ This Message was edited by: nancyo on 2002-05-28 06:11 ]

May 24th, 2002, 03:58 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	If the XLA was custom made I would have demanded the source code as well, little help now I know, as most programmers protect so WE can nab their scripts, its not open source. But I would have made this in the deal, thus I could amend it of cause. Add in depending on what they do can and can not effect other scripts, Say target in public will over ride a command button script as it will re set straight after. What does the xla do and what is it effecting/ Some older Excel macro can differ just that bit from newer versions say 95 used modules in sheets and not VBE. Also 97 can get grumpy with 2000 and XP What version Excel do you run and what OP. __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 24th, 2002, 02:39 PM	#1
nancyo Board Regular Join Date: Mar 2002 Location: Massachusetts, USA Posts: 255	I have an .XLA add-in that we "purchased" from a company about a year ago. It was specifically for one workbook, which is automated to a very small degree compared to how I am setting up new workbooks. I "inherited" this workbook, and now I am trying to use this add-in for other workbooks. I have all my new workbooks set up have an automatic footer when the file is opened (some of the workbooks have a very large number of pages, >80). I also have the screenupdating = false set in this workbook macro, so when the file is opened a message box pops up that states "automatic footers...". The screen is usually white behind the message box while this occurs. Ok. Now when I open the new workbook that has a call procedure for the add-in in a module, the message box appears, but the screenupdating is "on", even tho the code is correct. Also, as the file opens, there is a flash of a statment in the left-hand corner about some version of excel? As the add-in is protected, I cannot see any of the code. Could this be interfering with other macros in the workbook? This is the only workbook I have used this add-in in so far, and the older file is "crude", so I havn't noticed any problems. Any suggestions?

May 28th, 2002, 07:10 AM	#3
nancyo Board Regular Join Date: Mar 2002 Location: Massachusetts, USA Posts: 255	We use office 2000, so I suspect that the add-in is an earlier version of excel. I spoke to the person that bought the add-in, has no info on it, and can't remember the person they bought it from. Hmmm. I can live with the file as is, but I hate it when things don't work they way they are supposed to, for reasons I can't determine. [ This Message was edited by: nancyo on 2002-05-28 06:11 ]