Unable to use variable when connecting to database

Hi @Steven chev​ ,

Could you try displaying that filepath in a message box, just to see if there are any issues with it?

Kind Regards,

Ashwin A.K

Hi @Steven chev​ ,

We can use the variables, as Ashwin suggested can you check the path in a message box and let us know the result?

Hi @ChanduMohammad S​ 

Thanks for chiming in. I have uploaded the results in the post above.

Hi @Ashwin A.K​ 

Thank you for you response.

I have uploaded the photo of the message box to this thread

It looks only 1/3 of the variables are displayed in the msg box. The $Filename$.$Extension$ are the two that are not displayed.

Any suggestions?

see below of error message when running line 2

Hi @Steven chev​ ,

Could you verify whether the folder which you are iterating through contains files other that the excel files you wish to interact with?

Try this, add an If Command and only connect to Excel if the $Extension$ = xlsx.

That ought to do the trick.

Kind Regards,

Ashwin A.K

Hi @Steven chev​ ,

This is the issue, check why the values are not getting passed correctly to this variable you will get connected to the Database.