By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,529 Members | 1,860 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,529 IT Pros & Developers. It's quick & easy.

Stumped - VB6 Com Obj can't access MS Excel

P: n/a
This most likely belongs in another forum but I thought I'd start here. I
have a COM Object written in VB6. The DLL will access MS Excel and use it's
Object Library to write a customized report and saves it to a folder. The
DLL even writes to a log for each step it takes so we can troubleshoot the
problems (if any).

This works fine on one machine but not another. The folder the DLL is trying
to write to has full permissions assigned to and is wide open. Furthermore,
the log txt file is being written in the same folder with no problems so I
know it's not a folder permissions issue. The problem seems to be when the
DLL tries to access MS Excel. The DLL is simple told "permission denied" by
Windows.

I would appreciate any pointers!

Nov 19 '05 #1
Share this Question
Share on Google+
12 Replies


P: n/a
Joe
Permission denied to what? The Excel workbook? Directory? You don't know?

This is an off-the-cuff guess: are you creating multiple instances of Excel
and not quitting each one when done using the application?

Just a guess.

HTH,
--
Joe

VB.NET/C#/ASP.NET/ASP/VB/C++/Web and DB development/VBA Automation
"D. Shane Fowlkes" wrote:
This most likely belongs in another forum but I thought I'd start here. I
have a COM Object written in VB6. The DLL will access MS Excel and use it's
Object Library to write a customized report and saves it to a folder. The
DLL even writes to a log for each step it takes so we can troubleshoot the
problems (if any).

This works fine on one machine but not another. The folder the DLL is trying
to write to has full permissions assigned to and is wide open. Furthermore,
the log txt file is being written in the same folder with no problems so I
know it's not a folder permissions issue. The problem seems to be when the
DLL tries to access MS Excel. The DLL is simple told "permission denied" by
Windows.

I would appreciate any pointers!

Nov 19 '05 #2

P: n/a
I don't think so. It failed on the first attempt.

The best was I can describe it is that the DLL is being denied permission to
Excel itself. Excel is installed on the machine just for this function. The
log we have tracks every single move and action and seems to be denied
access to Excel immediately as soon as it tries to access it. I'm 99% sure
this isn't a folder permissions issue.


"Joe" <jo******@donotspam.yahoo.com> wrote in message
news:DB**********************************@microsof t.com...
Permission denied to what? The Excel workbook? Directory? You don't
know?

This is an off-the-cuff guess: are you creating multiple instances of
Excel
and not quitting each one when done using the application?

Just a guess.

HTH,
--
Joe

VB.NET/C#/ASP.NET/ASP/VB/C++/Web and DB development/VBA Automation
"D. Shane Fowlkes" wrote:
This most likely belongs in another forum but I thought I'd start here.
I
have a COM Object written in VB6. The DLL will access MS Excel and use
it's
Object Library to write a customized report and saves it to a folder.
The
DLL even writes to a log for each step it takes so we can troubleshoot
the
problems (if any).

This works fine on one machine but not another. The folder the DLL is
trying
to write to has full permissions assigned to and is wide open.
Furthermore,
the log txt file is being written in the same folder with no problems so
I
know it's not a folder permissions issue. The problem seems to be when
the
DLL tries to access MS Excel. The DLL is simple told "permission denied"
by
Windows.

I would appreciate any pointers!

Nov 19 '05 #3

P: n/a
Joe
Do you know that the DLL works with other apps? If not, do you have source
code?
--
Joe

VB.NET/C#/ASP.NET/ASP/VB/C++/Web and DB development/VBA Automation
"D. Shane Fowlkes" wrote:
I don't think so. It failed on the first attempt.

The best was I can describe it is that the DLL is being denied permission to
Excel itself. Excel is installed on the machine just for this function. The
log we have tracks every single move and action and seems to be denied
access to Excel immediately as soon as it tries to access it. I'm 99% sure
this isn't a folder permissions issue.


