Application

[Michael]

Hi.
In my application i have a macro that open another application, is it
possible to hide that application and still be able to write to it?

Mike

[Bob Phillips]

Again, do you mean workbook? If so, try

Windows(workbook_name).Visible = False

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Michael" <[email protected]> wrote in message
news:[email protected]...
> Hi.
> In my application i have a macro that open another application, is it
> possible to hide that application and still be able to write to it?
>
> Mike
>
>

[Michael]

Thank's for the help again Bob :-)
--
Nil Satis Nisi Optimum


"Bob Phillips" wrote:

> Again, do you mean workbook? If so, try
>
> Windows(workbook_name).Visible = False
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Michael" <[email protected]> wrote in message
> news:[email protected]...
> > Hi.
> > In my application i have a macro that open another application, is it
> > possible to hide that application and still be able to write to it?
> >
> > Mike
> >
> >
>
>
>

[Michael]

Yes its a workbook, its called statistikk

But it didnt work as i hoped!

I get "type mismatch" or "subscript out of range".

i know it is open but it seems that the macro dosnt find it.

Windows(Statistikk).Visible = False

or

Windows("Statistikk").Visible = False

doesnt work
--
Nil Satis Nisi Optimum


"Bob Phillips" wrote:

> Again, do you mean workbook? If so, try
>
> Windows(workbook_name).Visible = False
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Michael" <[email protected]> wrote in message
> news:[email protected]...
> > Hi.
> > In my application i have a macro that open another application, is it
> > possible to hide that application and still be able to write to it?
> >
> > Mike
> >
> >
>
>
>

[Bob Phillips]

Almost Michael, when I say workbook name I mean with the extension

Windows("Statistikk.xls").Visible = False


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Michael" <[email protected]> wrote in message
news:[email protected]...
> Yes its a workbook, its called statistikk
>
> But it didnt work as i hoped!
>
> I get "type mismatch" or "subscript out of range".
>
> i know it is open but it seems that the macro dosnt find it.
>
> Windows(Statistikk).Visible = False
>
> or
>
> Windows("Statistikk").Visible = False
>
> doesnt work
> --
> Nil Satis Nisi Optimum
>
>
> "Bob Phillips" wrote:
>
> > Again, do you mean workbook? If so, try
> >
> > Windows(workbook_name).Visible = False
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "Michael" <[email protected]> wrote in message
> > news:[email protected]...
> > > Hi.
> > > In my application i have a macro that open another application, is it
> > > possible to hide that application and still be able to write to it?
> > >
> > > Mike
> > >
> > >
> >
> >
> >

[Michael]

Hi again Bob.

I forgot to tell you that i tried this one to.

Windows("Statistikk.xls").Visible = False

The message i get is "Run time error 9" "subscript out of range"
--
Nil Satis Nisi Optimum


"Bob Phillips" wrote:

> Almost Michael, when I say workbook name I mean with the extension
>
> Windows("Statistikk.xls").Visible = False
>
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Michael" <[email protected]> wrote in message
> news:[email protected]...
> > Yes its a workbook, its called statistikk
> >
> > But it didnt work as i hoped!
> >
> > I get "type mismatch" or "subscript out of range".
> >
> > i know it is open but it seems that the macro dosnt find it.
> >
> > Windows(Statistikk).Visible = False
> >
> > or
> >
> > Windows("Statistikk").Visible = False
> >
> > doesnt work
> > --
> > Nil Satis Nisi Optimum
> >
> >
> > "Bob Phillips" wrote:
> >
> > > Again, do you mean workbook? If so, try
> > >
> > > Windows(workbook_name).Visible = False
> > >
> > > --
> > >
> > > HTH
> > >
> > > RP
> > > (remove nothere from the email address if mailing direct)
> > >
> > >
> > > "Michael" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > Hi.
> > > > In my application i have a macro that open another application, is it
> > > > possible to hide that application and still be able to write to it?
> > > >
> > > > Mike
> > > >
> > > >
> > >
> > >
> > >
>
>
>

[Bob Phillips]

Michael,

That seems to suggest then that you do not have a workbook called
"Statistikk.xls" open in Excel. Is it spelt correctly?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Michael" <[email protected]> wrote in message
news:[email protected]...
> Hi again Bob.
>
> I forgot to tell you that i tried this one to.
>
> Windows("Statistikk.xls").Visible = False
>
> The message i get is "Run time error 9" "subscript out of range"
> --
> Nil Satis Nisi Optimum
>
>
> "Bob Phillips" wrote:
>
> > Almost Michael, when I say workbook name I mean with the extension
> >
> > Windows("Statistikk.xls").Visible = False
> >
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)