Hi I’m bills

Playing with numbers

I start with

```
tell application "Microsoft Excel"
activate
open text file filename "x"
activate object workbook "x"
accept all changes active workbook
activate object worksheet 1
```

Then I paste from Excel workbook to script editor

replace range “A1:G1000” of worksheet “Sheet1” what " 101 " replacement " 4 " search order by rows

replace range “A1:G1000” of worksheet “Sheet1” what " 102 " replacement " 17 " search order by rows

replace range “A1:G1000” of worksheet “Sheet1” what " 103 " replacement " 37 " search order by rows

replace range “A1:G1000” of worksheet “Sheet1” what " 104 " replacement " 28 " search order by rows

replace range “A1:G1000” of worksheet “Sheet1” what " 105 " replacement " 34 " search order by rows

Which compiles to:

```
replace range "A1:G1000" of worksheet "Sheet1" what "\t101\t" replacement "\t4\t" search order by rows
replace range "A1:G1000" of worksheet "Sheet1" what "\t102\t" replacement "\t17\t" search order by rows
replace range "A1:G1000" of worksheet "Sheet1" what "\t103\t" replacement "\t37\t" search order by rows
replace range "A1:G1000" of worksheet "Sheet1" what "\t104\t" replacement "\t28\t" search order by rows
replace range "A1:G1000" of worksheet "Sheet1" what "\t105\t" replacement "\t34\t" search order by rows
```

Which does nothing in excel,but if I go into script edit find, \t,leave replace blank and recompile, I get this,which works if Excel find and replace is preset to find entire cells only

```
replace range "A1:G1000" of worksheet "Sheet1" what "101" replacement "4" search order by rows
replace range "A1:G1000" of worksheet "Sheet1" what "102" replacement "17" search order by rows
replace range "A1:G1000" of worksheet "Sheet1" what "103" replacement "37" search order by rows
replace range "A1:G1000" of worksheet "Sheet1" what "104" replacement "28" search order by rows
replace range "A1:G1000" of worksheet "Sheet1" what "105" replacement "34" search order by rows
```

This is step 1

Step 2 replaces 34 with 1034, column G is autosum

Question 1: How do I get script to compile right the first time?

Question 2: How do I set Excel find and replace to entire cells only?

I can do it with case by search for rows with match case,

But does’t compile with match cell

Question 3: How do I search column G for sums>or<than and delete entire row? (this one leaves me totally in the dark)

Thanks for any help

bills

p.s. this is all new to me

.

Model: macbook

AppleScript: 2008

Browser: Safari 525.27.1

Operating System: Mac OS X (10.5)