excel - Lock a folder but access its files from VBA in windows 7 -
i have created excel tool runs program files saved in particular folder. need protect folder , still able access these files while vba program running. how accomplish it?
if you're trying access excel files in folder, instead of locking folder, can lock of excel files , open them using workbook.open
method documented here allows pass password argument.
Comments
Post a Comment