ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i open file for input (https://www.excelbanter.com/excel-discussion-misc-queries/168143-how-do-i-open-file-input.html)

JAC

how do i open file for input
 
getting runtime error 70 help tells me to open file for input can't figure
out how to do this

JLatham

how do i open file for input
 
Error 70 is a permissions error. If your error message indicates otherwise,
let us know. But this sounds like you do not have permission to open the
file for some reason. Either you don't have permission to the folder the
file is located in, or (if you're trying to open it in code) you haven't
provided the password needed to open the file within the code statement
opening the file.

"Jac" wrote:

getting runtime error 70 help tells me to open file for input can't figure
out how to do this


JAC

how do i open file for input
 
I am the adminon this computer. It says to change the write protection or
open as input file. do not find how to do either

"JLatham" wrote:

Error 70 is a permissions error. If your error message indicates otherwise,
let us know. But this sounds like you do not have permission to open the
file for some reason. Either you don't have permission to the folder the
file is located in, or (if you're trying to open it in code) you haven't
provided the password needed to open the file within the code statement
opening the file.

"Jac" wrote:

getting runtime error 70 help tells me to open file for input can't figure
out how to do this


JLatham

how do i open file for input
 
Go into Windows Explorer and find the file, right-click on it and choose
Properties and see what that tells you. It may be marked as Read Only,
although usually if that's the case you can open it, just have to save it
with a different name to save changes made to it.


"Jac" wrote:

I am the adminon this computer. It says to change the write protection or
open as input file. do not find how to do either

"JLatham" wrote:

Error 70 is a permissions error. If your error message indicates otherwise,
let us know. But this sounds like you do not have permission to open the
file for some reason. Either you don't have permission to the folder the
file is located in, or (if you're trying to open it in code) you haven't
provided the password needed to open the file within the code statement
opening the file.

"Jac" wrote:

getting runtime error 70 help tells me to open file for input can't figure
out how to do this



All times are GMT +1. The time now is 02:22 PM.

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