Coding Data Transfer from Access to Excel (Office 95) 
Author Message
 Coding Data Transfer from Access to Excel (Office 95)

Using Office 95 - Access and Excel.  I have created an event procedure
linked to a form button in Access which uses the DoCmd.TransferSpreadsheet
method to export data from a crosstab query to an Excel Spreadsheet.  This
is working.
However, some of the fields in the Crosstab Query are blank - no data for a
particular pair of column and row headings.  Excel displays these as blank
cells, and counts them as blank using the countblank function.
But when the data is plotted in Excel, these cells plot as zeros even though
in the Tools --> Options --> Chart menu, Plot Empty Cells As is set to Not
Plotted (Interpolate).  Any way to force these cells to be empty or null, in
Access or in Excel, so that the blank cells won't plot?  Grateful for any


Tue, 26 Jun 2001 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Coding data Export from Crosstab Query to Excel (Office 95)

2. Access 95 and (Excel 97 and Excel 95)

3. VBA for Excel and other Office '95 apps

4. VBA Excel 7.0 (Office 95) Sources.

5. VBA In MS Excel from Office 95.

6. VBA for Office 95 vs Office 97

7. Office Developer's Kit for Office 95

8. Stored procedures in Access Office 95 and 97

9. Transfer Data From Excel To Access With ?

10. Accessing MS-Office 95 builtin document properties with VB

11. Converting VB code modules in Access 95 to Access 97

12. Export Access 97 to Excel 95 via OLE


Powered by phpBB® Forum Software