File Access

[Rema]

Hi all,

We do have a folder having user access restriction. Whether it is possible to read text file from the folder having access restriction through vba code.

Thank you in advance

Regards
Rema

[shamsam1]

Set sBook = Workbooks.Open (Foldername) (fName, , , , "xxxx") this might help you

or you may ask user to select particular file from network

you may try something like this
OpenMyFile = Application. GetOpenFilename(FileFilter:="Excel Files (*.xls), *.xls", Title:="** File Name here **")

[Rema]

Thank you for your reply.

I want to read data from text file in a folder which is permission denied.is there any way to access file having user access restriction

[Bob Phillips]

Surely, if permission is denied it is precisely intended to STOP YOU getting access. Speak to the folder owner and convince them that you need permission.