🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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
#4
Author: Muehlmann Martin
Date: Thu, 25 Oct 2001 15:31
33 lines
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
#5
Author: Stefan Berglund
Date: Fri, 26 Oct 2001 00:19
44 lines
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
#1
Author: 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.)
***************************************************************************
---------------------------------------------------------------------------
Re: previously working VBA app has lost controls & doesn't compile basic statements
#2
Author: 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.)
>
***************************************************************************
> --------------------------------------------------------------------------
-
>
>
Re: previously working VBA app has lost controls & doesn't compile basic statements
#3
Author: Larry Serflaten
Date: Mon, 29 Oct 2001 19:38
18 lines
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