04-22-2015, 12:18 PM
Ah ok this is down a different route to what I had initially mean sorry.
I've got a table which houses staff names and then runs a macro in another prograam (already made and made) when it realizes which name is selected. the names will change on weekly basis so I had initially thought of something like
Basically if one of the boxes is blank I want it to skip to another part in the macro/ I know this isnt efficient coding but i like to start at basic and build on it ha
I've got a table which houses staff names and then runs a macro in another prograam (already made and made) when it realizes which name is selected. the names will change on weekly basis so I had initially thought of something like
#region Recorded 22/04/2015 13:12:30
int w1=act(win("Book 2.xlsx - Excel" "XLMAIN"))
setting my str variables
str m1
str m2
str m3
str m4
str m5
str m6
str m7
copies the 7 boxes i need
lef 136 251 w1 1 ;;EXCEL7 'Book 2.xlsx'
'D Cc
m1.getclip
'D Cc
m2.getclip
'D Cc
m3.getclip
'D Cc
m4.getclip
'D Cc
m5.getclip
'D Cc
m6.getclip
'D Cc
m7.getclip
if m5 = ""
goto errorBasically if one of the boxes is blank I want it to skip to another part in the macro/ I know this isnt efficient coding but i like to start at basic and build on it ha
