Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 130
Default VBAProject Browser showing the same file multiple times

WINXP, SP2
XLXP, SP3

Has anyone else seen a certain file shown in the VBAProject Browser multiple
times or even files that's currently not open as showing in the VBAProject
Browser?

If so, what is the resolution to resolve this sort of issue cause I don't
like the looks of this behavior, and suspect this is what's eating up my RAM
usage. I have only started noticing this behavior when I started using
range names (User Defined Names), but yet, I like to use range names to
prevent other types of issues that's caused when changes are taking place.

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,582
Default VBAProject Browser showing the same file multiple times

A year or two ago, this was attributed to the Google desktop search utility,
but I understand that they've fixed that.

More recently I've had the problem on my computer after installing VSTO/.Net
add-ins. Apparently if resources aren't properly accounted for (please don't
ask me the details!), you get VBProjects that don't close. These VBProjects
that remain open are unrelated to the faulty add-ins. The developers of the
add-ins I had problems with have supposedly fixed this problem, so it can be
fixed.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Ronald Dodge" wrote in message
...
WINXP, SP2
XLXP, SP3

Has anyone else seen a certain file shown in the VBAProject Browser
multiple times or even files that's currently not open as showing in the
VBAProject Browser?

If so, what is the resolution to resolve this sort of issue cause I don't
like the looks of this behavior, and suspect this is what's eating up my
RAM usage. I have only started noticing this behavior when I started
using range names (User Defined Names), but yet, I like to use range names
to prevent other types of issues that's caused when changes are taking
place.

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 130
Default VBAProject Browser showing the same file multiple times

Thank you for the update. My system was reimaged almost 2 months ago and it
went from Windows 2000 to Windows XP, which I wasn't having any major
problems using Windows 2000 Pro, but did run into various issues using
Windows XP Pro. The only reason why my system was reimaged, when I ran the
AI Daylight savings patch on the system, it caused the system to go into a
constant rebooting cycle. The mistake was the IT person that created the AI
file didn't notify anyone that it was only to be used on WinXP, and I got
hit by that fact. I lost a lot of settings and other things. I'm still
having to put things back onto my system cause of that complete restore
process, though going from W2K Pro to WXP Pro.

That took place as I was going from auditing my production reporting system
cause of the various changes that took place to the point that it caused my
numbers to go out of alignment to the point of putting in various things to
minimize that impact and along the way, that's when I ran into this issue.

I shall update further on this issue to give an indication of what needed to
be done to prevent this sort of behaviour in the future. Of course, that
also means I have to find a consistent pattern to this issue too. The main
reason why I got into this line of work is cause I didn't want to do data
entry for a living, especially given the CTS issue that I had when I worked
at the IRS and the IRS breaking their own manual's policy on how to
administer breaks for those in the data transcribing department. While
90%-95% of what I learned is self taught, it's what allowed me to advance as
much as I have, which avoiding that constant data entry by programming as
much of that data entry as possible to be done automatically and/or with
checks in place, it's served up a lot of benefits along the way (saving
money, reducing human errors, reducing the health risk of getting CTS,
increased accuracy, and reports on a more timely basis as the main benefits)

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000

"Jon Peltier" wrote in message
...
A year or two ago, this was attributed to the Google desktop search
utility, but I understand that they've fixed that.

More recently I've had the problem on my computer after installing
VSTO/.Net add-ins. Apparently if resources aren't properly accounted for
(please don't ask me the details!), you get VBProjects that don't close.
These VBProjects that remain open are unrelated to the faulty add-ins. The
developers of the add-ins I had problems with have supposedly fixed this
problem, so it can be fixed.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Ronald Dodge" wrote in message
...
WINXP, SP2
XLXP, SP3

Has anyone else seen a certain file shown in the VBAProject Browser
multiple times or even files that's currently not open as showing in the
VBAProject Browser?

If so, what is the resolution to resolve this sort of issue cause I don't
like the looks of this behavior, and suspect this is what's eating up my
RAM usage. I have only started noticing this behavior when I started
using range names (User Defined Names), but yet, I like to use range
names to prevent other types of issues that's caused when changes are
taking place.

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000





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
opening file multiple times AD Excel Discussion (Misc queries) 0 May 13th 09 07:55 PM
Saving to a file multiple times NickB Excel Discussion (Misc queries) 2 January 24th 07 03:57 AM
VBAProject remains open after file is closed sequoia sam Excel Discussion (Misc queries) 4 August 2nd 05 07:59 PM
showing the # of times an item is entered in a column Foreplay_Man Excel Worksheet Functions 3 November 10th 04 04:28 PM
VBAProject unclosed even excel file was closed steven[_2_] Excel Programming 1 October 11th 03 05:57 PM


All times are GMT +1. The time now is 02:54 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"