Setting variable as a network path

[Jak82]

Hi,

We have daily output files which, output to a folder on a network drive , file example.... "20230215 CRM.xlsx"

I am wanting to bring in that days file and combine it with another file.  

How do I go about adding a variable as a file path?

Thanks

Chris

[Zok]

You can check this thread I just answered, one solution is changing the path name

[Jak82]

Hi Zok,

Thanks for feedback.

I have done the following but get the error

Error: Dynamic Input (118): Error opening table: Microsoft Access Database Engine: Syntax error in FROM clause.\3000 = -526912946

Thanks

[Felipe_Ribeir0]

Hi @Jak82 

Usually this error is related with wrong paths going to the dynamic tool.

This seems to be the case, you cannot pass folders after the filename (like MA.xls/Data)

[Jak82]

Hi Felipe,

I have tried with and without and it gives the same error.

I thought that was referring to the sheet in the tutorial I was using.

It still doesnt work though ..in or out

Thanks

[Zok]

try |||data instead of /data

[Jak82]

Tried that and

'|||data'

'|||data$'

Also have tried without and having the sheet in the template in the dynamic tool.

Still no joy. 

[Zok · Accepted solution]

Why are you using dynamic input ?

I thought you wanted to outpout data in a file

Ok, I took a closer look, didnt understand

Try "Change entire path name" in Action

[Zok]

and not sure about .xls since it is .xlsx for a while

[Jak82]

Thats perfect.. thank you