PITA_Pan

Are you trying to log in to multiple websites unattended?

Try the onscreen keyboard. (Under accessibility options or something in Control panel). position the mouse over any key and execute a mouse button down command---and just let it ride. You can hold any key down. Some of them don't do much but holding the arrow key sure will zip the cursor down a line of text.

Maybe just walk down the dropdown using down arrow keystrokes until you get to the desired item?

The number of down arrows used can then be held in a variable.

Anything good happen when you open the dropdown and hit the alt key?

I've searched the forum and found other resolutions for drop down problems, but so far, none have worked for me. I have a program with a drop down list of pay grades. I've been able to reproduce this problem in google docs and forms, so I know it's not limited to just my program.

 

The Drop Down:

<none> default

00

01

02

03

04

etc

 

When I create the google form without the <none>, I can simply use the variable %T8% and the proper item is selected. But when the <none> is added, nothing works. Unfortunately, I can not change the program's drop down items, or I would get rid of the <none> option.

 

I've tried switches, if statements, <arrow down>, and everything I can think of, but nothing seems to work. It just appears to skip that option.

 

Can anyone provide me some insight on how to handle this? I think it works without the <none> because it's comparing number to number. But with the <none> it becomes a text field.

 

Any help would be appreciated, thanks.

 

Jon

As a side note, I tried a Variable restore in D to maybe freshen up %DTV% and it didn't work.

I tried passing %DTV% from Macro B (where it was populated) to Macro D (where it is used) via a registry write/read and that does seem to work....at the cost of the write read move and an extra registry entry.

Value of %DTV% in the debugger still looks the same either way but the computation works with the 'fresh' %DTV%

I an trying to use the modify decimal command to subtract one decimal variable from another. But I get odd results.

Top level macro A contains sub-macro B that populates a decimal variable %DTV% (A decimal time value)

Further on in A sub-macro C is called and it in turn has sub-macro D. D uses %DTV% and subtracts another decimal (Called from the registry and parked in %TEMP_REG[%n%]%). The result is placed in %TEMP_DONE[%n%]%. n is incremented and a loop populates n=1 to n=4

Problem is the subtraction gives a strange result: it isn't happening and the result is negative and off by many thousands. What should be 10.789etc. is -40644.789etc.

I check A, B, C and D and check that %DTV% is being correctly declared, populated and it is in each macro (Using the debugger).

I check %TEMP_REG[%n%]% to make sure it is being populated from the registry correctly and it is.

If put macro B (that populates %DTV% in the first place) at the top of macro D so I am creating %DTV% right fresh on the spot then everything works perfectly. Yet the debugger shows the same values for %DTV% and %TEMP_REG[%n%]% no matter how I play it. Only the results in %TEMP_DONE[%n%]% are screwy.

<VARIABLE MODIFY DECIMAL Option="\x01" Destination="%TEMP_DONE[%n%]%" Value1="%DTV%" Value2="%TEMP_REG[%n%]%"/>

If there is a nesting limit of some sort the debugger isn't showing it---a problem with the calculations?

%line% is not %line[1]% FWIW.

If you just wanted to strip the number, why do you want to retain the text: "phone:'? if you want to see it maybe display a message box with the variable containing it as the message? (this for debug purposes)

If the text "phone:" is sometimes that string and sometimes something else, then you need to test it to see what it is to suit your purpose. This will require that you know the range of possibilities for it.

