Home » Blogs » zdenekteply's blog

EXCEL 2010/2003

Submitted by zdenekteply on 6 August, 2012 - 13:31

I have 2 versions of Excel. How to call out the application for both of them?

Shell "EXCEL"

Is it possible to tell with version should be open?

Thank you,

Zdenek

»
Nick's picture

launch excel.exe from it's

Submitted by Nick on 6 August, 2012 - 14:59.

launch excel.exe from it's full file path

»

How to view the activated window

Submitted by zdenekteply on 7 August, 2012 - 07:55.

Hi Nick,

thanks for your brisk and clear answer.

Please, help me clearify one more point:

If I from my original excel file start a macro:

1. open PowerPoint
2. open Excel 1
3. open Excel 2
4. open WordDocument

PowerPoint stays always in the front and the rest in the backround.

Can I somehow switch to Excel, Word or to my original excel file - at the end of my macro or throughout the macro?

The problem is, that I cannot see the progress behind the screen.

And commands like AppActivate, GetObject or Open will not change the screen and all of them work in the backround of PowerPoint.

I hope, that you can help me hereby.

Best Regards,

Zdenek

»
Nick's picture

have a play with this: Sub

Submitted by Nick on 7 August, 2012 - 08:47.

have a play with this:

Sub PowerPointDemo()

Set ppt = CreateObject("PowerPoint.Application")
ppt.Visible = True ' show the ppt
ppt.Visible = false ' hide the ppt

End Sub

»

ppt.Visible = false ' hide the ppt

Submitted by zdenekteply on 8 August, 2012 - 09:48.

It does not work - I do not know why.

I get this message:

Run/time error -2147188130 (80048240)
Application.Visible: Invalid request. Hiding the application window is not allowed.

what am I doing wrong?

I need only to switch between the windows, like with commands: ALT-TAB...

Thanks for your advice,

»
Nick's picture

well...if appactivate doesn't

Submitted by Nick on 8 August, 2012 - 10:01.
well...if appactivate doesn't work, and neither does showing / hiding, the only other thing I can think of is to change the order of the objects you create... i.e. create the one you want visible last.. Click one of these "Like" buttons this helps..

Nick
»

ActiveWindow.WindowState = xlMinimized

Submitted by zdenekteply on 8 August, 2012 - 14:01.

Hi Nick,

your suggestion works well, but which command could I use to minimized the window of Power.Point.

ActiveWindow.WindowState = xlMinimized

Works well only for excel Window. How can I edit the command to minimized the window for Power.Point?

Thank a lot,

»