Jump to content
Macro Express Forums

cryptorchid

Members
  • Posts

    3
  • Joined

  • Last visited

Everything posted by cryptorchid

  1. I have six windows and need to select off a string at the front and the back of the title. The titles look like this "TF 06-09 4/2/2009 125 tick" which is made of <Symbol><Contract><Date><Type of Chart>. I want to select a window by the Symbol and Type of Chart. So given TF and 125 tick, activate that one window. I was hoping to see a wildcard character in the Window Title "TF * 125 tick". How can I make this happen? Is there a wild card capability? Can I get a list of all windows and search strings for correct components? Any ideas and / or suggestions welcomed CryptOrchid Added on: Figured out a solution on my own again. This seems to work, is it the preferred method: Variable Set String %T1% "6E" Variable Set String %T2% "(15 Tick)" Repeat with Windows: Place title in %T3% If Variable %T3% contains variable %T1% AND If Variable %T3% contains variable %T2% Activate Window: "%T3%" End If Repeat End CryptOrchid
  2. Looks like I found my own solution on another website. There is a command to execute a dos command called shell(). I found the solution here: Forum post on using shell command
  3. This is very similar question to question 31 in the knowledge base. I am hoping that some one has come up with a better solution in 9 years. I want to launch a macro express macro from excel, VBA. I first thought it would be simple by launching via the commandline and pass along some variables, but have not figured out how to launch dos command from excel. Excel does have the capability to send DDE commands via vba and wondered I can do something similar with Macro Express. Here is an example code of DDE Execute from Excel to Word channelNumber = Application.DDEInitiate( _ app:="WinWord", _ topic:="C:\WINWORD\FORMLETR.DOC") Application.DDEExecute channelNumber, "[FILEPRINT]" Application.DDETerminate channelNumber I would also need to pass along some variables. Any clue how I can launch a Macro Express macro from Excel? Thanks CryptOrchid
×
×
  • Create New...