Histogram VBA Code won't run in Excel 2003
 

Hi,

I'm having a strange problem with some VBA code that I
wrote which calls the histogram subroutine that is in the
ATPVBAEN.XLA file. The relevant code is:
Application.Run "ATPVBAEN.XLA!Histogram", inputrange,
outputrange, , False, False, False, False

Excel 2003 (but not earlier versions) craps out with the
error:

Run-time error '1004':
The macro '' cannot be found.

Could anyone suggest any solutions. I've done the obvious
of making sure that the object library is referenced,
macro security is set to low, trust vb applications is
checked.

Thanks in advance.

Jim.

Histogram VBA Code won't run in Excel 2003
 

is ATPVBAEN.XLA loaded? (can you see it in the project explorer in the
VBE?)

--
Regards,
Tom Ogilvy

"jimbuff" wrote in message
...
Hi,

I'm having a strange problem with some VBA code that I
wrote which calls the histogram subroutine that is in the
ATPVBAEN.XLA file. The relevant code is:
Application.Run "ATPVBAEN.XLA!Histogram", inputrange,
outputrange, , False, False, False, False

Excel 2003 (but not earlier versions) craps out with the
error:

Run-time error '1004':
The macro '' cannot be found.

Could anyone suggest any solutions. I've done the obvious
of making sure that the object library is referenced,
macro security is set to low, trust vb applications is
checked.

Thanks in advance.

Jim.

Histogram VBA Code won't run in Excel 2003
 

Yes, it is loaded and is visible in project explorer.
It is quite a puzzle...

I even tried recording a macro of me creating a histogram
but that didn't work either. It crapped out with the same
error message.

-----Original Message-----
is ATPVBAEN.XLA loaded? (can you see it in the project
explorer in the
VBE?)

--
Regards,
Tom Ogilvy

"jimbuff" wrote in
message
...
Hi,

I'm having a strange problem with some VBA code that I
wrote which calls the histogram subroutine that is in
the
ATPVBAEN.XLA file. The relevant code is:
Application.Run "ATPVBAEN.XLA!Histogram", inputrange,
outputrange, , False, False, False, False

Excel 2003 (but not earlier versions) craps out with the
error:

Run-time error '1004':
The macro '' cannot be found.

Could anyone suggest any solutions. I've done the
obvious
of making sure that the object library is referenced,
macro security is set to low, trust vb applications is
checked.

Thanks in advance.

Jim.


.

Histogram VBA Code won't run in Excel 2003
 

Unfortunately, I don't have xl2003 loaded anywhere that I could test it, so
hopefully someone with 2003 can take a look.

--
Regards,
Tom Ogilvy

wrote in message
...
Yes, it is loaded and is visible in project explorer.
It is quite a puzzle...

I even tried recording a macro of me creating a histogram
but that didn't work either. It crapped out with the same
error message.

-----Original Message-----
is ATPVBAEN.XLA loaded? (can you see it in the project
explorer in the
VBE?)

--
Regards,
Tom Ogilvy

"jimbuff" wrote in
message
...
Hi,

I'm having a strange problem with some VBA code that I
wrote which calls the histogram subroutine that is in
the
ATPVBAEN.XLA file. The relevant code is:
Application.Run "ATPVBAEN.XLA!Histogram", inputrange,
outputrange, , False, False, False, False

Excel 2003 (but not earlier versions) craps out with the
error:

Run-time error '1004':
The macro '' cannot be found.

Could anyone suggest any solutions. I've done the
obvious
of making sure that the object library is referenced,
macro security is set to low, trust vb applications is
checked.

Thanks in advance.

Jim.


.