Jump to content
Macro Express Forums


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About IceBox

  • Rank

Profile Information

  • Gender
  1. I took rberq's advice and it worked, and then I thought maybe there was a shortkey to open the view macro window. So maybe I could save a keystroke or two. In researching that, I found out that shortkeys can be assigned directly to the macros. So one Excel macro is now CTRL+Q and the other is now CTRL+Z. So my Macro Express code presses those shortkeys, and it is working perfectly. I kind of feel a little dumb that myself and another programmer spent hours making this harder than it needed to be, but thank you for pointing me in the right direction!
  2. I love that idea! I will see if it works tomorrow when I am back at it at work and I will post the results here. Thank you!
  3. First, thank you for taking the time to respond to my question. I really do appreciate it. With that being said... I know that is always an option, but I think it is pretty standard in the Macro Express world to use mouse moves/clicks as a LAST resort. This macro will be used by dozens of employees at my company, and I cannot guarantee they will all have the same screen resolution or even have the spreadsheet maximized.
  4. Does anyone know if this can even be done? Here is what I am trying to do: Use Macro Express to gather some information from an application Have Macro Express then activate an Excel file that is already open. Once Excel is activated, I want a VBA macro in the Excel file to automatically be triggered (to clear the sheet) I then need Macro Express to fill out two cells from the info it gathered at the start of the macro. Finally, activate a second VBA macro that is already programmed. I have found some code online that seems to work when the file is closed. When the file is open,
  5. Hello. My company is using version currently. With this version, is there a way to have a macro move a window from one monitor to the other? Anything we've tried has just resulted in the window stopping along the right edge of the first monitor. Thanks.
  6. Thank you! Makes sense. Fixed in 3.6 and we are still using
  7. Was this ever corrected? I received an email today asking me to fix a macro that is not rounding correctly. After testing, I see that the issue is EXACTLY what I described back in 2006. We are currently using Version Was it fixed after this?
  8. Hey all. I was wondering if anyone else was having this problem, or if anyone knows how to fix it. When using Microsoft Office Communicator (Desktop Application, not the web-based version), pressing Win+Q will open your contact list. If you program a macro with a hotkey of Win+Q, it does not override this, like it normally should. Even with the macro programmed, and activated, Win+Q will still open your Communicator contact list. Any ideas? Thanks, -- Mike
  9. You can do this a few different ways: Enter text using the "Text Type" command. Use the "Pause" command. This will create a pop-up box in the top-left corner of your screen that says "Macro Express is currently paused." and includes a Resume and an Abort button. You can also use a complex pause, which allows you to change the text that displays while the macro is paused. i.e. "Enter date". The complex pause also allows you to specify where on the screen the pause box will be displayed. Or, in place of the pause command, you can use a "Wait for Key Press" command, and specify wh
  10. Thanks again Paul! I will give this a shot as soon as I can.
  11. Thanks Paul! That sounds like a perfect workaround. Do you have the code that is needed to make the registry changes (And change it back, of course)? I am using Windows 2000. Thanks! -- Michael
  12. Does anybody know the extent of Macro Express' functionality while a workstation is locked? I have already found out that a scheduled macro will still run if the workstation is locked. The functions I know it can perform on a locked workstation are: 1. Display a text box 2. Launch an application I am sure there are others, but these two I know from testing. So is there a distinct list of commands that do/don't work on a locked workstation documented anywhere? And the most important question... Does anyone know how to get Macro Express to unlock your workstation? If that
  13. Hey guys. I think I got a real mystery here. I posted something about this already in this forum WAY back in January 2005. The link is HERE Rather than start over, please read that post first and then I will continue from there... Anyway... now this has gotten a bit trickier. I have created 2 different macros that attempt to press "n" for the notify button when the "File In Use" box pops up. One is the actually macro that I need this to apply to, and the other is a very short macro designed only to test this particular problem. When I run the "real" macro, it hangs up when th
  14. Hopefully someone can help me here. I have been having a very difficult time figuring out the logic used by Macro Express when rounding. I did read an article in this forum once, as well as the section of Joe's book that discusses "Banker's Rounding", but I don't think that's the issue in this case. No matter what number I try, if I tell Macro Express to round a Decimal Variable to 2 places, it always rounds "5" down. So: 1.755 becomes 1.75 when it should be 1.76 1.765 becomes 1.76 when it should be 1.77 and so on and so on. The only fix I have found is to add .00000001 to the
  15. Hello. Does anyone know what registry key needs to be changed to turn off the Microsoft Office Clipboard, and how that would be programmed in Macro Express? I must admit, the Windows Registry is somewhat unfamiliar territory for me, so the more detail the better. I know how to turn off the clipboard manually, but I would like to use macro commands to turn it off. Any help would be appreciated. Thanks! Michael
  • Create New...