Hey,
I have an Access form that I use, among other things, to output the results of a query to a specified workbook in Excel. My workbook originally has a macro that cleans up the data and formats it nice and neat. The problem is, when the OutputTo method in my Access code executes, the macro in my Excel workbook is erased / overwritten; at least, that's what it appears to be. Is this in fact a downside of using the OutputTo method, and if so, how can I get around it?
I've had great responses from lots of people on here during the past couple of weeks; thanks for your assistance.
Shaun
I have an Access form that I use, among other things, to output the results of a query to a specified workbook in Excel. My workbook originally has a macro that cleans up the data and formats it nice and neat. The problem is, when the OutputTo method in my Access code executes, the macro in my Excel workbook is erased / overwritten; at least, that's what it appears to be. Is this in fact a downside of using the OutputTo method, and if so, how can I get around it?
I've had great responses from lots of people on here during the past couple of weeks; thanks for your assistance.
Shaun
