PDA

View Full Version : File Access



Rema
08-25-2008, 01:59 AM
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
08-25-2008, 03:35 AM
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 (http://www.ozgrid.com/forum/autolink.php?id=52&script=showthread&forumid=8)(FileFilter:="Excel Files (*.xls), *.xls", Title:="** File Name here **")

Rema
08-28-2008, 02:35 AM
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
08-28-2008, 02:43 AM
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.