Jump to content
Macro Express Forums

Hidden Window


patgenn123

Recommended Posts

Hey all,

 

I was wondering if anyone else came across the same problem.

 

A) I want ME to open an Excel file right after a COMPLETELY SEPARATE program launches.

B) I want the Excel file to be hidden when it launches

C) The excel file is an OLE DB that connects to a database and refreshes every 30 seconds

D) A dialog box called "refresh query" opens up in between the first program and Excel, asking the user to either ENABLE automatic refresh or disable the automatic refresh.

 

There are two problems:

 

1) Excel does not open hidden. It's probably because of the interim "refresh query".

2)Of course, there is an ALT-E and ALT-D hotkey to cause the window title "refresh query" to close, but how can this all be done hidden?

 

Any suggestions?

 

-P

Link to comment
Share on other sites

I thought of another question. Have you tried the Window Hide command?

 

But, either of these should hide the main window but may not hide child windows. You may want to try the Window Hide command on the child windows.

Link to comment
Share on other sites

"Hidden" and "Minimized" options of Launch Program seem to have no effect. I thought there might be a command-line option for Excel to open minimized, but no, can't find one. The best I could do was launch it and then immediately minimize it. And that doesn't help with your refresh pop-up. I'm stumped!

Link to comment
Share on other sites

That's true. Thanks Kevin for the suggestion.

 

However, I would like the Excel program to not show at all. Not even a flicker.

 

I too am having problem with "Launch" when clicking "hidden'. Is there any way it doesn't show at all? I guess it looks like a VBscript or a Macro within Excel is the only solution?

 

Is this a bug?

 

-P

Link to comment
Share on other sites

<IFOTH:04:2:Microsoft Excel - ACT! Excel ole db><MSTOP><ENDIF><LAUNCHNO3:2:0112ACT! Excel ole db<LAUNCH:C:\Documents and Settings\Pat\Desktop\ACT! Excel ole db.xls3><DIS:<ACTIVATE2:Refresh Query><DIS:<WAITWIN2:000010:000000:Query Refresh><DIS:<GETCONTROL:01:EXCEL.EXE:001:bosa_sdm_XL9Query Refresh><DIS:<SETFOCUS:01><DIS:<MMW2:20,-164><DIS:<CCLICK:T:01:0:T:><DIS:<ZORDER:1:Refresh Query><DIS:<ZORDER:2:Microsoft Excel - ACT! Excel ole db><WHIDE:Query Refresh><IFOTH:03:2:Refresh Query><DIS:<ACTIVATE2:Query Refresh><DIS:<IFOTH:03:2:Refresh Query><DIS:<WHIDE:Refresh Query><TEXTTYPE:<ALTD>e<ALTU>><ENDIF><WHIDE:Microsoft Excel - ACT! Excel ole db><IFOTH:14:1:ACTSAGE.EXE><WSHUT:Query Refresh><WSHUT:Microsoft Excel - ACT! Excel ole db><ENDIF>

 

 

The last 5 lines don't work. Why? I am assuming that ME makes a run through the macro however many times the window is active, but doesn't hold the last 5 lines in memory. Is there a workaround?

 

-P

Link to comment
Share on other sites

For debugging, try putting a Text Box Display after the IF, to make sure the IF is being satisfied the way you think it is.

 

I don't know how the macro is being launched, so I'm not sure why ME would "make a run through the macro however many times the window is active". I doubt that the problem has anything to do with lines being dropped from memory.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...