Passing Parameters values through Action Button

[Abinaya]

Hi
I am using Action button to pass parameters from Source.xls file to Target.xls file. But Target.xls is not showing any values.

Action: Goto another Worksheet

Process tab: Get Process info from Worksheet option selected

In the advanced Option

I have given Source Type: Value Source Object =A3
Target Type: Range Target Object =A3

Calculation: None

This just passing a value from Cell A3 Source.xls to Cell A3 Target.xls

regards,

Abi

[rmackenzie]

I have given Source Type: Value Source Object =A3
Target Type: Range Target Object =A3

I you enter just A3 (instead of =A3) in the target then I think this will work.

This is because you want the value in A3 in the source to be the value in A3 in the target. NOT that you want the value in A3 in the source to be the value of whatever cell is specified in A3 in the target.

[Abinaya]

Thanks. It worked.