Ive been trying to figure out for the past few days how to automatically update an excel workbook with data from other passworded workbooks. This is the closest i've been able to come by recording a macro. however, when i record the macro, it doesnt save the password inputs. I added the highlighted portion of code....but im getting a compile error. can someone please help me with this?


ActiveWorkbook.UpdateLink Name:= _
"\Maintenance 2005\Sudesh T..xls", Type:= _
xlExcelLinks, Password:="mih100", WriteResPassword:="mih100"