|
Saving a workbook to an iKnow portal
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 |
Saving a workbook to an iKnow portal
I just realized my references to iKnow portal is really the SHAREPOINT product.
"sxhwabbiemike" wrote: 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 |
Saving a workbook to an Sharepoint portal
"sxhwabbiemike" wrote: I just realized my references to iKnow portal is really the SHAREPOINT product. "sxhwabbiemike" wrote: 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 |
| All times are GMT +1. The time now is 07:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com