The fast way to solve this issue is to create a new action to handle with your read-only excel file.
You can follow the steps below.
1. Go to "Open Workbook" page and duplicate it.
2. Go to "Open Workbook - Copy" page and open the "Open Workbook" code stage.
3. Replace the code by this code below and rename this stage and page
Dim wb as Object = GetInstance(handle).Workbooks.Open(FileName:=filename,ReadOnly:=True)
name = wb.Name
wb.Activate()
4. That's all. And you can public this page and use it.
Or you can add any parameters if you need them to do some excel manipulation.
Example
Dim wb as Object = GetInstance(handle).Workbooks.Open(filename,UpdateLinks:=updatelinks,ReadOnly:=readonly1,Password:=password,WriteResPassword:=writerespassword,IgnoreReadOnlyRecommended:=True)
name = wb.Name
wb.Activate()
--
If my memory is correct, I remember in the old MS Excel VBO version is using "GetInstance(handle).Workbooks.Open" method to open excel file.
But I don't know why BP changes this way to open excel file in new version. (It uses the private function called invoke which is defined by global code to open excel file now. I don't know how to pass more than one parameter to this method.)
------------------------------
Chenglung Tsai
Consultant
Avanade
------------------------------
