I have a report in my database that has a Select query as its record source. I would like to create a button on the report that launches an existing Excel worksheet On_Click. The worksheet will be a Cost/Benefit analysis, and I'm choosing to do this in Excel in order to to give the user the option to evaluate their options and get instant results. When the user closes the worksheet, I will have a macro that gives them the opportunity to Save As...
Of the 22 fields in the query, only about 9 have any relevance to the Cost/Benefit worksheet. I would like to pass specific fields from Access to specific cells in Excel. I'm new to this type of operation, so I don't have any code put together, although I have seen some elaborate snippets of code on this forum. Most are too involved for what I am trying to do, so it's tough for me to edit down to only what I need when I'm not sure what that is.
Can anybody point me in the right direction? DoCmd.TransferSpreadsheet seems a little heavy-handed for what I'm trying to do. All comments welcomed.
Of the 22 fields in the query, only about 9 have any relevance to the Cost/Benefit worksheet. I would like to pass specific fields from Access to specific cells in Excel. I'm new to this type of operation, so I don't have any code put together, although I have seen some elaborate snippets of code on this forum. Most are too involved for what I am trying to do, so it's tough for me to edit down to only what I need when I'm not sure what that is.
Can anybody point me in the right direction? DoCmd.TransferSpreadsheet seems a little heavy-handed for what I'm trying to do. All comments welcomed.