Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
annoying pop up windows
i am dealing with large number of files, basically, open the file, collect
some fields, then close it. this process should go unattented, however, some of the files is causing trouble for me: 1. the file has some links and always pop up a window asking me to 'continue' or 'update'. this causes my process to stop till i click on ' continue'. how can i programmingly do this? i use C# and this happens right after i call workbook.open(). thanks. -- epr |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
annoying pop up windows
One of the optional prameteres of the Open method is UpdateLinks:=True /
False. if you specify this parameter then the question will not be asked... -- HTH... Jim Thomlinson "epr" wrote: i am dealing with large number of files, basically, open the file, collect some fields, then close it. this process should go unattented, however, some of the files is causing trouble for me: 1. the file has some links and always pop up a window asking me to 'continue' or 'update'. this causes my process to stop till i click on ' continue'. how can i programmingly do this? i use C# and this happens right after i call workbook.open(). thanks. -- epr |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
annoying pop up windows
thank you Jim.
but i had everything set to false. also, how do bypass ones that has password protection? there was a very small amount of files and i don't have the real pwd, so i want to just click 'cancel' and move on. -- epr "Jim Thomlinson" wrote: One of the optional prameteres of the Open method is UpdateLinks:=True / False. if you specify this parameter then the question will not be asked... -- HTH... Jim Thomlinson "epr" wrote: i am dealing with large number of files, basically, open the file, collect some fields, then close it. this process should go unattented, however, some of the files is causing trouble for me: 1. the file has some links and always pop up a window asking me to 'continue' or 'update'. this causes my process to stop till i click on ' continue'. how can i programmingly do this? i use C# and this happens right after i call workbook.open(). thanks. -- epr |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
annoying pop up windows
You can try opening it with a dummy password and use that error to
tell your code to skip the file and continue: Sub way() On Error GoTo errHandler Workbooks.Open fileName:="C:\somefile.xls", Password:="pw" Exit Sub errHandler: If Left(Err.Description, 12) = "The password" Then Resume Next Else MsgBox Err.Description End If End Sub Cliff Edwards |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
annoying pop up windows
very cool. both worked.
thanks guys. -- epr "ward376" wrote: You can try opening it with a dummy password and use that error to tell your code to skip the file and continue: Sub way() On Error GoTo errHandler Workbooks.Open fileName:="C:\somefile.xls", Password:="pw" Exit Sub errHandler: If Left(Err.Description, 12) = "The password" Then Resume Next Else MsgBox Err.Description End If End Sub Cliff Edwards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cannot open exel from windows xp in windows vista and visa versa | New Users to Excel | |||
can windows vista edit shared document from windows xp | Excel Worksheet Functions | |||
Embedded status lines should eliminate annoying popup "OK"windows | Setting up and Configuration of Excel | |||
Annoying pop up | Excel Discussion (Misc queries) | |||
Annoying bug. | Excel Programming |