Hi all,
I am working with several identical time and motion spreadsheets that are updated daily and saved in one folder on a shared drive. What I need to do is write some VBA code to run a daily automated process to import the new data from the spreadsheets into a single access table to enable reporting. The only problem is that I am a VBA newbie and don't really know where to start!
If anyone could help me with this I would be very grateful?
Many thanks
I am working with several identical time and motion spreadsheets that are updated daily and saved in one folder on a shared drive. What I need to do is write some VBA code to run a daily automated process to import the new data from the spreadsheets into a single access table to enable reporting. The only problem is that I am a VBA newbie and don't really know where to start!
If anyone could help me with this I would be very grateful?
Many thanks