D
delaney
I have a workbook with a pivot table, I write an Access query to a shee
in the work book from Access and the sheet in the workbook updates th
pivot table. So far so good. It only works if I write the sheet wit
the workbook closed and then open it from Windows. If I try to use th
GetObject method from Access and open the workbook from Access I ge
this message:
'A file named 'Resume.xlw' already exhists in this location'. Do yo
want to replace it ?
I want to be able to flip back and forth from Access and Excel an
update the data,
Any ideas
in the work book from Access and the sheet in the workbook updates th
pivot table. So far so good. It only works if I write the sheet wit
the workbook closed and then open it from Windows. If I try to use th
GetObject method from Access and open the workbook from Access I ge
this message:
'A file named 'Resume.xlw' already exhists in this location'. Do yo
want to replace it ?
I want to be able to flip back and forth from Access and Excel an
update the data,
Any ideas