Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.dotnet.languages.vb,microsoft.public.excel.programming
|
|||
|
|||
Process excel files, suppress alerts
Dear all,
I have a .NET app that processes some excel file and it was working in all scenarios. Recently however we received excel files from a new client which my application has been unable to process. The problem is that this file has external links and when you open the excel file, it prompts you to either update linked information or keep exisiting information. Since my application runs in a non UI mode, there is no way for me to respond to this request. I have tried suppressing these message boxes but have been unable to do so. I have tried the following to no avail oExcel.Visible = False oExcel.AlertBeforeOverwriting = False oExcel.DisplayAlerts = False I will be greatful for any pointers in this regard. Many thanks, -- Wazir |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Process excel files, suppress alerts
Wazir
Update links is an argument of the workbooks.open method. I generally open stuff without updating links and readonly: workbooks.open "wbname", false, true (if you are using vb.net you can use named arguments) You may want to turn macros off too (Only available in XP or better) Cheers Simon -----Original Message----- Dear all, I have a .NET app that processes some excel file and it was working in all scenarios. Recently however we received excel files from a new client which my application has been unable to process. The problem is that this file has external links and when you open the excel file, it prompts you to either update linked information or keep exisiting information. Since my application runs in a non UI mode, there is no way for me to respond to this request. I have tried suppressing these message boxes but have been unable to do so. I have tried the following to no avail oExcel.Visible = False oExcel.AlertBeforeOverwriting = False oExcel.DisplayAlerts = False I will be greatful for any pointers in this regard. Many thanks, -- Wazir . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Process excel files, suppress alerts
Many thanks Simon. I set the UpdateLinks property to false and it worked
without any problem. Kind regards -- Wazir "Simon Murphy" wrote in message ... Wazir Update links is an argument of the workbooks.open method. I generally open stuff without updating links and readonly: workbooks.open "wbname", false, true (if you are using vb.net you can use named arguments) You may want to turn macros off too (Only available in XP or better) Cheers Simon -----Original Message----- Dear all, I have a .NET app that processes some excel file and it was working in all scenarios. Recently however we received excel files from a new client which my application has been unable to process. The problem is that this file has external links and when you open the excel file, it prompts you to either update linked information or keep exisiting information. Since my application runs in a non UI mode, there is no way for me to respond to this request. I have tried suppressing these message boxes but have been unable to do so. I have tried the following to no avail oExcel.Visible = False oExcel.AlertBeforeOverwriting = False oExcel.DisplayAlerts = False I will be greatful for any pointers in this regard. Many thanks, -- Wazir . |
#4
Posted to microsoft.public.dotnet.languages.vb,microsoft.public.excel.programming
|
|||
|
|||
Process excel files, suppress alerts
Recently however we received excel files from a new client which my
application has been unable to process. The problem is that this file has external links and when you open the excel file, it prompts you to either update linked information or keep exisiting information. Try xlsdoc.Application.DisplayAlerts = False to address the sheet within the application. |
#5
Posted to microsoft.public.dotnet.languages.vb,microsoft.public.excel.programming
|
|||
|
|||
Process excel files, suppress alerts
Recently however we received excel files from a new client which my
application has been unable to process. The problem is that this file has external links and when you open the excel file, it prompts you to either update linked information or keep exisiting information. Please send a sample of this file I can work with to |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic alerts in excel | Excel Discussion (Misc queries) | |||
How Excel VBA corporate with MSN Alerts? | Excel Discussion (Misc queries) | |||
Settings for pop up alerts in excel | Excel Discussion (Misc queries) | |||
how do i set up sound alerts on excel? | Excel Discussion (Misc queries) | |||
Suppress protection alerts in Excel | Excel Discussion (Misc queries) |