"Joe" <jo******@donotspam.yahoo.com> wrote in message
news:DB**********************************@microsof t.com...
Permission denied to what? The Excel workbook? Directory? You don't
know?

This is an off-the-cuff guess: are you creating multiple instances of
Excel
and not quitting each one when done using the application?

Just a guess.

HTH,
--
Joe

VB.NET/C#/ASP.NET/ASP/VB/C++/Web and DB development/VBA Automation
"D. Shane Fowlkes" wrote:
This most likely belongs in another forum but I thought I'd start here.
I
have a COM Object written in VB6. The DLL will access MS Excel and use
it's
Object Library to write a customized report and saves it to a folder.
The
DLL even writes to a log for each step it takes so we can troubleshoot
the
problems (if any).

This works fine on one machine but not another. The folder the DLL is
trying
to write to has full permissions assigned to and is wide open.
Furthermore,
the log txt file is being written in the same folder with no problems so
I
know it's not a folder permissions issue. The problem seems to be when
the
DLL tries to access MS Excel. The DLL is simple told "permission denied"
by
Windows.

I would appreciate any pointers!


Nov 19 '05 #4

P: n/a
It works on two other servers. Nothing special was done to these other
servers.

Would I need to assign or check some obscure system user account like IWAM_
special permissions or something to the EXCEL.EXE file or something? Again,
I can find anything unusual on the machines it does work on.

"Joe" <jo******@donotspam.yahoo.com> wrote in message
news:6D**********************************@microsof t.com...
Do you know that the DLL works with other apps? If not, do you have
source
code?
--
Joe

VB.NET/C#/ASP.NET/ASP/VB/C++/Web and DB development/VBA Automation
"D. Shane Fowlkes" wrote:
I don't think so. It failed on the first attempt.

The best was I can describe it is that the DLL is being denied permission
to
Excel itself. Excel is installed on the machine just for this function.
The
log we have tracks every single move and action and seems to be denied
access to Excel immediately as soon as it tries to access it. I'm 99%
sure
this isn't a folder permissions issue.


"Joe" <jo******@donotspam.yahoo.com> wrote in message
news:DB**********************************@microsof t.com...
> Permission denied to what? The Excel workbook? Directory? You don't
> know?
>
> This is an off-the-cuff guess: are you creating multiple instances of
> Excel
> and not quitting each one when done using the application?
>
> Just a guess.
>
> HTH,
> --
> Joe
>
> VB.NET/C#/ASP.NET/ASP/VB/C++/Web and DB development/VBA Automation
>
>
> "D. Shane Fowlkes" wrote:
>
>> This most likely belongs in another forum but I thought I'd start
>> here.
>> I
>> have a COM Object written in VB6. The DLL will access MS Excel and
>> use
>> it's
>> Object Library to write a customized report and saves it to a folder.
>> The
>> DLL even writes to a log for each step it takes so we can troubleshoot
>> the
>> problems (if any).
>>
>> This works fine on one machine but not another. The folder the DLL is
>> trying
>> to write to has full permissions assigned to and is wide open.
>> Furthermore,
>> the log txt file is being written in the same folder with no problems
>> so
>> I
>> know it's not a folder permissions issue. The problem seems to be when
>> the
>> DLL tries to access MS Excel. The DLL is simple told "permission
>> denied"
>> by
>> Windows.
>>
>> I would appreciate any pointers!
>>
>>
>>
>>


Nov 19 '05 #5

P: n/a
Joe
So if you know that this web app runs on two other servers, the problem must
be on the third server. Does that DLL automate any other apps? As far as I
know, Excel doesn't require any special permissions to run. So see what else
is different. Compare IIS permissions; unregister and reregister the DLL;
etc.

Wish I could contribute more, but there are too many unknowns.
--
Joe

