🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

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

#2
From: Stefan Berglund
Date: Mon, 29 Oct 2001 19:13
107 lines
5188 bytes
Office Developer Edition contains a Package & Deploy Wizard. Other than
that, I can't help you since I don't do Office apps.

"Muehlmann Martin" <myhle@sbox.tu-graz.ac.at> wrote in message
news:3BDD5AF6.167AFA7B@sbox.tu-graz.ac.at...
>
>
> 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: <u2GVB2KYBHA.1488@tkmsftngp07>
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!newsfeed00.sul.t-online.de!t-online.de!tkmsftngp01!tkmsftngp07
References: <3BD83060.25E79D3E@sbox.tu-graz.ac.at> <eZQNbObXBHA.1480@tkmsftngp03> <3BDD5AF6.167AFA7B@sbox.tu-graz.ac.at>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII
X-Google-Thread: fde1d,9814d4eff553617
X-Google-Attributes: gidfde1d,public
X-Google-Thread: 11493c,9814d4eff553617
X-Google-Attributes: gid11493c,public
X-Google-Thread: 1136b3,9814d4eff553617
X-Google-Attributes: gid1136b3,public
X-Google-Thread: 10b213,9814d4eff553617
X-Google-Attributes: gid10b213,public
X-Google-Thread: 10229f,9814d4eff553617
X-Google-Attributes: gid10229f,public
X-Google-ArrivalTime: 2001-10-29 11:12:14 PST
From: "Stefan Berglund" <res0091h@spamfree.gte.nospam.net>
References: <3BD83060.25E79D3E@sbox.tu-graz.ac.at> <eZQNbObXBHA.1480@tkmsftngp03> <3BDD5AF6.167AFA7B@sbox.tu-graz.ac.at>
Subject: Re: previously working VBA app has lost controls & doesn't compile  basic  statements
Date: Mon, 29 Oct 2001 11:13:10 -0800
Lines: 109
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <u2GVB2KYBHA.1488@tkmsftngp07>
Newsgroups: microsoft.public.vb.installation,microsoft.public.vb.general.discussion,microsoft.public.vb.controls,microsoft.public.de.vb,basicworld.public.vb.allgemein
NNTP-Posting-Host: lsanca1-ar3-145-251.lsanca1.dsl.gtei.net 4.33.145.251
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!newsfeed00.sul.t-online.de!t-online.de!tkmsftngp01!tkmsftngp07