I have a workbook which is password protected to read only level. I would like to open and modify this book as part of routine.
Workbooks.Open filename:= _
"\\ih-fs\company\Equipment Despatches\Despatch Data Costs.xlsx", _
UpdateLinks:=0
is it possible to have VBA enter this password for me?
Workbooks.Open filename:= _
"\\ih-fs\company\Equipment Despatches\Despatch Data Costs.xlsx", _
UpdateLinks:=0
is it possible to have VBA enter this password for me?