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

Popular posts from this blog

OpenCV OpenCL: Convert Mat to Bitmap in JNI Layer for Android -

android - org.xmlpull.v1.XmlPullParserException: expected: START_TAG {http://schemas.xmlsoap.org/soap/envelope/}Envelope -

python - How to remove the Xframe Options header in django? -