Mmm, Not sure if this is a genuine web query question... I've got this excel file that sends a query to an IBM iSeries. I want to automate it but it asks for an authentication... Is there a way that i can put my username and password inside this macro so it logs in automatically?
VBA Code:
Sub UpdBtn_Update() 'Excel 2000/XP Dim StarQuery As Object On Error GoTo Excel97_flag Set StarQuery = Application.COMAddIns("SymtraxStarQuery.ExcelAddin").Object On Error GoTo 0 StarQuery.RunTable "\\iseries\STARQUERY\Queries\***.sqx"
Exit Sub Excel97_flag: 'Excel 97 Application.Run "SQRUNTABLE", "\\iseries\STARQUERY\Queries\***.sqx" End Sub
