Article View: microsoft.public.vb.installation
Article #1Re: previously working VBA app has lost controls & doesn't compile basic statements
From: Muehlmann Martin
Date: Mon, 29 Oct 2001 13:34
Date: Mon, 29 Oct 2001 13:34
80 lines
4991 bytes
4991 bytes
Stefan Berglund wrote:
> It sounds like you neglected to create an install package and instead just
> copied your .exe to another computer or the other computer doesn't have
> Office 2K installed.
Your are rigth that I didn't create an install package. Since I used VB for
Applications (VBA) I'm not even sure that it is possible to create such
packages. But I'm quite sure that it is impossible to compile VBA projects
because they are hosted in Excel (in my case). Therefore, I don't have any
executable files but a .xls document (with embedded macros).
By the way, I have a full installation of Office 2k professional on all
machines (in Office 97 I have the same problems, though!). I doubt that this
is reason for that problem...
Other suggestions?
best wishes,
martin
>
> "Muehlmann Martin" <myhle@sbox.tu-graz.ac.at> wrote in message
> news:3BD83060.25E79D3E@sbox.tu-graz.ac.at...
> > 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
> >
> >
> >
> >
--
---------------------------------------------------------------------------
Attention! Achtung! !OJO! MENTION YOUR NICKNAME Attention! Achtung! !OJO!
when sending a SMS
---------------------------------------------------------------------------
***************************************************************************
!Please, reply always your e-mails to the following address!
Martin E. MUEHLMANN alias myhle@sbox.tu-graz.ac.at
Technische Universitaet Graz AUSTRIA Graz University of Technology
---------------------------------------------------------------------------
Universidad Polit�cnica de Madrid SPAIN Polytechnic University of Madrid
Escuela T�nica Superior de Ingenieros Industriales (E.T.S.I.I.)
***************************************************************************
---------------------------------------------------------------------------
Technical Details
Message-ID:
<3BDD5AF6.167AFA7B@sbox.tu-graz.ac.at>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!newscore.univie.ac.at!aconews-feed.univie.ac.at!news.tu-graz.ac.at!not-for-mailReferences:
<3BD83060.25E79D3E@sbox.tu-graz.ac.at> <eZQNbObXBHA.1480@tkmsftngp03>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 10229f,9814d4eff553617 X-Google-Attributes: gid10229f,public X-Google-Thread: 10b213,9814d4eff553617 X-Google-Attributes: gid10b213,public X-Google-Thread: 1136b3,9814d4eff553617 X-Google-Attributes: gid1136b3,public X-Google-Thread: 11493c,9814d4eff553617 X-Google-Attributes: gid11493c,public X-Google-Thread: fde1d,9814d4eff553617 X-Google-Attributes: gidfde1d,public X-Google-ArrivalTime: 2001-10-29 05:45:35 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!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: Re: previously working VBA app has lost controls & doesn't compile basic statements Date: Mon, 29 Oct 2001 14:34:46 +0100 Organization: Technische Universitaet Graz Lines: 82 Message-ID: <3BDD5AF6.167AFA7B@sbox.tu-graz.ac.at> References: <3BD83060.25E79D3E@sbox.tu-graz.ac.at> <eZQNbObXBHA.1480@tkmsftngp03> Reply-To: myhle@sbox.tu-graz.ac.at NNTP-Posting-Host: subzr017.tu-graz.ac.at Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Trace: fstgss02.tu-graz.ac.at 1004362486 12129 129.27.43.17 (29 Oct 2001 13:34:46 GMT) X-Complaints-To: news@zid.tu-graz.ac.at NNTP-Posting-Date: 29 Oct 2001 13:34:46 GMT X-Mailer: Mozilla 4.61 [en] (WinNT; I) X-Accept-Language: de,en