How to Open an excel file by specifying the Path, and file Name as strings

excel
macro

#1

Hi,
I am picking the path and file name of my excel from a config excel file, and have successfully stored both the path and filename in 2 string variables. In the Excel Application Scope Activity, I pass the concatenated string so that excel can open the file. But I am getting an error, “Cannot convert String to Excel.Application.scope type”. Please guide me on how I can achieve this.
Thanks


#2

using a sting variable in the path field should work… maybe you can post the xaml or screenshot of the variable and how you used it?


#3

Hi @AlexJank , I tried the same thing in a fresh project by copy pasting the Activities from my faulty project and it worked. This is sometimes so weird. I do thank you for assuring me it will work that prompted me to try again :tired_face: