Jump to content
Macro Express Forums

jowensii

Members
  • Posts

    85
  • Joined

  • Last visited

Posts posted by jowensii

  1. 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

  2. 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.

  3. Kevin, are you sure its the CTRL key?

     

    Another approach would be something like this:

    CODE 

    Control Key Down

    Mouse Left Button Click

    Control Key Up

     

    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.

  4. 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.

  5. 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>

     

    Web Site: s1.amazon.de/exec/varzea/sdp/sai-thank-you/028-0099386-5990128

    Wait for Web Page: "s1.amazon.de/exec/varzea/sdp/sai-thank-you/028-0099386-5990128"

    Control Key Down

      Text Type: f

    Control Key Up

     

    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.

  6. 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.

  7. 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?

  8. 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.

  9. I've always avoided using the Wait Time Delay command becuase the Help section said the macro cannot be stopped during this phase:

     

    Note: This command suspends Macro Express for the amount of time specified. During this time the macro cannot be terminated by pressing the Scroll Lock+Pause keys or by right clicking on the "Running Man" icon in the system tray.

     

    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... ;)

  10. 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.

  11. 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.

  12. 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.

  13. 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>

  14. 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...