Jump to content
Macro Express Forums

Newbie With Simple Macro


Hubie
 Share

Recommended Posts

I imported a simple clipboard macro, that lets me use

 

Ctrl-1, Ctrl-2, etc Ctrl-9 as copy keys, and

Alt-1, Alt-2, etc, Alt-9 as paste keys

 

 

I am finding that these macros work great, BUT they dont work all the time!

 

Example: I'm copying names from a spreadsheet into different forms. I go through my Ctrl-1 to Ctrl-9 and paste them with my Alt-1 to Alt-9.

 

Problem is, in most cases only about about 6 or 7 of the 9 attempts work. The Alts seem to paste for all, but it's almost as if the Ctrl's only work sometimes.

 

At first I thought it was me, I was missing some or not hitting the buttons right, but time and time again this happens. It's not a specific one either, just seems like the Ctrl button doesnt always work with macros.

 

This isnt a program specific thing, regardless when I'm using these macros this happens here and there.

 

Any ideas?

 

Hubie the Newbie

Link to comment
Share on other sites

One issue I can think of is that the CTRL + key short keys are used by a lot of programs so we tend to stay away from that combination. Try changing the hotkey and see if it makes a difference.

 

Do you have exactly 9 pieces of data you need to copy and paste? Is there a reason you need to copy all the variables first and then paste all after?

 

If your data is organized in your spreadsheet and the fields on your form remain in the same location you should be able to automate the whole process so at the press of one button you export all the data from your spreadsheet.

 

I don’t have too much detail on the use of you macro but it may be quicker to copy and paste one variable at a time. I use this simple macro to copy data from one window to another (when the data is randomly distributed). Simply use your mouse to highlight the data you wish to copy > press the hotkey > move your mouse into the field of the form you wish to put the data and left click.

 

Good Luck

:) Gabriel

 

<CTRLD><TEXTTYPE:c><CTRLU><DELAY:1><ACTIVATE2:"Add your spreadsheet window name here"><WAITLM:000010000000><CTRLD><TEXTTYPE:v><CTRLU><DELAY:1><TEXTTYPE:<ENTER>><ACTIVATE2:"Add your form window name here">

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...