Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange problem saving add-in
Since upgrading to Excel 2003 I have an intermittent problem saving an
add-in. What happens is that the save doesn't finish and there is a continuous hard-disk activity. Eventually the error message appears file not saved. What is happening is that a very large file is being made in the same folder as the add-in. When this reaches a few Gb and the hard-disk is full the error message appears. This file can have different names. I have seen 9DA0C400 and 4976E400. I don't see a file extension. The add-in itself is big, about 1.5 mB, but this didn't cause any problem before. The add-in works fine. This is getting a major problem and I haven't found any information about this on the internet. Thanks for any advice or insight in this. RBS |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange problem saving add-in
2. Do you have any code in the ThisWorkBook code module that might run
on closing or saving ? 3. In the absence of another reply, it could be that, despite seeming to work OK, the file has become corrupted. I suggest you open a new workbook and "clean" your code by copying and pasting it into Notepad, then copying and pasting from there into a new code module. If your addin has worksheets in use, I would copy these across one by one and do a test save after each one. --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange problem saving add-in
2. There is no such code.
3. I regularly use Rob Bovey's Code Cleaner, which I understand does the same as you suggest. There is no worksheet in use either, so I don't think this helps much. I didn't have this problem at all with Excel 2002 and even the current add-in doesn't have this problem with Excel 2002. Surely somebody knows what might be going on here. Or not? RBS "BrianB" wrote in message ... 2. Do you have any code in the ThisWorkBook code module that might run on closing or saving ? 3. In the absence of another reply, it could be that, despite seeming to work OK, the file has become corrupted. I suggest you open a new workbook and "clean" your code by copying and pasting it into Notepad, then copying and pasting from there into a new code module. If your addin has worksheets in use, I would copy these across one by one and do a test save after each one. --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange problem saving add-in
I don't use xl2003, but when you save a file in excel, it actually saves to a
new name (those funny 8 character, no extension names). If all goes well, then excel deletes the original file and renames the funny one to the original's name. This didn't help with your problem, though. RB Smissaert wrote: Since upgrading to Excel 2003 I have an intermittent problem saving an add-in. What happens is that the save doesn't finish and there is a continuous hard-disk activity. Eventually the error message appears file not saved. What is happening is that a very large file is being made in the same folder as the add-in. When this reaches a few Gb and the hard-disk is full the error message appears. This file can have different names. I have seen 9DA0C400 and 4976E400. I don't see a file extension. The add-in itself is big, about 1.5 mB, but this didn't cause any problem before. The add-in works fine. This is getting a major problem and I haven't found any information about this on the internet. Thanks for any advice or insight in this. RBS -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange problem saving add-in
Thanks.
Didn't know that and that gives me a start at some insight in this problem. RBS "Dave Peterson" wrote in message ... I don't use xl2003, but when you save a file in excel, it actually saves to a new name (those funny 8 character, no extension names). If all goes well, then excel deletes the original file and renames the funny one to the original's name. This didn't help with your problem, though. RB Smissaert wrote: Since upgrading to Excel 2003 I have an intermittent problem saving an add-in. What happens is that the save doesn't finish and there is a continuous hard-disk activity. Eventually the error message appears file not saved. What is happening is that a very large file is being made in the same folder as the add-in. When this reaches a few Gb and the hard-disk is full the error message appears. This file can have different names. I have seen 9DA0C400 and 4976E400. I don't see a file extension. The add-in itself is big, about 1.5 mB, but this didn't cause any problem before. The add-in works fine. This is getting a major problem and I haven't found any information about this on the internet. Thanks for any advice or insight in this. RBS -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange problem saving add-in
Just one final note on this problem.
I discovered one golden rule he Never save more than once without using Rob Bovey's Code Cleaner. By sticking to that I have had no further problems. RBS "RB Smissaert" wrote in message ... Since upgrading to Excel 2003 I have an intermittent problem saving an add-in. What happens is that the save doesn't finish and there is a continuous hard-disk activity. Eventually the error message appears file not saved. What is happening is that a very large file is being made in the same folder as the add-in. When this reaches a few Gb and the hard-disk is full the error message appears. This file can have different names. I have seen 9DA0C400 and 4976E400. I don't see a file extension. The add-in itself is big, about 1.5 mB, but this didn't cause any problem before. The add-in works fine. This is getting a major problem and I haven't found any information about this on the internet. Thanks for any advice or insight in this. RBS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
strange problem | Excel Discussion (Misc queries) | |||
Strange Problem | Excel Discussion (Misc queries) | |||
Strange Problem... | Excel Discussion (Misc queries) | |||
strange error on saving | Excel Discussion (Misc queries) | |||
Strange problem | Excel Programming |