previously working VBA app has lost controls & doesn't compile basic statements

Article View: microsoft.public.vb.installation

Article #4

Back to microsoft.public.vb.installation Previous Next

From: Muehlmann Martin
Date: Thu, 25 Oct 2001 15:31

33 lines
2932 bytes

Hi!

I've programmed a little VBA app hosted in Excel (Win2k prof+SP2, Office
2k Prof, VS6 + VS6SP5). Recently I changed to a different machine (Win2k
prof + SP2, Office 2k Prof ) and half of my controls like progress bars
and slider controls on all forms disappeared. Furthermore, I got some
weird errors because it doesn't compile fundamental statements like
Chr(13) (=carriage return). When I open a new Excel document and write a
small test macro using the Chr(13) command everything is fine....

sub testchr()
    dim str as string

    str = "Hello" & Chr(13) & "Martin"
    msgbox str
   ' and a message with a line break between Hello and Martin appears.
end sub

If I press F1 with Chr highlighted in my project I don't get any useful
help information, but - another time - I get the apropiate help
information when I do the same within this little test sub.

There must be something wrong with my new machine because I'm sure that
my software product is functional (on another Win95 machine it's
functional, too). Is it necessary to install any further software like
Visual Studio, Visual Basic, MSDN, or whatever (the other machines have
it all)?

Anybody out there who has experienced something similar? Any
recommendations are highly appreciated!!

Thanx,
martin

Technical Details

Message-ID: <3BD83060.25E79D3E@sbox.tu-graz.ac.at>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!news.tele.dk!small.news.tele.dk!193.190.198.17!newsfeeds.belnet.be!news.belnet.be!newscore.univie.ac.at!aconews-feed.univie.ac.at!news.tu-graz.ac.at!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fde1d,9814d4eff553617,start
X-Google-Attributes: gidfde1d,public
X-Google-Thread: 10229f,9814d4eff553617,start
X-Google-Attributes: gid10229f,public
X-Google-Thread: 10b213,9814d4eff553617,start
X-Google-Attributes: gid10b213,public
X-Google-Thread: 1136b3,9814d4eff553617,start
X-Google-Attributes: gid1136b3,public
X-Google-Thread: 11493c,9814d4eff553617,start
X-Google-Attributes: gid11493c,public
X-Google-ArrivalTime: 2001-10-25 08:46:34 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!news.tele.dk!small.news.tele.dk!193.190.198.17!newsfeeds.belnet.be!news.belnet.be!newscore.univie.ac.at!aconews-feed.univie.ac.at!news.tu-graz.ac.at!not-for-mail
From: Muehlmann Martin <myhle@sbox.tu-graz.ac.at>
Newsgroups: microsoft.public.vb.installation,microsoft.public.vb.general.discussion,microsoft.public.vb.controls,microsoft.public.de.vb,basicworld.public.vb.allgemein
Subject: previously working VBA app has lost controls & doesn't compile basic 
 statements
Date: Thu, 25 Oct 2001 17:31:44 +0200
Organization: Technische Universitaet Graz
Lines: 37
Message-ID: <3BD83060.25E79D3E@sbox.tu-graz.ac.at>
Reply-To: myhle@sbox.tu-graz.ac.at
NNTP-Posting-Host: subzk012.tu-graz.ac.at
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: fstgss02.tu-graz.ac.at 1004023903 11631 129.27.42.12 (25 Oct 2001 15:31:43 GMT)
X-Complaints-To: news@zid.tu-graz.ac.at
NNTP-Posting-Date: 25 Oct 2001 15:31:43 GMT
X-Mailer: Mozilla 4.61 [en] (WinNT; I)
X-Accept-Language: de,en