I am trying to create a summary file that will be used daily for multiple plant summary files. I want to access the shared public drive, which stores the output files in CSV format.
1) Files are dated and stored in a CSV file, daily, for each plant
2) Date format would be...
I have a folder full of files that are extracted from our in house system on a daily basis into a .csv file.
What I need to do is have a code that will convert these all to .xlsx files into a new location every morning.
I don't even know where to start with this. Can anyone help?
I am a newby to programming & need some help with my coding.
Currently, my code involves making a connection to a db then run queries. Results from the queries goes to recordset & from the recordset copy to specified range in excel worksheet. I am trying to do an automation process...