I am looking for a way to open Excel file in read mode with specific column filtered by keyword. File has all columns setup a filters already. I cannot modify this file, it is available for me as read only. I know about /r switch, but not sure how to complete the task.

Thank you,

Hi AP2015,

According to your description, my understanding is that: you want to get a solution to open the excel file from command-line switch with parameters, and the excel file was opened in read-only mode that has already been filtered by keyword (e.g. A)?

If yes, you can get the result with Script or PowerShell.

If my understanding is incorrect, could you be at bit more precise explain your problem so that we can get more accurate solutions to this problem. I am glad to help and forward to your reply.

Regards,