View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default 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.