I know Excel can run my VBA code every 1 hour automatically by putting the code in the event Workbook_Open, just have my code including the line like Application.OnTime...
Can Access achieve this? Does Access have the mothod like OnTime?
I currently have this requirement from my users says "pls let let Access to import Excel data outside into Access every 1 hours AUTOMATICALLY instead of let me just click the button in the screen."
Anyone pls help to comment.
Thanks in advance,
Tim
Can Access achieve this? Does Access have the mothod like OnTime?
I currently have this requirement from my users says "pls let let Access to import Excel data outside into Access every 1 hours AUTOMATICALLY instead of let me just click the button in the screen."
Anyone pls help to comment.
Thanks in advance,
Tim