Excel to Access using VBA
Hello,
We are in the process of making cycle times to see how long it takes to
complete a task. We have all of our forms in Excel, so people can choose
which tasks that want to perform. When done, they click a button on Excel and
it generates a spreadsheet for them.
We have been assigned a new task to actually grab these numbers. I am
wondering if using Excel Automation to Access is the proper way to go about
this. What I was thinking is grabbing the test number and the start date from
Excel and place these in a Access table I have created called tblExcel. By
the way, all our generation is by Excel VBA.
Any advice is greatly appreciated.
|