Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Quick Help please
#3
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

Code:
Copy      Help
#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 error

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


Messages In This Thread

Forum Jump:


Users browsing this thread: 1 Guest(s)