Saving a workbook to an iKnow portal

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
 
S

sxhwabbiemike

I just realized my references to iKnow portal is really the SHAREPOINT product.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top