Use excel file issue with linked file

Help Studio
1

I’m trying to use excel file to open a workbook, but the workbook is linked to another workbook that has a password. the use excel file opens the first/main workbook, but then prompts for the password for the linked file. How can I access this password pop-up in the new version? (not legacy)

I’m using an ExcelProcessScopeX, within that the ExcelApplicationCard with the info for the main workbook. It opens the main workbook and a password window pops up for the linked workbook. This is where it just “hangs”.

I tried using a Check Application State (NCheckState) within the application card, but it does not get this far because it is hanging on the “open”.

If I move the NCheckState within the ExcelProcessScopeX, before the ExcelApplicationCard , it displays an error “Argument ‘InScope’: BC30451: ‘Excel’ is not declared. It may be inaccessible due to its protection level. Variable ‘InScope’ is missing. Please use Data Manager to recreate it.” I don’t see where there is a variable ‘InScope’ nor the term ‘Excel’ within the NCheckState properties.

So, this does not appear to work

How can I trap the pop-up password box and enter the password?

Forum Engagement Daily Reports
2

@Av8r_Dave

Use a parallel activity with excel process on roght and password pop up on the left

Cheers

1 Like
Forum Engagement Daily Reports
3

couldn’t get this to work. alternate solution is to open the linked workbook before opening the main one, then close the linked one

1 Like
Forum Engagement Daily Reports
4

@Av8r_Dave

Not sure what you tried inparallel..but glad you were able to resolve

Cheers