hopelessliar
Technical User
I have a macro that looks like this:
Workbooks.Open FileName:= _
"C:\blah_blah.xls", _
UpdateLinks:=3
Application.Run "blah_blah.xls!DDSCPTUpload"
ActiveWorkbook.Save
ActiveWindow.Close
The application DDSCPTupload requires a password in order to connect to an external database and upload. Is there a way of including this in the code?? (the lack of security involved really doesn't matter)
Any help appreciated
Workbooks.Open FileName:= _
"C:\blah_blah.xls", _
UpdateLinks:=3
Application.Run "blah_blah.xls!DDSCPTUpload"
ActiveWorkbook.Save
ActiveWindow.Close
The application DDSCPTupload requires a password in order to connect to an external database and upload. Is there a way of including this in the code?? (the lack of security involved really doesn't matter)
Any help appreciated
