Need Help with Scripting Import
I am trying to set up a script that will import an Excel file at intervals.
I have a times that will run my import script every 10 seconds.
The problem I have is in selecting the file for the script to import. The file is new each day and named for the date
I tried to figure out the set variable option to do Get(Current Date) but it only seems to pull in 2011 and fails to open the file.