The portion of code below uses data in Access to automatically build and format a chart in Excel.
strSourceName = "tblAccessTable"
strFileName = "c:\ExportedChart.xls"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, _
strSourceName, strFileName, False
This works great everytime in Access 97/Excel 97 on a NT 4.0 OS, but I get the following error in Access2000/Excel 2000 everytime it runs on a W2K OS:
"Run-Time Error: '3027': Can't update. Database or object is read-only."
When I try to open Access97 on a W2K operating system, I get the following error:
"Error 3170: Couldn't find Installable ISAM"
I need to keep all the data in Access, but format the worksheet to hold a graph that can be manipulated and emailed. Other than using SnapShot, I wouldn't know how to export Access graphs into a file that can be emailed.
Microsoft has some bulletins on this (Q209943, Q250459,Q169276)but nothing I've tried works.
Appreciate any help anybody can offer. After two days trying and testing to get this to work, I'm at the end of my rope
strSourceName = "tblAccessTable"
strFileName = "c:\ExportedChart.xls"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, _
strSourceName, strFileName, False
This works great everytime in Access 97/Excel 97 on a NT 4.0 OS, but I get the following error in Access2000/Excel 2000 everytime it runs on a W2K OS:
"Run-Time Error: '3027': Can't update. Database or object is read-only."
When I try to open Access97 on a W2K operating system, I get the following error:
"Error 3170: Couldn't find Installable ISAM"
I need to keep all the data in Access, but format the worksheet to hold a graph that can be manipulated and emailed. Other than using SnapShot, I wouldn't know how to export Access graphs into a file that can be emailed.
Microsoft has some bulletins on this (Q209943, Q250459,Q169276)but nothing I've tried works.
Appreciate any help anybody can offer. After two days trying and testing to get this to work, I'm at the end of my rope
