ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Getting "Permission Denied error 70" on Windows XP and 2003 (https://www.excelbanter.com/excel-programming/413990-getting-permission-denied-error-70-windows-xp-2003-a.html)

Lalit Chaudhari

Getting "Permission Denied error 70" on Windows XP and 2003
 
Hi All,

I have developed a VBA program which will automatically make decisions on
the web page. It is working fine on Windows 2000. But its giving error as
"Permission Denied error 70" on Windows XP and 2003.

Can you please let me know if anybody knows the solution for this?

joel

Getting "Permission Denied error 70" on Windows XP and 2003
 
I think they fixed a security problem with excel 2000 in excel 2003 which
performed an access test before creating a new file. Try manually creating
the file in the same directory by doing a saveas from the spreadhsheet. You
need to get the permission changed in the directory yoiu are writting to.

"Lalit Chaudhari" wrote:

Hi All,

I have developed a VBA program which will automatically make decisions on
the web page. It is working fine on Windows 2000. But its giving error as
"Permission Denied error 70" on Windows XP and 2003.

Can you please let me know if anybody knows the solution for this?


Lalit Chaudhari[_2_]

Getting "Permission Denied error 70" on Windows XP and 2003
 
Thanks for the reply. But i am not writing to anyfile. I am just automating
the web browser to do some steps. I am getting the error on the below first
line. Actually the following code is in the loop. When the item is checkbox
or radio-box its working but when it will be the Listbox, its giving the
error!

If element.Type = "select-one" Then
Debug.print "List Box"
Else
Call element.Click
Debug.Print "Selecting Save Tool: " & element.ID
Do While IEVNT.Busy: DoEvents: Loop
End If

"Joel" wrote:

I think they fixed a security problem with excel 2000 in excel 2003 which
performed an access test before creating a new file. Try manually creating
the file in the same directory by doing a saveas from the spreadhsheet. You
need to get the permission changed in the directory yoiu are writting to.

"Lalit Chaudhari" wrote:

Hi All,

I have developed a VBA program which will automatically make decisions on
the web page. It is working fine on Windows 2000. But its giving error as
"Permission Denied error 70" on Windows XP and 2003.

Can you please let me know if anybody knows the solution for this?


joel

Getting "Permission Denied error 70" on Windows XP and 2003
 
There isn't enough information for me to repeat the problem. I don't know
how element is defined.

"Lalit Chaudhari" wrote:

Thanks for the reply. But i am not writing to anyfile. I am just automating
the web browser to do some steps. I am getting the error on the below first
line. Actually the following code is in the loop. When the item is checkbox
or radio-box its working but when it will be the Listbox, its giving the
error!

If element.Type = "select-one" Then
Debug.print "List Box"
Else
Call element.Click
Debug.Print "Selecting Save Tool: " & element.ID
Do While IEVNT.Busy: DoEvents: Loop
End If

"Joel" wrote:

I think they fixed a security problem with excel 2000 in excel 2003 which
performed an access test before creating a new file. Try manually creating
the file in the same directory by doing a saveas from the spreadhsheet. You
need to get the permission changed in the directory yoiu are writting to.

"Lalit Chaudhari" wrote:

Hi All,

I have developed a VBA program which will automatically make decisions on
the web page. It is working fine on Windows 2000. But its giving error as
"Permission Denied error 70" on Windows XP and 2003.

Can you please let me know if anybody knows the solution for this?


Lalit Chaudhari[_2_]

Getting "Permission Denied error 70" on Windows XP and 2003
 
Below is the code for your reference:

For Each element In IEVNT.Document.getElementsByName("savetool")
If element.Type = "select-one" Then
Debug.print "List Box"
Else
Call element.Click
Debug.Print "Selecting Save Tool: " &
element.ID
Do While IEVNT.Busy: DoEvents: Loop
End If
Next element

"Joel" wrote:

There isn't enough information for me to repeat the problem. I don't know
how element is defined.

"Lalit Chaudhari" wrote:

Thanks for the reply. But i am not writing to anyfile. I am just automating
the web browser to do some steps. I am getting the error on the below first
line. Actually the following code is in the loop. When the item is checkbox
or radio-box its working but when it will be the Listbox, its giving the
error!

If element.Type = "select-one" Then
Debug.print "List Box"
Else
Call element.Click
Debug.Print "Selecting Save Tool: " & element.ID
Do While IEVNT.Busy: DoEvents: Loop
End If

"Joel" wrote:

I think they fixed a security problem with excel 2000 in excel 2003 which
performed an access test before creating a new file. Try manually creating
the file in the same directory by doing a saveas from the spreadhsheet. You
need to get the permission changed in the directory yoiu are writting to.

"Lalit Chaudhari" wrote:

Hi All,

I have developed a VBA program which will automatically make decisions on
the web page. It is working fine on Windows 2000. But its giving error as
"Permission Denied error 70" on Windows XP and 2003.

Can you please let me know if anybody knows the solution for this?


joel

Getting "Permission Denied error 70" on Windows XP and 2003
 
You have a number of problems with the code

first your declaration LoadFileDate deson't match the call.

LoadFileDate(CBTfilesArray)

and

Function LoadFileDate()

I still don't have enough info to solve the problem. e-mail mye the file
and I will look at it

joel dot warburg at itt dot com

"Lalit Chaudhari" wrote:

Below is the code for your reference:

For Each element In IEVNT.Document.getElementsByName("savetool")
If element.Type = "select-one" Then
Debug.print "List Box"
Else
Call element.Click
Debug.Print "Selecting Save Tool: " &
element.ID
Do While IEVNT.Busy: DoEvents: Loop
End If
Next element

"Joel" wrote:

There isn't enough information for me to repeat the problem. I don't know
how element is defined.

"Lalit Chaudhari" wrote:

Thanks for the reply. But i am not writing to anyfile. I am just automating
the web browser to do some steps. I am getting the error on the below first
line. Actually the following code is in the loop. When the item is checkbox
or radio-box its working but when it will be the Listbox, its giving the
error!

If element.Type = "select-one" Then
Debug.print "List Box"
Else
Call element.Click
Debug.Print "Selecting Save Tool: " & element.ID
Do While IEVNT.Busy: DoEvents: Loop
End If

"Joel" wrote:

I think they fixed a security problem with excel 2000 in excel 2003 which
performed an access test before creating a new file. Try manually creating
the file in the same directory by doing a saveas from the spreadhsheet. You
need to get the permission changed in the directory yoiu are writting to.

"Lalit Chaudhari" wrote:

Hi All,

I have developed a VBA program which will automatically make decisions on
the web page. It is working fine on Windows 2000. But its giving error as
"Permission Denied error 70" on Windows XP and 2003.

Can you please let me know if anybody knows the solution for this?


Lalit Chaudhari[_2_]

Getting "Permission Denied error 70" on Windows XP and 2003
 
Hi,
But i am not understanding where i have written "LoadFileDate" function?
Also i am not able to find the option to send the file!
Again i am pasting my code:
For Each element In IEVNT.Document.getElementsByName("savetool")
If element.Type = "select-one" Then
Debug.print "List Box"
Else
Call element.Click
Debug.Print "Selecting Save Tool: " & element.ID
Do While IEVNT.Busy: DoEvents: Loop
End If
Next element

==================================================

"Joel" wrote:

You have a number of problems with the code

first your declaration LoadFileDate deson't match the call.

LoadFileDate(CBTfilesArray)

and

Function LoadFileDate()

I still don't have enough info to solve the problem. e-mail mye the file
and I will look at it

joel dot warburg at itt dot com

"Lalit Chaudhari" wrote:

Below is the code for your reference:

For Each element In IEVNT.Document.getElementsByName("savetool")
If element.Type = "select-one" Then
Debug.print "List Box"
Else
Call element.Click
Debug.Print "Selecting Save Tool: " &
element.ID
Do While IEVNT.Busy: DoEvents: Loop
End If
Next element

"Joel" wrote:

There isn't enough information for me to repeat the problem. I don't know
how element is defined.

"Lalit Chaudhari" wrote:

Thanks for the reply. But i am not writing to anyfile. I am just automating
the web browser to do some steps. I am getting the error on the below first
line. Actually the following code is in the loop. When the item is checkbox
or radio-box its working but when it will be the Listbox, its giving the
error!

If element.Type = "select-one" Then
Debug.print "List Box"
Else
Call element.Click
Debug.Print "Selecting Save Tool: " & element.ID
Do While IEVNT.Busy: DoEvents: Loop
End If

"Joel" wrote:

I think they fixed a security problem with excel 2000 in excel 2003 which
performed an access test before creating a new file. Try manually creating
the file in the same directory by doing a saveas from the spreadhsheet. You
need to get the permission changed in the directory yoiu are writting to.

"Lalit Chaudhari" wrote:

Hi All,

I have developed a VBA program which will automatically make decisions on
the web page. It is working fine on Windows 2000. But its giving error as
"Permission Denied error 70" on Windows XP and 2003.

Can you please let me know if anybody knows the solution for this?


joel

Getting "Permission Denied error 70" on Windows XP and 2003
 
Send the file as an attahment using your e-mail tool. Don't use the
Dsicussion Group web tools.

"Lalit Chaudhari" wrote:

Hi,
But i am not understanding where i have written "LoadFileDate" function?
Also i am not able to find the option to send the file!
Again i am pasting my code:
For Each element In IEVNT.Document.getElementsByName("savetool")
If element.Type = "select-one" Then
Debug.print "List Box"
Else
Call element.Click
Debug.Print "Selecting Save Tool: " & element.ID
Do While IEVNT.Busy: DoEvents: Loop
End If
Next element

==================================================

"Joel" wrote:

You have a number of problems with the code

first your declaration LoadFileDate deson't match the call.

LoadFileDate(CBTfilesArray)

and

Function LoadFileDate()

I still don't have enough info to solve the problem. e-mail mye the file
and I will look at it

joel dot warburg at itt dot com

"Lalit Chaudhari" wrote:

Below is the code for your reference:

For Each element In IEVNT.Document.getElementsByName("savetool")
If element.Type = "select-one" Then
Debug.print "List Box"
Else
Call element.Click
Debug.Print "Selecting Save Tool: " &
element.ID
Do While IEVNT.Busy: DoEvents: Loop
End If
Next element

"Joel" wrote:

There isn't enough information for me to repeat the problem. I don't know
how element is defined.

"Lalit Chaudhari" wrote:

Thanks for the reply. But i am not writing to anyfile. I am just automating
the web browser to do some steps. I am getting the error on the below first
line. Actually the following code is in the loop. When the item is checkbox
or radio-box its working but when it will be the Listbox, its giving the
error!

If element.Type = "select-one" Then
Debug.print "List Box"
Else
Call element.Click
Debug.Print "Selecting Save Tool: " & element.ID
Do While IEVNT.Busy: DoEvents: Loop
End If

"Joel" wrote:

I think they fixed a security problem with excel 2000 in excel 2003 which
performed an access test before creating a new file. Try manually creating
the file in the same directory by doing a saveas from the spreadhsheet. You
need to get the permission changed in the directory yoiu are writting to.

"Lalit Chaudhari" wrote:

Hi All,

I have developed a VBA program which will automatically make decisions on
the web page. It is working fine on Windows 2000. But its giving error as
"Permission Denied error 70" on Windows XP and 2003.

Can you please let me know if anybody knows the solution for this?


Lalit Chaudhari[_2_]

Getting "Permission Denied error 70" on Windows XP and 2003
 
Can you please let me know your mail id?

"Joel" wrote:

Send the file as an attahment using your e-mail tool. Don't use the
Dsicussion Group web tools.

"Lalit Chaudhari" wrote:

Hi,
But i am not understanding where i have written "LoadFileDate" function?
Also i am not able to find the option to send the file!
Again i am pasting my code:
For Each element In IEVNT.Document.getElementsByName("savetool")
If element.Type = "select-one" Then
Debug.print "List Box"
Else
Call element.Click
Debug.Print "Selecting Save Tool: " & element.ID
Do While IEVNT.Busy: DoEvents: Loop
End If
Next element

==================================================

"Joel" wrote:

You have a number of problems with the code

first your declaration LoadFileDate deson't match the call.

LoadFileDate(CBTfilesArray)

and

Function LoadFileDate()

I still don't have enough info to solve the problem. e-mail mye the file
and I will look at it

joel dot warburg at itt dot com

"Lalit Chaudhari" wrote:

Below is the code for your reference:

For Each element In IEVNT.Document.getElementsByName("savetool")
If element.Type = "select-one" Then
Debug.print "List Box"
Else
Call element.Click
Debug.Print "Selecting Save Tool: " &
element.ID
Do While IEVNT.Busy: DoEvents: Loop
End If
Next element

"Joel" wrote:

There isn't enough information for me to repeat the problem. I don't know
how element is defined.

"Lalit Chaudhari" wrote:

Thanks for the reply. But i am not writing to anyfile. I am just automating
the web browser to do some steps. I am getting the error on the below first
line. Actually the following code is in the loop. When the item is checkbox
or radio-box its working but when it will be the Listbox, its giving the
error!

If element.Type = "select-one" Then
Debug.print "List Box"
Else
Call element.Click
Debug.Print "Selecting Save Tool: " & element.ID
Do While IEVNT.Busy: DoEvents: Loop
End If

"Joel" wrote:

I think they fixed a security problem with excel 2000 in excel 2003 which
performed an access test before creating a new file. Try manually creating
the file in the same directory by doing a saveas from the spreadhsheet. You
need to get the permission changed in the directory yoiu are writting to.

"Lalit Chaudhari" wrote:

Hi All,

I have developed a VBA program which will automatically make decisions on
the web page. It is working fine on Windows 2000. But its giving error as
"Permission Denied error 70" on Windows XP and 2003.

Can you please let me know if anybody knows the solution for this?


joel

Getting "Permission Denied error 70" on Windows XP and 2003
 
Sorry, I did on the previous posting

joel dot warburg at itt dot com

"Lalit Chaudhari" wrote:

Can you please let me know your mail id?

"Joel" wrote:

Send the file as an attahment using your e-mail tool. Don't use the
Dsicussion Group web tools.

"Lalit Chaudhari" wrote:

Hi,
But i am not understanding where i have written "LoadFileDate" function?
Also i am not able to find the option to send the file!
Again i am pasting my code:
For Each element In IEVNT.Document.getElementsByName("savetool")
If element.Type = "select-one" Then
Debug.print "List Box"
Else
Call element.Click
Debug.Print "Selecting Save Tool: " & element.ID
Do While IEVNT.Busy: DoEvents: Loop
End If
Next element

==================================================

"Joel" wrote:

You have a number of problems with the code

first your declaration LoadFileDate deson't match the call.

LoadFileDate(CBTfilesArray)

and

Function LoadFileDate()

I still don't have enough info to solve the problem. e-mail mye the file
and I will look at it

joel dot warburg at itt dot com

"Lalit Chaudhari" wrote:

Below is the code for your reference:

For Each element In IEVNT.Document.getElementsByName("savetool")
If element.Type = "select-one" Then
Debug.print "List Box"
Else
Call element.Click
Debug.Print "Selecting Save Tool: " &
element.ID
Do While IEVNT.Busy: DoEvents: Loop
End If
Next element

"Joel" wrote:

There isn't enough information for me to repeat the problem. I don't know
how element is defined.

"Lalit Chaudhari" wrote:

Thanks for the reply. But i am not writing to anyfile. I am just automating
the web browser to do some steps. I am getting the error on the below first
line. Actually the following code is in the loop. When the item is checkbox
or radio-box its working but when it will be the Listbox, its giving the
error!

If element.Type = "select-one" Then
Debug.print "List Box"
Else
Call element.Click
Debug.Print "Selecting Save Tool: " & element.ID
Do While IEVNT.Busy: DoEvents: Loop
End If

"Joel" wrote:

I think they fixed a security problem with excel 2000 in excel 2003 which
performed an access test before creating a new file. Try manually creating
the file in the same directory by doing a saveas from the spreadhsheet. You
need to get the permission changed in the directory yoiu are writting to.

"Lalit Chaudhari" wrote:

Hi All,

I have developed a VBA program which will automatically make decisions on
the web page. It is working fine on Windows 2000. But its giving error as
"Permission Denied error 70" on Windows XP and 2003.

Can you please let me know if anybody knows the solution for this?



All times are GMT +1. The time now is 10:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com