| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Application
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" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Application
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" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Application
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" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Application
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" wrote in message ... 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" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Application
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" wrote in message ... 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" wrote in message ... 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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Application
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" wrote in message ... 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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Application.GetOpenFilename vs Application.Dialogs(xlDialogsOpen) | Excel Programming | |||
| Replace application.RTD property by Application.RTDServers collect | Excel Programming | |||
| macro to close excel application other than application.quit | Excel Programming | |||
| Using Application.Run in VBA | Excel Programming | |||
| application.quit will not shut off application | Excel Programming | |||
Hybrid Mode
