Actually I do have to use the COM object since CFContent doesn't exactly
handle the data in the manner that I need.
Basically I'm using the HTML2EXCEL custom tag. It connects to the COM
object, opens the HTML file specified, performs a global search and
replace, changing a non-printing character to a single quote (') which
forces certian cells to be text fields. This is the reason I have to
use Excel. The client uses numeric part numbers in some cases with
leading zeroes... 000001 is the part number, but without the apostrophe,
which *has* to be entered in Excel itself, it changes it to 1... there
was a thread on that issue some time back.
Anyways, when I try to connect to/create the object I am getting the
error message:
Error trying to create object specified in the tag.
COM error 0x80070005. Access is denied.
The reason for the "news article" format... it gets more attention ;)
Hatton
Erika L. Walker-Arnold wrote:
> Er, ... GREAT message. Loved the creative touch.
>
> However ... What EXACTLY are you trying to do?
>
> If it's just create a downloadable excel file ... You don't need COM
> Objects ....
>
> Erika
> ------------------------------------------------------------
>
>
>>>| -----Original Message-----
>>>| From: Hatton Humphrey [mailto:[EMAIL PROTECTED]]
>>>| Sent: Wednesday, July 10, 2002 2:09 PM
>>>| To: CF-Community
>>>| Subject: Excel COM Object or CFObject Tag Directly Linked
>>>| to Hair Loss
>>>|
>>>|
>>>| Amherst, NY: Software developer Hatton Humphrey has a
>>>| problem. He's
>>>| loosing his hair, and at an alarming rate.
>>>|
>>>| "Before I tried messing with this ColdFusion stuff I was
>>>| your average
>>>| developer. Sure, I'd run into different problems here and
>>>| there, but
>>>| never something of this magnitude," Hatton said when asked what the
>>>| source of his woes were.
>>>|
>>>| "Now I'm trying to provide something nice for a client and
>>>| use Microsoft
>>>| Excel to give them a downloadable list of items. It will
>>>| work in one
>>>| environment but not the other."
>>>|
>>>| Exasserbated, Hatton has turned to his network administrator and a
>>>| popular COM website, cfcomet.com. Using these resources he
>>>| has, "tried
>>>| every option, thought or suggestion," to no success.
>>>|
>>>| In response to the elevated levels of stress, Hatton's hairline has
>>>| responded by accelerating it's rate of recession. If
>>>| things don't work
>>>| out soon he may need to invest in Rogaine or one of the nicer
>>>| non-prescription hair growth formulas.
>>>|
>>>| In a desparate plea for help, Hatton is sending out requests for
>>>| assistance to fellow ColdFusion developers.
>>>|
>>>| "I've checked users permissions, created a new local user
>>>| and assigned
>>>| it to run the server... even reinstalled Excel at one point
>>>| in time.
>>>| None of it seems to make any difference. I keep getting
>>>| 'Error trying
>>>| to create object specified in the tag. COM error
>>>| 0x80070005. Access is
>>>| denied.' messages. I guess there are still things that I'm
>>>| missing here."
>>>|
>>>| Anyone with information relating to this problem is encouraged to
>>>| respond to posts and reposts of this message. The system
>>>| in question is
>>>| running Windows 2000 and IIS 5.0 with Microsoft Excel 2000
>>>| installed.
>>>|
>>>| "Please, any advice will help at this stage! I don't want
>>>| to be bald
>>>| before my daugther walks!"
>>>|
>>>|
>>>|
>>>
>
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