VB.NET/C#/ASP.NET/ASP/VB/C++/Web and DB development/VBA Automation
"D. Shane Fowlkes" wrote:
It works on two other servers. Nothing special was done to these other
servers.

Would I need to assign or check some obscure system user account like IWAM_
special permissions or something to the EXCEL.EXE file or something? Again,
I can find anything unusual on the machines it does work on.

"Joe" <jo******@donotspam.yahoo.com> wrote in message
news:6D**********************************@microsof t.com...
Do you know that the DLL works with other apps? If not, do you have
source
code?
--
Joe

VB.NET/C#/ASP.NET/ASP/VB/C++/Web and DB development/VBA Automation
"D. Shane Fowlkes" wrote:
I don't think so. It failed on the first attempt.

The best was I can describe it is that the DLL is being denied permission
to
Excel itself. Excel is installed on the machine just for this function.
The
log we have tracks every single move and action and seems to be denied
access to Excel immediately as soon as it tries to access it. I'm 99%
sure
this isn't a folder permissions issue.


"Joe" <jo******@donotspam.yahoo.com> wrote in message
news:DB**********************************@microsof t.com...
> Permission denied to what? The Excel workbook? Directory? You don't
> know?
>
> This is an off-the-cuff guess: are you creating multiple instances of
> Excel
> and not quitting each one when done using the application?
>
> Just a guess.
>
> HTH,
> --
> Joe
>
> VB.NET/C#/ASP.NET/ASP/VB/C++/Web and DB development/VBA Automation
>
>
> "D. Shane Fowlkes" wrote:
>
>> This most likely belongs in another forum but I thought I'd start
>> here.
>> I
>> have a COM Object written in VB6. The DLL will access MS Excel and
>> use
>> it's
>> Object Library to write a customized report and saves it to a folder.
>> The
>> DLL even writes to a log for each step it takes so we can troubleshoot
>> the
>> problems (if any).
>>
>> This works fine on one machine but not another. The folder the DLL is
>> trying
>> to write to has full permissions assigned to and is wide open.
>> Furthermore,
>> the log txt file is being written in the same folder with no problems
>> so
>> I
>> know it's not a folder permissions issue. The problem seems to be when
>> the
>> DLL tries to access MS Excel. The DLL is simple told "permission
>> denied"
>> by
>> Windows.
>>
>> I would appreciate any pointers!
>>
>>
>>
>>


Nov 19 '05 #6

P: n/a
Thanks for your help. The problem is that the issue is on the live web
server which is run by a 3rd party. They're not inclined to address the
issue since it's such a special request. The best I can do is ask that they
check this and check that. But unless I know what is actually causing the
issues, I'm stuck. They're simply going to deny anything is wrong on their
since everything they keep checking ..things I blindy guess at....seems OK.


"Joe" <jo******@donotspam.yahoo.com> wrote in message
news:B1**********************************@microsof t.com...
So if you know that this web app runs on two other servers, the problem
must
be on the third server. Does that DLL automate any other apps? As far as
I
know, Excel doesn't require any special permissions to run. So see what
else
is different. Compare IIS permissions; unregister and reregister the DLL;
etc.

Wish I could contribute more, but there are too many unknowns.
--
Joe

VB.NET/C#/ASP.NET/ASP/VB/C++/Web and DB development/VBA Automation
"D. Shane Fowlkes" wrote:
It works on two other servers. Nothing special was done to these other
servers.

Would I need to assign or check some obscure system user account like
IWAM_
special permissions or something to the EXCEL.EXE file or something?
Again,
I can find anything unusual on the machines it does work on.

