| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving file in VBE
Hello!
There is something strange going on... When in the VBE, if I edit the code in one of the workbook in my XLStart folder, the Save command doesn't work... I don't get any errors or messages, but if I then close Excel I get a prompt to save the file. I checked the file directly, and indeed, after the Save command, its timestamp does not change. So now when I make changes in these XLStart files, I have to exit Excel to make sure the changes are saved... Quite annoying... Anybody as a suggestion? Is this by 'design'? Thanks Bruno |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Saving file in VBE
Of course, it would help if I told you I'M using Excel 2002 SP3 on Windows
XP SP2... "Bruno G." wrote in message ... Hello! There is something strange going on... When in the VBE, if I edit the code in one of the workbook in my XLStart folder, the Save command doesn't work... I don't get any errors or messages, but if I then close Excel I get a prompt to save the file. I checked the file directly, and indeed, after the Save command, its timestamp does not change. So now when I make changes in these XLStart files, I have to exit Excel to make sure the changes are saved... Quite annoying... Anybody as a suggestion? Is this by 'design'? Thanks Bruno |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Saving file in VBE
I am not sure that checking directly is reliable. Excel works on a copy of
the file. I would make changes, save, then exit and choose not to save in response to the prompt. Then see if your changes were retained. -- Regards, Tmo Ogilvy "Bruno G." wrote in message ... Of course, it would help if I told you I'M using Excel 2002 SP3 on Windows XP SP2... "Bruno G." wrote in message ... Hello! There is something strange going on... When in the VBE, if I edit the code in one of the workbook in my XLStart folder, the Save command doesn't work... I don't get any errors or messages, but if I then close Excel I get a prompt to save the file. I checked the file directly, and indeed, after the Save command, its timestamp does not change. So now when I make changes in these XLStart files, I have to exit Excel to make sure the changes are saved... Quite annoying... Anybody as a suggestion? Is this by 'design'? Thanks Bruno |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Saving file in VBE
Thanks for the input... Hadn't thought of that...
But no luck, if I dismiss the prompt on closing, my changes are lost... Found it! The problem is caused by an add-in: AutoSafe by JKP Application Development Services (http://www.jkp-ads.com/Download.htm) - If I uncheck it from the Add-Ins dialog, the save command works instantly in VBE... Guess I'll drop him a line about it but I think he'll see this one... Bruno "Tom Ogilvy" wrote in message ... I am not sure that checking directly is reliable. Excel works on a copy of the file. I would make changes, save, then exit and choose not to save in response to the prompt. Then see if your changes were retained. -- Regards, Tmo Ogilvy "Bruno G." wrote in message ... Of course, it would help if I told you I'M using Excel 2002 SP3 on Windows XP SP2... "Bruno G." wrote in message ... Hello! There is something strange going on... When in the VBE, if I edit the code in one of the workbook in my XLStart folder, the Save command doesn't work... I don't get any errors or messages, but if I then close Excel I get a prompt to save the file. I checked the file directly, and indeed, after the Save command, its timestamp does not change. So now when I make changes in these XLStart files, I have to exit Excel to make sure the changes are saved... Quite annoying... Anybody as a suggestion? Is this by 'design'? Thanks Bruno |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Saving file in VBE
I would drop him a line to make sure. This sounds like a flaw he would be
most interested in fixing. -- Regards, Tom Ogilvy "Bruno G." wrote in message ... Thanks for the input... Hadn't thought of that... But no luck, if I dismiss the prompt on closing, my changes are lost... Found it! The problem is caused by an add-in: AutoSafe by JKP Application Development Services (http://www.jkp-ads.com/Download.htm) - If I uncheck it from the Add-Ins dialog, the save command works instantly in VBE... Guess I'll drop him a line about it but I think he'll see this one... Bruno "Tom Ogilvy" wrote in message ... I am not sure that checking directly is reliable. Excel works on a copy of the file. I would make changes, save, then exit and choose not to save in response to the prompt. Then see if your changes were retained. -- Regards, Tmo Ogilvy "Bruno G." wrote in message ... Of course, it would help if I told you I'M using Excel 2002 SP3 on Windows XP SP2... "Bruno G." wrote in message ... Hello! There is something strange going on... When in the VBE, if I edit the code in one of the workbook in my XLStart folder, the Save command doesn't work... I don't get any errors or messages, but if I then close Excel I get a prompt to save the file. I checked the file directly, and indeed, after the Save command, its timestamp does not change. So now when I make changes in these XLStart files, I have to exit Excel to make sure the changes are saved... Quite annoying... Anybody as a suggestion? Is this by 'design'? Thanks Bruno |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Saving file in VBE
According to M. Pietrse, it's "an unwanted sideeffect caused by a bug in the
VBE"... There is an easy way around it, though: Simply create a short sub in the workbook you want to save Sub SaveMe() ThisWorkbook.Save End Sub and call that to save the workbook. Thanks to both M. Pieterse and M. Ogilvy for your help! Bruno "Tom Ogilvy" wrote in message ... I would drop him a line to make sure. This sounds like a flaw he would be most interested in fixing. -- Regards, Tom Ogilvy "Bruno G." wrote in message ... Thanks for the input... Hadn't thought of that... But no luck, if I dismiss the prompt on closing, my changes are lost... Found it! The problem is caused by an add-in: AutoSafe by JKP Application Development Services (http://www.jkp-ads.com/Download.htm) - If I uncheck it from the Add-Ins dialog, the save command works instantly in VBE... Guess I'll drop him a line about it but I think he'll see this one... Bruno "Tom Ogilvy" wrote in message ... I am not sure that checking directly is reliable. Excel works on a copy of the file. I would make changes, save, then exit and choose not to save in response to the prompt. Then see if your changes were retained. -- Regards, Tmo Ogilvy "Bruno G." wrote in message ... Of course, it would help if I told you I'M using Excel 2002 SP3 on Windows XP SP2... "Bruno G." wrote in message ... Hello! There is something strange going on... When in the VBE, if I edit the code in one of the workbook in my XLStart folder, the Save command doesn't work... I don't get any errors or messages, but if I then close Excel I get a prompt to save the file. I checked the file directly, and indeed, after the Save command, its timestamp does not change. So now when I make changes in these XLStart files, I have to exit Excel to make sure the changes are saved... Quite annoying... Anybody as a suggestion? Is this by 'design'? Thanks Bruno |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving Excel 2007 file in 2003 creates very large file | Excel Discussion (Misc queries) | |||
| Saving worksheet in new file with date AND cell value as file name | Excel Discussion (Misc queries) | |||
| How do I stop Excel 2000 from saving file history from file that . | Excel Discussion (Misc queries) | |||
| saving an excel file as an ASCII text file without delimiters | Excel Programming | |||
| Saving a file(new) using the multiple cell contents as a file name | Excel Programming | |||
Hybrid Mode
