Jump to content
Macro Express Forums

balithag

Members
  • Posts

    11
  • Joined

  • Last visited

balithag's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. Hi, I'm a longtime ME 3 user and I wondered if the Title field in file properties is available to ME Pro as a field to which we can write new values or even capture the current value. The item I'm referring to can be found for example on Microsoft Word documents in file properties in the Summary tab. It's not available for certain other types of files like pdf files. In a Windows Explorer window, you can view the Title by right-clicking the file's icon, choosing Properties, and choosing Summary. I looked for a way to access it with ME3's commands "Rename File or Files", "File Attributes", and "Convert Filename" with no luck. Would I have file Title available if we upgraded to ME Pro? If it's not available in either product, I'll submit a suggestion that you make Title plus the other fields on the Summary tab like Author, Subject, Keywords, Category, and Comments "visible" to some version of Macro Express. Thanks in advance.
  2. Please pardon me if this subject has already been addressed elsewhere. For the record, I tried to search the forum, but the only terms I could think of to search on had four or fewer characters: GOTO, skip, jump Is there a Macro Express 3 command that simulates the GOTO command in Basic, where you specify either by line number or by some other marker a place in the same macro to jump to if a certain condition is met? I'd like to avoid having it call an outside macro if possible. Thanks in advance.
  3. I agree, this makes it wonderful to administrate ME3. I have not yet tried having the macro do different things based on locally stored variables, but that holds promise for us too.
  4. You can tie the button Click event in Excel to a command like this in Visual Basic: Call Shell("C:\Program Files\Macro Express3\MeProc.exe /AYourMacroName", 1)
  5. Hi, Cory, I had been using some of the techniques in your tutorial, but reading through it fleshed out some things for me and taught me some new things too. Thanks.
  6. That was going to be my suggestion. I work with Datatel Benefactor, whose User Interface window has the same name as a hidden window, so the command Windows Activate is useless. I use Windows Minimize to minimize something else to make Benefactor the active window.
  7. If you're hiding the window yourself to try to get it out of the user's face, I'd recommend using an ASCII text file as a source instead. I used to have ME3 harvest data from Excel cells to store in text variables and send to another program. That was good for awhile, but it was somewhat slow. I found that saving the Excel file as a tab-delimited or comma-separated text file and then using the ME3 command ASCII File Begin Process was quicker and less error-prone than jumping into an Excel window and back. The text file gets opened in the background by ME3--you never even see it on your taskbar. It can assign values to text variables for a whole row at a time, even if it has up to 99 columns. Just remember to put an ASCII File End Process at the point where you want it to advance to the next row. Hope that helps.
  8. I have a somewhat similar problem and I'll share my solution to see if it helps. A macro needed to activate a Datatel Benefactor user interface (UI) window, but Datatel's UI has one hidden text-only window that has EXACTLY the same window title. When I sent the macro command activate window for that title, it was anyone's guess which one ME3 would activate. I have gotten around the problem in one of two ways, depending on the circumstances. 1. Before the macro starts, have the user, activate the elusive window, then the less elusive one in that order. Then in the macro, use the macro command Minimize window for the less elusive one, and the elusive one should be the "next in line." 2. Another way I have handled it is to avoid using Excel or any other open file as a source file to copy data from and instead use the ASCII File Begin Process command. It both saves time and eliminates worries about activating the right window at all, because the text file is processed in the background. This is the solution I recommend most highly, but the first is worth a try too.
  9. Well, the presentation went okay, though there was microphone trouble for much of it. I found out that The College of Wooster uses Macro Express 3 with Datatel products a fair bit, and I'll be discussing applications for Macro Express 3 in the Datatel forums.
  10. Good to know this. Interesting topic, too. I continue to be amazed at what this program can do.
  11. Hi there, I've been a fan of Macro Express 3 for 6 or 7 years. I used it first at Baker College to harvest information from a text-only screen of an AS/400 system to bring into Microsoft Access. The solution I designed there is still being used, though it may soon be replaced. Now I'm at a different Michigan college in the fundraising area and using Macro Express 3 much more for data entry into Datatel Benefactor. I'm going to be presenting on "Benefactor Data Entry with Macro Express 3" at the national Datatel Users' Group conference in early March. Is there anyone else out there using Macro Express 3 with Benefactor or other Datatel products? We plan to move to Datatel's Colleague Advancement in the next couple of years. I've experimented with the Get Control command on Datatel's "UI 1.5" (graphical user interface) with mixed results. The controls in the screens don't seem to have particularly unique control addresses, so ME3 has a hard time telling where the "focus" is in the process of data entry. I end up relying on default tab orders to move among controls, with lots of pauses added between movements because the Datatel response to a click or an entry can vary so widely. I have to design pauses to last for the longest response time I've experienced, which wastes some time when the actual response rate at the moment is shorter. I guess I'm just looking for someone who has dealt with similar issues using Macro Express 3 and who might have a chance of helping me look even a little less ridiculous in front of a group of colleagues from across the country. Of course it may be too late!
×
×
  • Create New...