🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: microsoft.public.vb.installation
Article #1

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

#1
From: Muehlmann Martin
Date: Mon, 29 Oct 2001 13:34
80 lines
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-mail
References: <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