S
sxhwabbiemike
I have a macro that is automatically run unattended which is attempting to
save the workbook to an iKnow portal where documents are required to be
"checded in and out".
Is there a function or a coding technique that will allow the macro to avoid
the "check in" prompt or respond to it programmatically rather than having
the popup appear and require me to manually respond.
iknowlib = "https://iknow.schwab.com/g481/g218/g142/g117/g113/Generated
Documents/Audit Reporting/"
dsn = "MainFrame eChange Tickets Audit Report.xls"
iknow = iknowlib & dsn
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:= _
locl, FileFormat:=xlNormal, Password:="", WriteResPassword:="",
ReadOnlyRecommended:= _
False, CreateBackup:=False
ActiveWorkbook.SaveAs Filename:= _
iknow, FileFormat:=xlNormal, Password:="", WriteResPassword:="",
ReadOnlyRecommended:= _
False, CreateBackup:=False
Application.DisplayAlerts = True
save the workbook to an iKnow portal where documents are required to be
"checded in and out".
Is there a function or a coding technique that will allow the macro to avoid
the "check in" prompt or respond to it programmatically rather than having
the popup appear and require me to manually respond.
iknowlib = "https://iknow.schwab.com/g481/g218/g142/g117/g113/Generated
Documents/Audit Reporting/"
dsn = "MainFrame eChange Tickets Audit Report.xls"
iknow = iknowlib & dsn
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:= _
locl, FileFormat:=xlNormal, Password:="", WriteResPassword:="",
ReadOnlyRecommended:= _
False, CreateBackup:=False
ActiveWorkbook.SaveAs Filename:= _
iknow, FileFormat:=xlNormal, Password:="", WriteResPassword:="",
ReadOnlyRecommended:= _
False, CreateBackup:=False
Application.DisplayAlerts = True