Hey guys, first of all hi to everyone and thanks in advance for taking time to read this.
So I'm at a new job, and need to generate an automatic access file that updates itself everytime a new excel file is added to certain folder (the access takes the info from the excel). I couldn´t manage to do this, so what I did was create a macro that runs
extracting info from the one and only excel file which will be overwritten whenever someone wants the database to be updated. That´s the minor problem, but I can go by with what i have, in lack of a better solution.
The thing is, i need this to be done automatically, so i found out the way to do this is with microsoft task scheduler ( i cant install a third-party program in this computer), which would run a task triggered by a modification in a folder. Up to what i
understood, this is done with microsoft powershell, but i don´t know much about coding, so I can´t come up with my own. So the steps are to write a script in powershell, and then link the scheduler with it, right? I hate to throw it like this, but could someone
write the code for me?
Thank you so much,
Marcos
