Thread View: microsoft.public.vb.installation
5 messages
5 total messages
Started by Muehlmann Martin
Thu, 25 Oct 2001 15:31
previously working VBA app has lost controls & doesn't compile basic statements
Author: Muehlmann Martin
Date: Thu, 25 Oct 2001 15:31
Date: Thu, 25 Oct 2001 15:31
33 lines
2932 bytes
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
Re: previously working VBA app has lost controls & doesn't compile basic statements
Author: Stefan Berglund
Date: Fri, 26 Oct 2001 00:19
Date: Fri, 26 Oct 2001 00:19
44 lines
3031 bytes
3031 bytes
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. "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 > > > >
Re: previously working VBA app has lost controls & doesn't compile basic statements
Author: 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.)
***************************************************************************
---------------------------------------------------------------------------
Re: previously working VBA app has lost controls & doesn't compile basic statements
Author: 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.) > *************************************************************************** > -------------------------------------------------------------------------- - > >
Re: previously working VBA app has lost controls & doesn't compile basic statements
Author: Larry Serflaten
Date: Mon, 29 Oct 2001 19:38
Date: Mon, 29 Oct 2001 19:38
18 lines
2251 bytes
2251 bytes
"Muehlmann Martin" <myhle@sbox.tu-graz.ac.at> wrote > 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). > > Other suggestions? Build yourself a form in Excel that has all the controls you need, you might even add a few simple macros, then save it and compare with the one that is giving you problems. There are bound to be differences, otherwise it would have worked properly the first time. You will have to reconcile those differences before making another attempt at loading it in.... LFS
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads