| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel using VB - save problem
Thanks,
That did the trick. Steve "Homey" <none wrote in message ... Workbooks("Workbookname.xls").Windows(1).visible=t rue or WB.Windows(1).visible=true if you have WB set to the workbook. "Stephen Plotnick" wrote in message ... | Boy are you smart. That did the trick from within Excel. | | Is there a way for me to make that happen within my VB program before I save | the spreadsheet so that I can just call it up in Excel. | | Thanks for the great help, | Steve | "Homey" <none wrote in message | ... | 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 | | | | | | | | | | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| file save problem in excel | Excel Discussion (Misc queries) | |||
| Excel Save-AS Problem | Excel Discussion (Misc queries) | |||
| Excel save as problem | Excel Discussion (Misc queries) | |||
| Problem using save as in Excel | Excel Discussion (Misc queries) | |||
| Excel - Web Save Problem | Excel Programming | |||
![Stephen Plotnick[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
