Hello. I want to use the "set sheet name" in one of Our robots because many other range finders are depending on a specific sheet name.
This is because sometimes People in Our Company uses other names for "sheet 1" in their spreadsheets.
However: When i use the step, it creates a range finder on that specific sheet name. So the NeXT time i use it on a different sheet name again, it wont work, because the finder was set at the first sheet name.
I found this information: ""Specify (in Range) a cell or range of cells using almost ordinary Excel syntax. Keep in mind that (in contrast to Excel) the sheet name must be given.""
Does this means i cant use a range like this: '.*?'!
See Pictures:
Many other finders in the robot are dependent on the sheet name to be names "Posteringsbilag"
This is because sometimes People in Our Company uses other names for "sheet 1" in their spreadsheets.
However: When i use the step, it creates a range finder on that specific sheet name. So the NeXT time i use it on a different sheet name again, it wont work, because the finder was set at the first sheet name.
I found this information: ""Specify (in Range) a cell or range of cells using almost ordinary Excel syntax. Keep in mind that (in contrast to Excel) the sheet name must be given.""
Does this means i cant use a range like this: '.*?'!
See Pictures:
Many other finders in the robot are dependent on the sheet name to be names "Posteringsbilag"