Need help for Excel Recorder


#1

Hi

I have created one excel using AssistEdge RPA community. I am reading data from application screen (suing copy operation) and putting it in excel. I have attached excel screen shot along with this.
Now I want to run a simple macro, which will populate cell E1 by multiplying value of Column C1 with 100 i.e. E1 = C1 X 100.
In order to achieve this I have used “Excel Recorder” feature. But I am getting error when I run the process, the error is,
Run-time error ‘1004’: Method ‘Range’ of object ‘_Global’ failed.
I have attached the error details and script generated.
Below are the values of arguments,
rangeArg1 = E1
FormulaArg1 = RC[-2]*100
rangeArg2 = E2
FormulaArg2 = RC[-2]*100
rangeArg3 = E3
FormulaArg3 = RC[-2]*100

Could you please help me.

Regards
Shailendra
+91 9921309130


#2

Hi,

There is issue in your macro script. Are you modifying it manually

Regards,
Amit


#3

Hi Amit

Thanks for your response. I am not modifying the script. Below is the sequence of events I am doing,

  1. When I start “Excel Recorder”, a file with name, “ScriptStore.xlsm” opens. The file is completely empty.
  2. I switch to my excel with data. Then I click Record Marco. The “ScriptStore.xlsm” file gets activated and the Macro Dialog box comes and goes off.
  3. Since my data is in another xls, I switch back to my excel with data. I perfom calculations mentioned in my first mail and stop the Macro.
    I have recorded another macro with above steps. Below is the script generated,
    Sub Script_08_08_39_02_04_2019(Parameters As Scripting.Dictionary)

    ’ Macro17 Macro


Windows(Parameters.Item(“activateExcelArg1”)).Activate
Windows(Parameters.Item(“activateExcelArg2”)).Activate
Windows(Parameters.Item(“activateExcelArg3”)).Activate
Windows(Parameters.Item(“activateExcelArg4”)).Activate
Windows(Parameters.Item(“activateExcelArg5”)).Activate
Range(Parameters.Item(“rangeArg1”)).Select
Windows(Parameters.Item(“activateExcelArg6”)).Activate
Windows(Parameters.Item(“activateExcelArg7”)).Activate
ActiveCell.FormulaR1C1 = Parameters.Item(“formulaArg1”)
Range(Parameters.Item(“rangeArg2”)).Select
ActiveCell.FormulaR1C1 = Parameters.Item(“formulaArg2”)
Range(Parameters.Item(“rangeArg3”)).Select
Selection.AutoFill Destination:=Range(Parameters.Item(“rangeArg4”)), Type:=xlFillDefault
Range(Parameters.Item(“rangeArg5”)).Select
Windows(Parameters.Item(“activateExcelArg8”)).Activate
End Sub

But now I am getting below error,
Run-time error ‘9’:
Subscript out of range.

Regards
Shailendra
+91 9921309130


#4

Hi,

You don’t have to click on Record macro. Just click the record button in excel recorder and open excel and perform your steps. Once done click Stop recording

Regards
Amit


#5

Thanks for you reply. I am not recording Macro. I am using Excel Recorder only.

Regards
Shailendra
+91 9921309130


#6

By mistake I mentioned Record Macro in my reply. I am clicking on Excel Recorder only.

Regards
Shailendra
+91 9921309130


#7

Hi,

First record a simple script.may be setting value in a cell. See if you are able to run it

Regards,
Amit