I kind of figured that's what I Had to do. When it's in a line I can do the following (Thanks to you guy's).

// Place Clipboard into Variable

Variable Set to ASCII Char 13 to %CR%

Variable Set to ASCII Char 10 to %LF%

Variable Set String %Content% from the clipboard contents

Split String "%Content%" on "%CR%%LF%" into %Line%, starting at 1

// Place values from SelectPhone into Excel

Delay: 250 milliseconds

Window Activate: Microsoft Excel

Text Type (Simulate Keystrokes): %Line[1]%

 

The problem is "Phone: ". I know it's there but I can't, so to speak, see it. I could save it to a edit program and know exactly what I need to do but that's defeating the purpose. It seems I'm trying to see what's out there on the clouds.

I am trying to copy text from one file and paste it into another file. But when I use the Clipboard File Copy / Paste sequence I get the text pasted twice in the new file. No amount of sprinkling Clipboard Empty commands or delays or fiddling with timing makes any difference. I even tried Exiting MEP and restarting it, rebooting, etc. (which seems to help sometimes with execution of deleted or disabled commands)

Ideas anyone? Known bug?

Spamming craigslist is a bad idea. No matter what money you spend, you will eventually come to grief and your money will be wasted. CL uses timers on the posting forms to limit how quickly you can post. If your account is compromised (like by pissing off your local community by posting too much) you will be lucky to be able to post one ad an hour (and have it not get ghosted). For that, you can just post them by hand. If you use a CL account reposting an ad is very fast unless, once again, you have pissed people off, and then you probably won't be able to use HTML in an ad which means uploading any pics manually---very slow.

Just want to make sure this will work before I buy the software............

 

Can I created Macros that will fill in CL submit ad page, which will cut & paste from either a notepad or MS Word file. Only the Headline and Ad Body would come from the file, the price, location and email address boxes would be typed.

 

I'd like to create several macros that when executed will "fill out" the CL form using the "next" ad in my list, then the next one after that, etc...etc..... These macros would ideally take me to the captcha page (which I will manually handle)

 

Tried Imacros and it WILL NOT recognize the CL Post An Ad page.

 

Thanks

I partially agree. I'm accumulating quite a list of suspected bugs too. Also a list of obvious features that are missing----present here but absent there (WHY?). Overall it shakes your faith. Is there an error in your code or is it a bug? Once you have a hit a more obvious bug and realize they exist....

I sent in two, others await confirmation. But I really hear ya on being a free beta tester, that chaps. Give it to me and I'll beta test it, but drop 60 clams for the privilege?

One thing I have noticed is the longer you have the editor running the flakier it gets. Between 12 and 14 hours of strait work it craps out. Best to reboot (not restart the program, it leaves processes loaded)at 8 hours or so. (and I got 4G of RAM already!. Win7u)

I am a Long time user of MacroExpress ... I just bought Macro Express Pro (4/3/2011), I spent hours moving previous well tested and working macros to MEP.. it's been a nightmare

 

Windows 7 Ultimate, most current updates ... I'm a professional programmer

 

there are so many bugs ,, i had started a list, but aftet 3+ hours , at least a dozen bugs and after having to redo and recreate macros (macros and categories just disappear).. I have reached the point.. I can't afford donating my time to be a free BETA tester for software I paid for...

 

with default installation (and nothing scheduled and no macros running) .. my computer slows down at times to 10+ second delay betweeen keystrokes (when entering the MEP key)

 

I don't believe the company must be still be supporting this product, it can't possible be this bad if anyone there is testing it, are there other users with more successful results?

 

I'm asking for a refund

Wipe the Variable contents immediately before the prompt?

I have a macro that prompts the user with an already existing variable. OK, it does this fine, but the user doesn't like the fact that the string is highlighted in the dialog, and wants to know if I can get the macro to display the information unhighlighted so that he can go ahead and type without having to do anything to unhighlight the text so that he won't overwrite it. I'm not seeing anything about options like this, and I don't think I can send a keystroke to the dialog when the dialog opens but before the user does anything - right?

 

Thanks.

I am prompting my user for a Date and Time and storing this in a date/time variable. I want them to know the context of the Date and Time they are entering however this changes so I put a text variable in the "prompt" field of the Date/Time dialog box. But when I run I don't get the contents of the text variable, I get the literal name of the variable itself (%TEST%).

<VARIABLE SET STRING Option="\x00" Destination="%TEST%" Value="foo" NoEmbeddedVars="FALSE"/>

<DATE/TIME Flags="\xB3" Date="3/31/2011 9:25:35 AM" Day_Offset="0" Month_Offset="0" Year_Offset="0" Hour_Offset="0" Minute_Offset="0" Second_Offset="0" Prompt="%TEST%" Left="Center" Top="Center" Monitor="0" Variable="%OPEN_SI%" IsDateVar="TRUE"/>

Using a variable as a prompt works in other prompts, but not this one. This works well:

<VARIABLE SET STRING Option="\x00" Destination="%TEST%" Value="foo" NoEmbeddedVars="FALSE"/>

<VARIABLE SET INTEGER Option="\x01" Destination="%N[1]%" Prompt="%TEST%" Mask="FALSE" OnTop="FALSE" Left="Center" Top="Center" Monitor="0"/>

Ideas?

BTW, in the case of bugs, is there any way to review what has already been submitted?

Will the macro run with some activation other than the keyboard hotkeys?

I have a problem I've never had before. I sent out a macro to many employees. All employees have the non-editable version of ME 3.5.5.2. The macro works on all employee's computers except one. I have had her ME uninstalled and reinstalled by our IT department. I have changed the macro activation from Ctrl+F12 to Ctrl+Alt+0 (zero) and also Alt+F3. The macro will not start. She has not had any keyboard changes made previously. Can anyone explain what may be going on and how to possibly get her macros to work? Is there something I may need our IT department to do to her computer, or the operating system? A reset, etc? If so, what specifically?

Looks like the registry write command supports the C variables. I set up my own branch under HKCU called AA_MyStuff so it's both writable and easy to find. Add a Binary key called C1 or something and dump to that. Retrieve later. If I could figure out the whole bit with controls I'd test it....

Locate your starting cell with a VBA macro in Excell.

Pick a cell one above your first data cell in the column. Color it blue (thank me later, it's for debugging).

Turn on the Excell VBA toolbar (view/tool bars/visual basic). Press the round Record Macro button. A dialog pops up. Use the default macro name and description unless you are going to be making a lot of them. leave the default selection to save the macro in the worksheet. assign a hotkey (you may not use c). Put your cursor in the box to ad a letter, hold down the shift key (another thank me later) and hit a key.

Now go to the blue cell with the mouse and click it.

Then go to the Visual Basic tool bar and click the square to stop the recording. The VBA MAcro is not recording the mouse moves or keystrokes, it's recording commands (clicks and what you click on, what a keystroke does, etc. open the VBA editor to see the code)

Done. Try out the hot key.

In your ME macro, call the hot key with the text type command.

If you are going to be adding or subtracting columns you can use a slightly different routine. Name the blue cell (ctrl+F3) then us the visual basic macro to hit F5 (brings up the name selector dialog), then the mouse to select a name and hit OK. Again, assigned to a hot key for ME to use.

Once located on the blue square, use an arrow down loop with a counter that increments by 1 to go to the next cell down . It starts at the top every time. Watch your speed.

I've written a macro which needs a few bugs sorted out:

 

The macro is supposed to copy the value of a specific cell (From an active, maximized Excel Worksheet), then paste that value into program B. Then after program B does its thing, the macro repeats, but now drops down one cell. (there are over 1,500 rows).

 

At the moment I'm using mouse positions relative to the open (active) window, but ME is having difficulty finding the cell.

 

Is there a method to tell ME to go to a specific cell in Excel? Once the first cell is chosen, I think the prob is solved because the next time ME just hits the down arrow once, and we're at the next row.

 

Thanks!

You don't mention your OS but most have an onscreen keyboard that you can bring up. This is worked with the mouse and you can hold a key down. Use the mouse button down and mouse button up commands to hold the key.

Just a thot, haven't tried it.

The letter 'y' is a hotkey shortcut used by one of my applications (Magix Movie Edit Pro). In some situations this proves unreliable. Yet it always works fine if instead of my usual tap I hold down the 'y' key for half a second or so. Is there any way I can emulate this in MEP please?

 

--

Terry, East Grinstead, UK

Joe,

I'm working extensively with Excel^® and having all sorts of grief. Navigation and timing issues for the most part. Will you be doing a section on Excel^® on your site?

FWIW, If you only have two workbooks open, sending ALT+F2 (type "F" then type "2", not the F2 key) to the keyboard is a decent toggle between them.

Another game is simply to record a VBA macro Excel^® and save it in your person macros so it is available in any workbook. This is triggered by a hot key. So send that hot key to the keyboard with the text type command and you change to the desired window. You need a hotkey defined (ie, a VBA Macro) for each window but very quick to set up. Sample code:

-----------------------------------

Sub DEMO_CHNGE_WRKBK()

'

' DEMO_CHNGE_WRKBK Macro

' Macro recorded 4/1/2011 byPITA_Pan

'

' Keyboard Shortcut: Ctrl+Shift+Z

'

Windows("test.xls").Activate

End Sub

-----------------------------------

I'm using this sort of game to navigate around the sheets. I may want to add columns later so I go to named cells.

--------------------------------

Sub GO_TO_LOG_DTV()

'

' GO_TO_LOG_DTV macro

' go to log dtv

'

' Keyboard Shortcut: Ctrl+Shift+D

'

Application.Goto Reference:="DTV"

End Sub

-------------------------------

must be something more elegant.....

Having trouble getting Macro Express to pop up an Excel workbook? When using Microsoft Excel with multiple open workbooks, Macro Express can see only the active workbook and not those which lie underneath. In other words, it can only see whichever workbook is currently displayed in the Excel window title. The Macro Express "Activate Window" command is rendered useless in this situation.

 

Here is a solution.

 

Attached to this topic is a zipped help (.chm) file that explains all. Just download, unzip, and read it. NOTE: After unzipping the CHM file, you might have to "Unlock" it. Microsoft has a security feature that prevents viewing a CHM file if it was copied from a network or downloaded. Simply right-click on the file and choose "Properties". Click on the "Unlock" button at the bottom of the General tab, then "Apply". That's it.

 

At some point we will be adding this, and other solutions, to our web site.

Dave,

Win2k is my long standing favorite OS. Upgrade it to service pack 4, it needs it. This may or may not help w/ your issue.

I am using VMWare on Win7 64 bit just so I can still run win2k for special apps. and old times.

I don't have a ME Cd. I usually install things by dumping the install files for the app into a shared (shared w/ win 2k inside VMware) folder. Them move to a "native" win 2k folder then install. That last step prevents the app installer from working directly from a shared folder...reaching back into the 64 bit system.

Macs I dunno about---

Running windows 2000 professional in the VMware Fusion Virtual Machine on my Macbook Pro, but the scripts to load Macro Express into Windows 2000, from the original Insight Software Solutions software CD for Macro Express do not respond.

 

The CD states that this version of Macro Express was designed to run on Windows 2000. Windows 2000 on the virtual machine will not recognize the application go.exe. Also, Win 2000 takes about 5 to 8 minutes just to read the directory of the macro express install CD.

 

Have not yet tried updating the Windows 2000 OS to service pack 2, 3 or 4.

 

Have successfully loaded into VWware, other applications that are compatible with Windows 2000 Professional operating system.