Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 295
Default Following yesterday's discussion of Excel 2003 v 2007

Thankyou all for your responses. The general opinion seems to be that 2007
just isn't worth it, and I'm happy to stay with 2003.

However, I will still have the crashing problem which occurs at least twice
per week, and sometimes several times in a day (like yesterday, which is why
it took me a while to respond to you all - I'm surprised you didn't hear me,
wherever you are on the planet).

I note that there are some upgrades for Ex 2003 available, but I've always
been loath to do an upgrade for fear of it screwing me completely, and
costing me days and days or repair work. My Ex 2003 is "as delivered" in
2003. How easy/safe is it to put through some upgrades please? Or should I
perhaps just repurchase Ex 2003 and install that (presuming that any current
release would have all the upgrades in it)? Regards, Brett.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,582
Default Following yesterday's discussion of Excel 2003 v 2007

(presuming that any current release would have all the upgrades in it)

Nope, a new version of Excel 2003, if you can still find it, is the virgin
version. After installation, it asks if you want to troll the internet for
updates.

Excel 2003 SP2 was pretty stable. SP3 is also stable, but somewhere in there
Microsoft changed the RefEdit control, and a lot of my clients have problems
with dialogs that have refedits. The error message is nice: Unspecified
Error, followed by Out Of Memory, and everyone probably recognizes the error
number by now: 80004005.

I guess I'm advising you to stick with what you have. Shut down Excel, clean
out the temp directory, and also "C:\Documents and
Settings\UserName\Application Data\Microsoft\Forms\". then start up again
and see if that's any better.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
774-275-0064
208-485-0691 fax

http://PeltierTech.com/
_______


"Brettjg" wrote in message
...
Thankyou all for your responses. The general opinion seems to be that 2007
just isn't worth it, and I'm happy to stay with 2003.

However, I will still have the crashing problem which occurs at least
twice
per week, and sometimes several times in a day (like yesterday, which is
why
it took me a while to respond to you all - I'm surprised you didn't hear
me,
wherever you are on the planet).

I note that there are some upgrades for Ex 2003 available, but I've always
been loath to do an upgrade for fear of it screwing me completely, and
costing me days and days or repair work. My Ex 2003 is "as delivered" in
2003. How easy/safe is it to put through some upgrades please? Or should I
perhaps just repurchase Ex 2003 and install that (presuming that any
current
release would have all the upgrades in it)? Regards, Brett.



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 295
Default Following yesterday's discussion of Excel 2003 v 2007

Hi Jon, thanks for your response. There was nothing in "Forms". Is this where
the recovered documents ar stored? Not sure where to find the temp directory.
Brett
"Jon Peltier" wrote:

(presuming that any current release would have all the upgrades in it)


Nope, a new version of Excel 2003, if you can still find it, is the virgin
version. After installation, it asks if you want to troll the internet for
updates.

Excel 2003 SP2 was pretty stable. SP3 is also stable, but somewhere in there
Microsoft changed the RefEdit control, and a lot of my clients have problems
with dialogs that have refedits. The error message is nice: Unspecified
Error, followed by Out Of Memory, and everyone probably recognizes the error
number by now: 80004005.

I guess I'm advising you to stick with what you have. Shut down Excel, clean
out the temp directory, and also "C:\Documents and
Settings\UserName\Application Data\Microsoft\Forms\". then start up again
and see if that's any better.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
774-275-0064
208-485-0691 fax

http://PeltierTech.com/
_______


"Brettjg" wrote in message
...
Thankyou all for your responses. The general opinion seems to be that 2007
just isn't worth it, and I'm happy to stay with 2003.

However, I will still have the crashing problem which occurs at least
twice
per week, and sometimes several times in a day (like yesterday, which is
why
it took me a while to respond to you all - I'm surprised you didn't hear
me,
wherever you are on the planet).

I note that there are some upgrades for Ex 2003 available, but I've always
been loath to do an upgrade for fear of it screwing me completely, and
costing me days and days or repair work. My Ex 2003 is "as delivered" in
2003. How easy/safe is it to put through some upgrades please? Or should I
perhaps just repurchase Ex 2003 and install that (presuming that any
current
release would have all the upgrades in it)? Regards, Brett.




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,582
Default Following yesterday's discussion of Excel 2003 v 2007

A quick way to find the temp directory is to hold the Windows button and
click R (or go to the Start menu and select Run), Enter %temp% in the box,
and press Enter. It's located at "C:\Documents and Settings\UserName\Local
Settings\Temp".

Various programs stick various working files in these directories, and if
they don't get rid of them properly, there may be problems. The Forms
directory is where temporary instances of, I guess, the libraries of the
RefEdits and other objects are kept.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Brettjg" wrote in message
...
Hi Jon, thanks for your response. There was nothing in "Forms". Is this
where
the recovered documents ar stored? Not sure where to find the temp
directory.
Brett
"Jon Peltier" wrote:

(presuming that any current release would have all the upgrades in it)


Nope, a new version of Excel 2003, if you can still find it, is the
virgin
version. After installation, it asks if you want to troll the internet
for
updates.

Excel 2003 SP2 was pretty stable. SP3 is also stable, but somewhere in
there
Microsoft changed the RefEdit control, and a lot of my clients have
problems
with dialogs that have refedits. The error message is nice: Unspecified
Error, followed by Out Of Memory, and everyone probably recognizes the
error
number by now: 80004005.

I guess I'm advising you to stick with what you have. Shut down Excel,
clean
out the temp directory, and also "C:\Documents and
Settings\UserName\Application Data\Microsoft\Forms\". then start up again
and see if that's any better.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
774-275-0064
208-485-0691 fax

