| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Color Changes When Saving 2007 Workbook as 97 - 2003 Workbook | Excel Discussion (Misc queries) | |||
| Manipulating data from a portal (web) | Excel Programming | |||
| Saving a sheet in a workbook as .csv but not changing workbook name | Excel Programming | |||
| Help in calling excel files under portal | Excel Programming | |||
| Saving a Workbook: Forcing User to Rename before Saving | Excel Programming | |||
Linear Mode
