Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook.Open failure
I have a bunch of Excel files which I need to open and make some
formatting changes for printing. There are a handful for which the Open method is failing. The error info from the exception has proven to be useless. For most when I open the file by hand in Excel there are various dialogs that pop up. I figured this must be the reason. There is one dialog asking about whether or not to enable/disable macros. There is one suggesting I open read-only unless I need to make changes and lastly there are few that pop up a password box. The password ones are no problem. I understand the failure. But what about the others? I tried setting EnableEvents to false and DisplayAlerts to false but this did not make a difference. I am using the COM interface to Excel 2000. I have been able to translate most VB examples to my C++ but it is possible the DisplayAlerts is not quite correct. The DisplayAlerts property is an array of VARIANT_BOOL. The PutDisplayAlerts method takes a long lcid and a VARIANT_BOOL. I am guessing lcid is an index. Which indices should I set? Right now I am just guessing at 0. The GetDisplayAlerts just returns VARIANT_BOOL. Huh? Is there documentation on these methods anywhere? I am using C++ but I do have VS.NET so I should have access to VB for reference. VB is not an option for the application as this is only a part of a much larger C++ application. Basically what I want to do is open the file with no user interaction, select all rows/columns and call autofit, change all background to white text to black and that is it. I need as little user interaction as possible, like zero if possible. Any help appreciated TIA JO |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
how do i open a data workbook when i open a timesheet workbook | Excel Discussion (Misc queries) | |||
vlookup failure & ctrl-f failure? | Excel Discussion (Misc queries) | |||
failure to open up excel file | Excel Discussion (Misc queries) | |||
after a power failure I can't open the spreadsheet | Excel Discussion (Misc queries) |