Hi - I have to upload a lot of files in my system for some simulation. I am very new to VB code so looking for help.
1) I have 20 files in a folder and all named as Day1, day2, day3.... I need a VB code which upload these files 1 by 1 and also run some macros (mac1, mac2 etc) each time the new files is uploaded
2)In my current system, I use the Now() to record the day the file was uploaded. Since my simulation is based on this day. I want the above code to manipulate the date - It can have for day1 as Jan1, day Jan2 etc
Please guide
1) I have 20 files in a folder and all named as Day1, day2, day3.... I need a VB code which upload these files 1 by 1 and also run some macros (mac1, mac2 etc) each time the new files is uploaded
2)In my current system, I use the Now() to record the day the file was uploaded. Since my simulation is based on this day. I want the above code to manipulate the date - It can have for day1 as Jan1, day Jan2 etc
Please guide