http://PeltierTech.com/
_______


"Brettjg" wrote in message
...
Thankyou all for your responses. The general opinion seems to be that
2007
just isn't worth it, and I'm happy to stay with 2003.

However, I will still have the crashing problem which occurs at least
twice
per week, and sometimes several times in a day (like yesterday, which
is
why
it took me a while to respond to you all - I'm surprised you didn't
hear
me,
wherever you are on the planet).

I note that there are some upgrades for Ex 2003 available, but I've
always
been loath to do an upgrade for fear of it screwing me completely, and
costing me days and days or repair work. My Ex 2003 is "as delivered"
in
2003. How easy/safe is it to put through some upgrades please? Or
should I
perhaps just repurchase Ex 2003 and install that (presuming that any
current
release would have all the upgrades in it)? Regards, Brett.






  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 295
Default Following yesterday's discussion of Excel 2003 v 2007

WOW! there's 586mb of stuff in there, and given that thy're all temps I guess
I can delete the lot eh? Sorry about my nervousness, but I've had far too man
problems with this machine to just jump in. Regards, Brett

"Jon Peltier" wrote:

A quick way to find the temp directory is to hold the Windows button and
click R (or go to the Start menu and select Run), Enter %temp% in the box,
and press Enter. It's located at "C:\Documents and Settings\UserName\Local
Settings\Temp".

Various programs stick various working files in these directories, and if
they don't get rid of them properly, there may be problems. The Forms
directory is where temporary instances of, I guess, the libraries of the
RefEdits and other objects are kept.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Brettjg" wrote in message
...
Hi Jon, thanks for your response. There was nothing in "Forms". Is this
where
the recovered documents ar stored? Not sure where to find the temp
directory.
Brett
"Jon Peltier" wrote:

(presuming that any current release would have all the upgrades in it)

Nope, a new version of Excel 2003, if you can still find it, is the
virgin
version. After installation, it asks if you want to troll the internet
for
updates.

Excel 2003 SP2 was pretty stable. SP3 is also stable, but somewhere in
there
Microsoft changed the RefEdit control, and a lot of my clients have
problems
with dialogs that have refedits. The error message is nice: Unspecified
Error, followed by Out Of Memory, and everyone probably recognizes the
error
number by now: 80004005.

I guess I'm advising you to stick with what you have. Shut down Excel,
clean
out the temp directory, and also "C:\Documents and
Settings\UserName\Application Data\Microsoft\Forms\". then start up again
and see if that's any better.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
774-275-0064
208-485-0691 fax

http://PeltierTech.com/
_______


"Brettjg" wrote in message
...
Thankyou all for your responses. The general opinion seems to be that
2007
just isn't worth it, and I'm happy to stay with 2003.

However, I will still have the crashing problem which occurs at least
twice
per week, and sometimes several times in a day (like yesterday, which
is
why
it took me a while to respond to you all - I'm surprised you didn't
hear
me,
wherever you are on the planet).

I note that there are some upgrades for Ex 2003 available, but I've
always
been loath to do an upgrade for fear of it screwing me completely, and
costing me days and days or repair work. My Ex 2003 is "as delivered"
in
2003. How easy/safe is it to put through some upgrades please? Or
should I
perhaps just repurchase Ex 2003 and install that (presuming that any
current
release would have all the upgrades in it)? Regards, Brett.








  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,549
Default Following yesterday's discussion of Excel 2003 v 2007

Yes, delete those .tmp files, I clean out the "%temp%" folder each
night before shutting down.
The other thing you can do, is to clean the code modules.
That will take a little longer...
Copy the code from each module out to Notepad or an equivalent.
If desired, export the existing modules to some folder.
Delete the modules.
Add new modules and paste the code from Notepad back into the
new modules. (compile and save)
Besides reducing/eliminating corruption in the modules, this
procedure can reduce the size of the modules.

You may get some advice to download and use a code cleaner
add-in. There seem to be many people satisfied with it, but I
have only generated crashes using it. It does essentially what I
described above.
--
Jim Cone
Portland, Oregon USA



"Brettjg"

wrote in message
WOW! there's 586mb of stuff in there, and given that thy're all temps I guess
I can delete the lot eh? Sorry about my nervousness, but I've had far too man
problems with this machine to just jump in. Regards, Brett


"Jon Peltier" wrote:
A quick way to find the temp directory is to hold the Windows button and
click R (or go to the Start menu and select Run), Enter %temp% in the box,
and press Enter. It's located at "C:\Documents and Settings\UserName\Local
Settings\Temp".

Various programs stick various working files in these directories, and if
they don't get rid of them properly, there may be problems. The Forms
directory is where temporary instances of, I guess, the libraries of the
RefEdits and other objects are kept.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 versus Excel 2003 & Excel 97-2003 fully compatible Bumpersnesty Excel Worksheet Functions 0 April 26th 10 09:44 PM
Excel opens two windows (2007 & 2003 format): I want only 2003. Rob Excel Discussion (Misc queries) 0 March 6th 10 07:46 PM
Excel 2007, I write macros in 2003 is 2007 similar for VBA? Pros andcons please Simon[_2_] Excel Programming 3 August 5th 08 03:48 PM
How to instantiate Excel 2003 when both 2003 and 2007 are installe Raghu Excel Programming 2 December 19th 07 04:21 PM
Excel: Filling a user form with yesterday's data randallwilkins Excel Programming 2 June 3rd 06 04:09 AM


All times are GMT +1. The time now is 07:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"