Here's the trick I wanna pull.
We're trying to get dual reporting out of our paperflow here. People working in a project have to report Actuals to the Project Manager who keeps his project-file updated and they have to fill in an Excel-file for themselves that goes to the financial dept.
What I want to realize is a macro that fills in an Excel-sheet (The time-sheet) with the Actuals from the given resource from the project-file. I found nearly all my parameters in the Projectfile and I know how to fill in an Excel-file, but in VBA I haven't got a clue how to link the both together. I would like to make the calculations, then open an Excel file and fill that up with the results from my calculations ... Who can help me ?