Hi,
I have a file in Box that gets updated each month, on a new sheet, with new data. I am trying to pull in a specific, individual sheet by name, to pull off the data. I have tried using the Dynamic Input tool and also tried using a macro, but with both methods, I can't work out how to point to the file I'm pulling in using the Box tool. They both fall over when they look for my Box file in my .temp folder.
Is this possible, and if so, does anyone have any pointers for me please? Thanks