"Joe" <jo******@donotspam.yahoo.com> wrote in message
news:6D**********************************@microsof t.com...
> Do you know that the DLL works with other apps? If not, do you have
> source
> code?
> --
> Joe
>
> VB.NET/C#/ASP.NET/ASP/VB/C++/Web and DB development/VBA Automation
>
>
> "D. Shane Fowlkes" wrote:
>
>> I don't think so. It failed on the first attempt.
>>
>> The best was I can describe it is that the DLL is being denied
>> permission
>> to
>> Excel itself. Excel is installed on the machine just for this
>> function.
>> The
>> log we have tracks every single move and action and seems to be denied
>> access to Excel immediately as soon as it tries to access it. I'm 99%
>> sure
>> this isn't a folder permissions issue.
>>
>>
>>
>>
>> "Joe" <jo******@donotspam.yahoo.com> wrote in message
>> news:DB**********************************@microsof t.com...
>> > Permission denied to what? The Excel workbook? Directory? You
>> > don't
>> > know?
>> >
>> > This is an off-the-cuff guess: are you creating multiple instances
>> > of
>> > Excel
>> > and not quitting each one when done using the application?
>> >
>> > Just a guess.
>> >
>> > HTH,
>> > --
>> > Joe
>> >
>> > VB.NET/C#/ASP.NET/ASP/VB/C++/Web and DB development/VBA Automation
>> >
>> >
>> > "D. Shane Fowlkes" wrote:
>> >
>> >> This most likely belongs in another forum but I thought I'd start
>> >> here.
>> >> I
>> >> have a COM Object written in VB6. The DLL will access MS Excel and
>> >> use
>> >> it's
>> >> Object Library to write a customized report and saves it to a
>> >> folder.
>> >> The
>> >> DLL even writes to a log for each step it takes so we can
>> >> troubleshoot
>> >> the
>> >> problems (if any).
>> >>
>> >> This works fine on one machine but not another. The folder the DLL
>> >> is
>> >> trying
>> >> to write to has full permissions assigned to and is wide open.
>> >> Furthermore,
>> >> the log txt file is being written in the same folder with no
>> >> problems
>> >> so
>> >> I
>> >> know it's not a folder permissions issue. The problem seems to be
>> >> when
>> >> the
>> >> DLL tries to access MS Excel. The DLL is simple told "permission
>> >> denied"
>> >> by
>> >> Windows.
>> >>
>> >> I would appreciate any pointers!
>> >>
>> >>
>> >>
>> >>
>>
>>
>>


Nov 19 '05 #7

P: n/a
Source Code:
Public Function POPSpreadsheet(DB .) As Variant

'================================================= =======================

'Create the selected Program Of Projects reports on an Excel spreadsheet

'================================================= =======================

Dim xlApp As Excel.Application

Dim xlTemplate As Excel.Workbook

Dim xlSheet As Excel.Worksheet

'Begin Log entry

Call WriteLogFile(LOG_FILE_NAME,
"============================================= ")

