Article View: microsoft.public.vb.installation
Article #2Re: previously working VBA app has lost controls & doesn't compile basic statements
From: Stefan Berglund
Date: Mon, 29 Oct 2001 19:13
Date: Mon, 29 Oct 2001 19:13
107 lines
5188 bytes
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!tkmsftngp07References:
<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