Jump to content
Macro Express Forums

jowensii

Members
  • Posts

    85
  • Joined

  • Last visited

Everything posted by jowensii

  1. Maybe try adding a delay after window activate and text type Activate Window: "Macro Express" Delay 0.5 Seconds Text Type: Send text now <ACTIVATE2:Macro Express><DELAY:.5><TEXTTYPE:Send text now>
  2. I use the following VBA code to start one of my ME macros Private Sub cmd_CreateAcct_Click() On Error GoTo Err_cmd_CreateAcct_Click Call Shell("C:\Program Files\Macro Express3\MeProc.exe //MXEN:\Info Resources\Client Electronic Solutions\TOROL\USER DOCUMENTATION\Create Torol Account.mxe", 1) Exit_cmd_CreateAcct_Click: Exit Sub Err_cmd_CreateAcct_Click: MsgBox Err.Description & vbCrLf & "Error #" & Err.Number Resume Exit_cmd_CreateAcct_Click End Sub
  3. I've used Macro Express to input large amounts dirty data (data not easily cleaned up using queries and so I want to manually review before entry) into Access on several occasions. I just have ME capture the data (either from a CSV file or copy data in fields of other application), and then manipulate and display that captured data in a ME message box. If I like what I see, ME enters the data either into a table/form or creates a CSV file for importing into Access. I've been using ME for several years and can usually write a quick macro to accomplish this task. Someone with less experience may have more difficulty but it certainly is possible and worth exploring. I would definitely recommend Macro Express.
  4. Kevin, are you sure its the CTRL key? I always held the SHIFT key down while clicking on a link to force that link to open in a new browser window. I tried the CTRL key manually and it does not force a new window for any of my systems.
  5. Sometimes (as often as a couple of times a week) I have a problem with ME sucking up 90%+ of my CPU resources (P4 3.2Ghz HT) which brings my system to halt. Sometimes I detect the problem while a macro is running, other times, while ME should be idle. Not sure if a scheduled macro fires before the problem happens or not. When problem occurs, I open Task Manager and select MacExp.exe on the Proccesss tab and then select End Process. As to the number of macros in you macro library causing the problem, I have over 400 macros in library on 3 PC's and don't seem to have any issues with it.
  6. Check out the "How To: Sort Strings Or Numbers " topic
  7. Try changing lines 2 and 4 to something like this. <HTTP:s1.amazon.de/exec/varzea/sdp/sai-thank-you/028-0099386-5990128><WAITWEB2:000010:000000:s1.amazon.de/exec/varzea/sdp/sai-thank-you/028-0099386-5990128><CTRLD><TEXTTYPE:f><CTRLU> Line 2 is a Wait for Web Page command. It will pause until IE reports to windows that it is done loading page. Im line 4 change the case of the letter f to lowercase. I and others here have experienced issues when using an uppercase letter with CTRL or ALT.
  8. Maybe you can change keyboard layouts via the registry.
  9. randallc, I'd like to thank you for your demonstration also. I've read in other posts about your preference for using the Environmental Variables with ME. I had it in the back of my mind to look closer at what you said. Delete File or Files: "%AnswerTXT%" Variable Set String %T7% "%DirPath%\hta3\*" Variable Modify String: Append "%T3%%CRLF%" to %T4% In your example, I see that you are using the Environmental Variable directly in your ME commands. It never crossed my mind to do it that way. Great idea.
  10. I'm trying to create an Advanced Installation for ME following the ME Help topic. My command line looks like this: "N:\Info Resources\Desktop Setup\Macro Express\Macro Express v3_5c.exe" /S /M=N:\Info Resources\Desktop Setup\CoPath\Macro Express\CoPath_ME_Setup.txt Here's my CoPath_ME_Setup.txt setup file: STARTUP=Y LAUNCHNOW=Y QUICKSTARTNOW=NP REBOOT=N LICENSENAME="REMOVED for POST" LICENSECODE="REMOVED for POST" CONFIGFILEPATH=N:\Info Resources\Desktop Setup\CoPath\Macro Express\Copath Label.mcf NOEDITOR=N HOHELP=N NOICONS=N The Advance installation runs silently but none of my parameters defined above are set. Quickstart runs, License info is not set, Config settings are default instead of the ones set in my MCF file. Any ideas what I may be doing wrong?
  11. Right now our document Imaging/Worklfow application requires TIF images to start workflow packages. We're not happy with that limitation but it is what it is.
  12. I just downloaded it last week for development of a ME macro to convert JPG images to TIF using one of it's many command line arguments. I was certainly impressed with the speed of Irfanview to perform this task without having to start GUI. I havn't used any of it's manual tools yet but the command line arguments are exactly what I was looking for.
  13. I've always avoided using the Wait Time Delay command becuase the Help section said the macro cannot be stopped during this phase: While reading your post I was thinking of a few of macros that would really benefit from "virtually no CPU cycles" benefit of the command of long delays. I just don't like the idea of not being able to stop the macro. Then I had an idea... Instead of a single 60 second Wait Time Delay, I created a 60 count Repeat that started with a 1 second Wait Time Delay followed by a 0.01 Delay command. Repeat Start (Repeat 60 times) Wait Time Delay 1 Seconds Delay 0.01 Seconds Repeat End This code had the following benefits as opposed to the single 60 second Wait Time Delay: The macro could be exited during the 60 second delay. (Right clicking on the "Running Man" icon was 100% effective while the Hot Key method was less reliable. Task Manager showed a CPU Usage of 50% during the single 60 second Wait Time Delay, while the above code had a 1% CPU Usage during it's 60 second delay. Now I have some macros to hunt down and improve. Later...
  14. I work in the IT department for a medical laboratory. We use a product called Optika Acorde for document management and workflow. We image everything from test requisitons and patient results for technical departments, insurance information, Captial Budget requests, PO's and packing slips for Purchasing dept, Resumes and Applications for Human Resources. I could go on for a while even though I would guess that we are only imaging about 25% of our paper. Right now I'm working on a project with Macro Express and a new kick a$$ HP LasereJet 4345MFP that I ordered for our HR department to replace their aging HP 5si. Now they have one device that prints, scans and faxes. I didn't know it at the time of ordering, but this MFP device can send scanned images directly to network folders. Once I realized this, I began exploring the possibility of using ME and this device to submit scanned documents to workflow. We have 3 scanning workstations that normally serve this purpose. These workstation/scanner setups are very expensive and in constant demand by our users. Most of the users have to leave their department to use one of these workstations, sign on to the network, start the application and scan their images. They then have to use a different app to view the image and type in index values. I've got one Macro in production that allows the HR department to scan the resumes and apps at the HP MFP in their office. It sends it to a network folder. They start a playable macro that displays the TIF image using the Kodak Image viewer in Windows 2000 and then prompts them to enter index values. ME then asks if they want to submit the images to Optika. ME creates the text file with the required index values and moves the images to the proper network location for filing. They love it. They no longer have to leave their dept or fight for access to the scanner. The MFP also has a touch pad that the users can type in the index values right there at the device. This makes it possible for the userto submit documents without the user ever having to log into a computer. It also has OCR capabilities. It's my hope to use ME to pull out index value from the OCR text file for some of our workflow processes. It has a lot of promise. My boss is really interested because we would be able to deploy additional scanning devices for half the cost of full imaging workstation.
  15. You could just try without the Variable Set %T96% to ASCII Char of 10 Variable Set String %T95% "%T95%%T96%" Go ahead, let me know how it works. It's my turn to be lazy?
  16. IMO, I think creating macros using keyboard shortcuts is easier than capturing controls. In our environment, our Imaging/Workflow application has controls that have dynamic characteristics. Marcros with contol related commands for this app are very difficult and time consuming to create. That being said, if I am creating macros for other users in our organization, I prefer to work with controls whenever possible. I think they are usually more reliable. If it's a macro just for me, then I don't care. I can tinker with it when time permits until I have it working reliably.
  17. I've always used the following becaue I have just assumed that you need CR & LF together: // Set CRLF Variable Set %T95% to ASCII Char of 13 Variable Set %T96% to ASCII Char of 10 Variable Set String %T95% "%T95%%T96%" // Set CRLF // Set TAB Variable Set %T94% to ASCII Char of 9 // Set TAB <REM2:Set CR><ASCIIC:95:1:13><ASCIIC:96:1:10><TVAR2:95:01:%T95%%T96%><REM2:Set CR><REM2:Set TAB><ASCIIC:94:1:9><REM2:Set TAB> This is probably similar to what you've seen in other posts. It works and I really haven't thought to try it any other way. I frequently use the TAB character also.
  18. Try enclosing your link inside an open and close angle bracket. Example: <http://www.macroexpress.com/> I'm not sure if it will work with web hyperlinks but I use ME to send mail messages with hyperlinks to network folders and files that look like <\\servername\folder>. We use MS Outlook as our email client and irt handles these links even in a plain text message.
  19. I use this command when I need to ensure a new browser window is opened. Just put the web address in the "Program Parameters" field of the "Program Launch" command. Program Launch: "iexplore.exe" <LAUNCHDEL2:0:01C:\Program Files\Internet Explorer\iexplore.exe<PARAM>http://www.cyberguys.com2>
  20. Shame! Shame! Shame!
  21. Sounds awesome, Joe. I can hardly wait to see your guys' solution. I know from previous posts, there are pleny of others that will be glad to see it also.
  22. Hey guys, just wanting to know if anybody else is experiencing an issue with their "Abort Macro Hotkey" defined in Options --> Playback. I have used the PAUSE key as my abort hotkey for years and now on all 5 of my PC's with ME (v3.5c) it no longer works. The only abort hotkey I can ge to work is the "WIN+`" which is what I normally used as my "Pause Macro HotKey". If I set it as my Abort Hotkey, then none of the remaining available hotkeys for Pause Macro HotKey" will work. Just wondering if anyone else is seeing this before I report a bug. It has to be a bug if I can reproduce it on 5 PC's, right???? RIGHT????
×
×
  • Create New...