Call WriteLogFile(LOG_FILE_NAME, "Beginning POPSpreadsheet Function. DB
= " & DB)

'Open Excel

Call WriteLogFile(LOG_FILE_NAME, "About to begin Excel.")

Set xlApp = CreateObject("Excel.Application")

Call WriteLogFile(LOG_FILE_NAME, "Excel running.")



It seems to be failing on Set xlApp = CreateObject(("Excel.Application")

Thanks again

"Joe" <jo******@donotspam.yahoo.com> wrote in message
news:B1**********************************@microsof t.com...
So if you know that this web app runs on two other servers, the problem
must
be on the third server. Does that DLL automate any other apps? As far as
I
know, Excel doesn't require any special permissions to run. So see what
else
is different. Compare IIS permissions; unregister and reregister the DLL;
etc.

Wish I could contribute more, but there are too many unknowns.
--
Joe

VB.NET/C#/ASP.NET/ASP/VB/C++/Web and DB development/VBA Automation
"D. Shane Fowlkes" wrote:
It works on two other servers. Nothing special was done to these other
servers.

Would I need to assign or check some obscure system user account like
IWAM_
special permissions or something to the EXCEL.EXE file or something?
Again,
I can find anything unusual on the machines it does work on.

"Joe" <jo******@donotspam.yahoo.com> wrote in message
news:6D**********************************@microsof t.com...
> Do you know that the DLL works with other apps? If not, do you have
> source
> code?
> --
> Joe
>
> VB.NET/C#/ASP.NET/ASP/VB/C++/Web and DB development/VBA Automation
>
>
> "D. Shane Fowlkes" wrote:
>
>> I don't think so. It failed on the first attempt.
>>
>> The best was I can describe it is that the DLL is being denied
>> permission
>> to
>> Excel itself. Excel is installed on the machine just for this
>> function.
>> The
>> log we have tracks every single move and action and seems to be denied
>> access to Excel immediately as soon as it tries to access it. I'm 99%
>> sure
>> this isn't a folder permissions issue.
>>
>>
>>
>>
>> "Joe" <jo******@donotspam.yahoo.com> wrote in message
>> news:DB**********************************@microsof t.com...
>> > Permission denied to what? The Excel workbook? Directory? You
>> > don't
>> > know?
>> >
>> > This is an off-the-cuff guess: are you creating multiple instances
>> > of
>> > Excel
>> > and not quitting each one when done using the application?
>> >
>> > Just a guess.
>> >
>> > HTH,
>> > --
>> > Joe
>> >
>> > VB.NET/C#/ASP.NET/ASP/VB/C++/Web and DB development/VBA Automation
>> >
>> >
>> > "D. Shane Fowlkes" wrote:
>> >
>> >> This most likely belongs in another forum but I thought I'd start
>> >> here.
>> >> I
>> >> have a COM Object written in VB6. The DLL will access MS Excel and
>> >> use
>> >> it's
>> >> Object Library to write a customized report and saves it to a
>> >> folder.
>> >> The
>> >> DLL even writes to a log for each step it takes so we can
>> >> troubleshoot
>> >> the
>> >> problems (if any).
>> >>
>> >> This works fine on one machine but not another. The folder the DLL
>> >> is
>> >> trying
>> >> to write to has full permissions assigned to and is wide open.
>> >> Furthermore,
>> >> the log txt file is being written in the same folder with no
>> >> problems
>> >> so
>> >> I
>> >> know it's not a folder permissions issue. The problem seems to be
>> >> when
>> >> the
>> >> DLL tries to access MS Excel. The DLL is simple told "permission
>> >> denied"
>> >> by
>> >> Windows.
>> >>
>> >> I would appreciate any pointers!
>> >>
>> >>
>> >>
>> >>
>>
>>
>>


Nov 19 '05 #8

P: n/a
"D. Shane Fowlkes" <sh**********@h-o-t-m-a-i-l.com> wrote in message
news:Og**************@TK2MSFTNGP09.phx.gbl...
This most likely belongs in another forum but I thought I'd start here.


Well, it clearly has little if anything to do with ASP.NET...

Did you try any of the VB6 forums? Or the Excel forums?
Nov 19 '05 #9

P: n/a
Joe
Shane,

Set a reference in your VB6 DLL to the Excel object library. Use that
referemnce when creating an Excel app object.

Dim xlApp as Excel.Application
Set xlApp = new Excel.Application

blah blah blah

xlApp.Quit
Set xlApp = Nothing

HTH,
--
Joe

VB.NET/C#/ASP.NET/ASP/VB/C++/Web and DB development/VBA Automation
"D. Shane Fowlkes" wrote:
Source Code:
Public Function POPSpreadsheet(DB .) As Variant

'================================================= =======================

'Create the selected Program Of Projects reports on an Excel spreadsheet

'================================================= =======================

Dim xlApp As Excel.Application

Dim xlTemplate As Excel.Workbook

Dim xlSheet As Excel.Worksheet

'Begin Log entry

Call WriteLogFile(LOG_FILE_NAME,
"============================================= ")

Call WriteLogFile(LOG_FILE_NAME, "Beginning POPSpreadsheet Function. DB
= " & DB)

'Open Excel

Call WriteLogFile(LOG_FILE_NAME, "About to begin Excel.")

Set xlApp = CreateObject("Excel.Application")

Call WriteLogFile(LOG_FILE_NAME, "Excel running.")



It seems to be failing on Set xlApp = CreateObject(("Excel.Application")

Thanks again

"Joe" <jo******@donotspam.yahoo.com> wrote in message
news:B1**********************************@microsof t.com...
So if you know that this web app runs on two other servers, the problem
must
be on the third server. Does that DLL automate any other apps? As far as
I
know, Excel doesn't require any special permissions to run. So see what
else
is different. Compare IIS permissions; unregister and reregister the DLL;
etc.

Wish I could contribute more, but there are too many unknowns.
--
Joe

VB.NET/C#/ASP.NET/ASP/VB/C++/Web and DB development/VBA Automation
"D. Shane Fowlkes" wrote:
It works on two other servers. Nothing special was done to these other
servers.

Would I need to assign or check some obscure system user account like
IWAM_
special permissions or something to the EXCEL.EXE file or something?
Again,
I can find anything unusual on the machines it does work on.

"Joe" <jo******@donotspam.yahoo.com> wrote in message
news:6D**********************************@microsof t.com...
> Do you know that the DLL works with other apps? If not, do you have
> source
> code?
> --
> Joe
>
> VB.NET/C#/ASP.NET/ASP/VB/C++/Web and DB development/VBA Automation
>
>
> "D. Shane Fowlkes" wrote:
>
>> I don't think so. It failed on the first attempt.
>>
>> The best was I can describe it is that the DLL is being denied
>> permission
>> to
>> Excel itself. Excel is installed on the machine just for this
>> function.
>> The
>> log we have tracks every single move and action and seems to be denied
>> access to Excel immediately as soon as it tries to access it. I'm 99%
>> sure
>> this isn't a folder permissions issue.
>>
>>
>>
>>
>> "Joe" <jo******@donotspam.yahoo.com> wrote in message
>> news:DB**********************************@microsof t.com...
>> > Permission denied to what? The Excel workbook? Directory? You
>> > don't
>> > know?
>> >
>> > This is an off-the-cuff guess: are you creating multiple instances
>> > of
>> > Excel
>> > and not quitting each one when done using the application?
>> >
>> > Just a guess.
>> >
>> > HTH,
>> > --
>> > Joe
>> >
>> > VB.NET/C#/ASP.NET/ASP/VB/C++/Web and DB development/VBA Automation
>> >
>> >
>> > "D. Shane Fowlkes" wrote:
>> >
>> >> This most likely belongs in another forum but I thought I'd start
>> >> here.
>> >> I
>> >> have a COM Object written in VB6. The DLL will access MS Excel and
>> >> use
>> >> it's
>> >> Object Library to write a customized report and saves it to a
>> >> folder.
>> >> The
>> >> DLL even writes to a log for each step it takes so we can
>> >> troubleshoot
>> >> the
>> >> problems (if any).
>> >>
>> >> This works fine on one machine but not another. The folder the DLL
>> >> is
>> >> trying
>> >> to write to has full permissions assigned to and is wide open.
>> >> Furthermore,
>> >> the log txt file is being written in the same folder with no
>> >> problems
>> >> so
>> >> I
>> >> know it's not a folder permissions issue. The problem seems to be
>> >> when
>> >> the
>> >> DLL tries to access MS Excel. The DLL is simple told "permission
>> >> denied"
>> >> by
>> >> Windows.
>> >>
>> >> I would appreciate any pointers!
>> >>
>> >>
>> >>
>> >>
>>
>>
>>


Nov 19 '05 #10

P: n/a
Thanks Joe. Not my code but will try it out.

"Joe" <jo******@donotspam.yahoo.com> wrote in message
news:95**********************************@microsof t.com...
Shane,

Set a reference in your VB6 DLL to the Excel object library. Use that
referemnce when creating an Excel app object.

Dim xlApp as Excel.Application
Set xlApp = new Excel.Application

blah blah blah

xlApp.Quit
Set xlApp = Nothing

HTH,
--
Joe

VB.NET/C#/ASP.NET/ASP/VB/C++/Web and DB development/VBA Automation
"D. Shane Fowlkes" wrote:
Source Code:
Public Function POPSpreadsheet(DB .) As Variant


'================================================= =======================

'Create the selected Program Of Projects reports on an Excel
spreadsheet
'================================================= =======================

Dim xlApp As Excel.Application

Dim xlTemplate As Excel.Workbook

Dim xlSheet As Excel.Worksheet

'Begin Log entry

Call WriteLogFile(LOG_FILE_NAME,
"============================================= ")

Call WriteLogFile(LOG_FILE_NAME, "Beginning POPSpreadsheet Function.
DB
= " & DB)

'Open Excel

Call WriteLogFile(LOG_FILE_NAME, "About to begin Excel.")

Set xlApp = CreateObject("Excel.Application")

Call WriteLogFile(LOG_FILE_NAME, "Excel running.")



It seems to be failing on Set xlApp = CreateObject(("Excel.Application")

Thanks again

"Joe" <jo******@donotspam.yahoo.com> wrote in message
news:B1**********************************@microsof t.com...
> So if you know that this web app runs on two other servers, the problem
> must
> be on the third server. Does that DLL automate any other apps? As far
> as
> I
> know, Excel doesn't require any special permissions to run. So see
> what
> else
> is different. Compare IIS permissions; unregister and reregister the
> DLL;
> etc.
>
> Wish I could contribute more, but there are too many unknowns.
> --
> Joe
>
> VB.NET/C#/ASP.NET/ASP/VB/C++/Web and DB development/VBA Automation
>
>
> "D. Shane Fowlkes" wrote:
>
>> It works on two other servers. Nothing special was done to these other
>> servers.
>>
>> Would I need to assign or check some obscure system user account like
>> IWAM_
>> special permissions or something to the EXCEL.EXE file or something?
>> Again,
>> I can find anything unusual on the machines it does work on.
>>
>>
>>
>> "Joe" <jo******@donotspam.yahoo.com> wrote in message
>> news:6D**********************************@microsof t.com...
>> > Do you know that the DLL works with other apps? If not, do you have
>> > source
>> > code?
>> > --
>> > Joe
>> >
>> > VB.NET/C#/ASP.NET/ASP/VB/C++/Web and DB development/VBA Automation
>> >
>> >
>> > "D. Shane Fowlkes" wrote:
>> >
>> >> I don't think so. It failed on the first attempt.
>> >>
>> >> The best was I can describe it is that the DLL is being denied
>> >> permission
>> >> to
>> >> Excel itself. Excel is installed on the machine just for this
>> >> function.
>> >> The
>> >> log we have tracks every single move and action and seems to be
>> >> denied
>> >> access to Excel immediately as soon as it tries to access it. I'm
>> >> 99%
>> >> sure
>> >> this isn't a folder permissions issue.
>> >>
>> >>
>> >>
>> >>
>> >> "Joe" <jo******@donotspam.yahoo.com> wrote in message
>> >> news:DB**********************************@microsof t.com...
>> >> > Permission denied to what? The Excel workbook? Directory? You
>> >> > don't
>> >> > know?
>> >> >
>> >> > This is an off-the-cuff guess: are you creating multiple
>> >> > instances
>> >> > of
>> >> > Excel
>> >> > and not quitting each one when done using the application?
>> >> >
>> >> > Just a guess.
>> >> >
>> >> > HTH,
>> >> > --
>> >> > Joe
>> >> >
>> >> > VB.NET/C#/ASP.NET/ASP/VB/C++/Web and DB development/VBA
>> >> > Automation
>> >> >
>> >> >
>> >> > "D. Shane Fowlkes" wrote:
>> >> >
>> >> >> This most likely belongs in another forum but I thought I'd
>> >> >> start
>> >> >> here.
>> >> >> I
>> >> >> have a COM Object written in VB6. The DLL will access MS Excel
>> >> >> and
>> >> >> use
>> >> >> it's
>> >> >> Object Library to write a customized report and saves it to a
>> >> >> folder.
>> >> >> The
>> >> >> DLL even writes to a log for each step it takes so we can
>> >> >> troubleshoot
>> >> >> the
>> >> >> problems (if any).
>> >> >>
>> >> >> This works fine on one machine but not another. The folder the
>> >> >> DLL
>> >> >> is
>> >> >> trying
>> >> >> to write to has full permissions assigned to and is wide open.
>> >> >> Furthermore,
>> >> >> the log txt file is being written in the same folder with no
>> >> >> problems
>> >> >> so
>> >> >> I
>> >> >> know it's not a folder permissions issue. The problem seems to
>> >> >> be
>> >> >> when
>> >> >> the
>> >> >> DLL tries to access MS Excel. The DLL is simple told
>> >> >> "permission
>> >> >> denied"
>> >> >> by
>> >> >> Windows.
>> >> >>
>> >> >> I would appreciate any pointers!
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>


Nov 19 '05 #11

P: n/a

"D. Shane Fowlkes" <sh**********@h-o-t-m-a-i-l.com> wrote in message
news:Og**************@TK2MSFTNGP09.phx.gbl...
This most likely belongs in another forum but I thought I'd start here. I
have a COM Object written in VB6. The DLL will access MS Excel and use
it's Object Library to write a customized report and saves it to a folder.
The DLL even writes to a log for each step it takes so we can troubleshoot
the problems (if any).

This works fine on one machine but not another. The folder the DLL is
trying to write to has full permissions assigned to and is wide open.
Furthermore, the log txt file is being written in the same folder with no
problems so I know it's not a folder permissions issue. The problem seems
to be when the DLL tries to access MS Excel. The DLL is simple told
"permission denied" by Windows.

I would appreciate any pointers!


It sounds as though excel is indeed installed on the server.
This is just a guess, but you may have to use dcomcnfg to give permissions
to the interactive user.
Might be tough to do on someone else's server though.


Nov 19 '05 #12

P: n/a
Would you mind elaborating on the "interactive user"? You're on the right
track, Microsoft referrs to the dcomcnfg due to the error logged: 10003.

The server guys are in denial and I want to point them in the right
direction.

Thanks!!
"logan" <lo***@ndgkbajhajksdgvb.com> wrote in message
news:Op****************@TK2MSFTNGP14.phx.gbl...

"D. Shane Fowlkes" <sh**********@h-o-t-m-a-i-l.com> wrote in message
news:Og**************@TK2MSFTNGP09.phx.gbl...
This most likely belongs in another forum but I thought I'd start here.
I have a COM Object written in VB6. The DLL will access MS Excel and use
it's Object Library to write a customized report and saves it to a
folder. The DLL even writes to a log for each step it takes so we can
troubleshoot the problems (if any).

This works fine on one machine but not another. The folder the DLL is
trying to write to has full permissions assigned to and is wide open.
Furthermore, the log txt file is being written in the same folder with no
problems so I know it's not a folder permissions issue. The problem seems
to be when the DLL tries to access MS Excel. The DLL is simple told
"permission denied" by Windows.

I would appreciate any pointers!


It sounds as though excel is indeed installed on the server.
This is just a guess, but you may have to use dcomcnfg to give
permissions to the interactive user.
Might be tough to do on someone else's server though.

Nov 19 '05 #13

This discussion thread is closed

Replies have been disabled for this discussion.