workbook hidden? is it in list after Unhide used on View tab Window section
in excel 2007?


"Stephen Plotnick" wrote in message
...
|I do use the file format for the saveas to go back to Excel 2003.
|
| I have the same issues reading that file afterwards as I do with the
| original one.
|
| Thanks,
| Steve
|
|
| "Barb Reinhardt" wrote in
message
| ...
| I've run into issues in Excel 2007 if I don't include the FileFormat
| specification in the VB code t save. Might that be your problem?
|
| HTH,
| Barb Reinhardt
|
| "Stephen Plotnick" wrote:
|
| Background.
|
| I've written many programs in VB2008 creating and reading excel
| spreadsheets
| (office 2007)
| All program written before were using "Console Application"
|
| My problem.
| Program written as Windows Form
| Open spreadsheet and populate fields in a form
| User can change values in form
| Save those values back into same cells in spreadsheet
| Save spreadsheet
|
| I get the values into the form
| I execute the save command with the new values
| I can rerun vb program and get the new values without any problems
|
|
| My problem.
| If I open the saved spreadsheet in Excel I do not see anything not even
| the
| name shows up on the title bar. It is as if Excel never opens up the
| spreadsheet. The file size is the same as before manipulating the data
| and
| like I said I can rerun my VB program and get the fields without any
| issues.
|
| I also tried doing a saveas to another spreadsheet and have the same
| issue
| opening it up.
|
| I also tried converting from 2007 to 2003 format both for input and
| output
| with the same issues.
|
| Thanks in advance,
| Steve
|
|
|
|