S
Scagnetti
I've created a query (see below) in Access 2003 that sums data and returns
one and only one row. I want to transfer that data to a named Excel
spreadsheet but in specific cells. For example, I want to put 'SumOfSalary'
into cell D73, 'SumOfBonus' into cell K78, etc. Can this be done in VBA?
I've been looking at DoCmd.TransferSpreadsheet but I'm not getting very far.
Here is the query:
SELECT Sum(Employee.Salary) AS SumOfSalary, Sum(Employee.Bonus) AS
SumOfBonus, Sum(Employee.ShareOption) AS SumOfShareOption
FROM Employee;
Named spreadsheet: C:\EmpComp.xls
one and only one row. I want to transfer that data to a named Excel
spreadsheet but in specific cells. For example, I want to put 'SumOfSalary'
into cell D73, 'SumOfBonus' into cell K78, etc. Can this be done in VBA?
I've been looking at DoCmd.TransferSpreadsheet but I'm not getting very far.
Here is the query:
SELECT Sum(Employee.Salary) AS SumOfSalary, Sum(Employee.Bonus) AS
SumOfBonus, Sum(Employee.ShareOption) AS SumOfShareOption
FROM Employee;
Named spreadsheet: C:\EmpComp.xls