NeVeR

We are using firefox ( and it has to be FF) and when you ctrl+f and find the word it wont let you tab from the word.

I tried this. but it wont work for some reason !!.. thanks tho.

I've a page that has a starting point ,, The word "Mode:" I need macro express to find this word at the start of my Macro so I can start <TAB><arrowdown><tab><tab><tab><paste> etc,, goes on a bit..

The main thing is i need it to find my starting work. Possible?

cheers

Would you be able to post screen shots of each stage. I know it's alot to ask but it's wrecking my head.

Oh i moved the "Repeat End" to the bottom and added a "repeat exit". Just so you know

here's a screen shot of what I have so far.. Nearly sure it's wrong tho.

Once the data is in the clipboard, put it a variable like T1. Then:

Variable Set String T2 = "" (empty)

Repeat Start

Variable Set Integer N1 to position of "status" in T1

If N1 = 0

Repeat Exit

End If

Variable Modify String Delete N1 characters from the beginning of T1

Variable Modify String Delete 7 more characters from the beginning of T1 (to get rid of "status ")

Variable Set Integer N2 to position of first blank space in T1

Variable Modify String append N2 characters from the beginning of T1 to the end of T2

Repeat End

 

When this repeat loop finishes, the numeric strings will be stacked in T2 with one blank space between each string (and after the final string).

I'm at this point below and I cant figure out where to find this. I was in "Variable Modify String" and selected D2Delete Part of Text" but i cant sent anything to T1

Variable Modify String Delete N1 characters from the beginning of T1

Same with this.. No idea where i enter 7.

Variable Modify String Delete 7 more characters from the beginning of T1 (to get rid of "status ")

I'm been trying to figure this out for a few hours but cant!!

I have created a menu with about 15 options on it. Each option has a Tick box beside it.

What i want it this.

When someone selects a tick box (most people will be selecting more then 1) if copy's the info listed in each tick box and at once all items are selected and the OK button is pressed it opens Notepad and copies the info I wanted in the correct place. I know hop to get note pad opened and normally i use a text type command and %T1% %T2% to place my copies text. But how to I assign the %T1% %T2% extra to my Tick boxes

Sample

Daily task

Entering orders [ ]

Picking Orders [ ]

Invoicing Orders [ ]

Staff training [ ]

Cleaning Showroom [ ]

Filing [ ]

[OK]

lets say I entered orders and did filing and select them and press OK

Then note pad opens and types out

Daily Tacks

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

Name: My name ( I can do this not a problem)

Date: todays date (Again i can do this_

Today Duties: (This is where i want the list of selected tasks to appear) -- I cant do this part

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

End

Any help would be great.

Highlighting the text is not a problem. It's the actions after it I need help with.

Sorry for the delay in getting back to you.

I've attached an image of what i would be copying.

Here is a copy and paste of the info.

Accounts  	Devices
In Common 	Other
Devices 	Associated
Accounts 	Device
Exceptions
status 14770512 	7 	0 	5 	1
status 14807254 	2 	3 	5 	0
status 14828829 	2 	2 	5 	0
status 9262022 	1 	2 	1 	0
status 11934759 	1 	0 	3 	0
status 14947735 	1 	5 	3 	0

Please look at both so you can see the word "Status" is not in the screen shot , The green circle is in it's place. I didnt remove anything this is how it copies.

The info i need to extract from this is the 7 or 8 digit code after the word status.

Also in the above sample there is 6 lines this could be any amount,

The goal at the end is to have those 7/8 digit numbers saves into a CRTL+(anything) key so i can paste them into another program.

Thanks for the help.

As the title says i'm trying a new macro where I high light a block of text, the macro removes what i dont need and then copies what's left and let me paste it where i need.

I know some of you might say why am i copying it to begin with,, but i dont have a choice.

I''m copying this info from a website.

All I need are the numbers from the 1st column, But there are 5 colume's most have a single digit in them, Some have 2 digits.

Also the word "status" comes up in front of the numbers i need.

I need the macro to copy all of it.. remove that i dont need and leave me with what i need.

Does anyone know what i can do ?.

Not sure that this will help, but there are built in keyboard shortcuts in Excel that might at least allow a brute force solution.

 

For example, to switch between worksheets, use Ctrl + PageUp and Ctrl + PageDown. If the four spreadsheets are kept as four worksheets in the same file, you could script something like this that would always go to the leftmost worksheet:

 

Type Text <CONTROL><PAGEUP>

Type Text <CONTROL><PAGEUP>

Type Text <CONTROL><PAGEUP>

Type Text <CONTROL><PAGEUP>

 

And then, to switch to the second:

 

Type Text <CONTROL><PAGEDOWN>

 

You can switch between different spreadsheets with Ctrl + F6 and Shift + Ctrl+ F6.

Thank you for your reply.

This wont work as each spread sheet is a different file. All 4 are not on different pages.

What i've done so far is put in a stop command and continue on Key press. Also a text pop up informing the user to open the 2nd sheet and press "shift" to re-start the macro.. and then again for the 3rd and 4th. which is working at the moment. But been able to have it do it all on it's own is the goal.

Thanks for the reply.

Not sure about the Excel questions. Perhaps others can help.

 

 

When you use Text Type Ctrl+N you are sending Ctrl+Shift+N. This is what is sent:

<Ctrl Down>
<Shift Down>
n
<Shift Up>
<Ctrl Up>

Change your Text Type to Ctrl+n. (Use lower case n!)

Thanks this did work.

Cheers

Hi all.

I'm trying to make a Macro that copies information from 4 different Excel sheets and then pastes it into a notepad file.

I've it working on 1 spread sheet. But it's getting the other 3 to work as well is the problem.

This infomation/spread sheet will change in name and info each day. I hope you know that i mean. This is a daily task under taken by a member of staff each day and each spread sheet is save under a new name each day (4 each day)

Is something like this possible where it will open 4 spread sheets ?. Or would something like a key press on each spread sheet to activate work better ?.. Like you get a prompt saying "Open SS 1 and press Enter" once copied you get another saying " Open SS2 and press Enter" and so on.. Once the 4th is done you get your Notepad open with the info.

Sorry if this sounds all over the place.

Also how to I get Macro Express to start a new mail in Microsoft Express... The comand in Microsoft Express is CRTL+N but anytime i try it Macro express it opens a note .. which is the short cut CRTL+SHIFT+N but i'm not pressing that.

Any help would be great. thanks.