Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to delete a class category in histogram, Excel 2003? | Charts and Charting in Excel | |||
Does Excel 2003 have CDF feature in its histogram plotting function? | Excel Discussion (Misc queries) | |||
Changing ZIP code formats in Excel 2003 | Excel Discussion (Misc queries) | |||
I was creating a histogram; now i have data but no histogram. | Excel Worksheet Functions | |||
How to Histogram w/o raw data but histogram Table on Excel | Charts and Charting in Excel |