- Version
- Download 456
- File Size 14 KB
- File Count 1
- Create Date 01/08/2020
- Last Updated 01/08/2020
Saveas_Excel: uses OLE to save a datawindow to Excel
Pat Madigan Based on code written by Bruce Armstrong
The f_saveas_excel function is a fairly simple method for saving the contents
of a datawindow to an Excel spreadsheet. You just pass in the datawindow as
the function argument, and it will open up Excel with your data in a new
spreadsheet.
Bruce wrote the original code, and added the capability of saving column
names. My only contribution was to remove carriage returns and line feeds
from the data, as this caused problems when pasting data into the spreadsheet,
and I simplified the code to only work for one datawindow at a time.
File | Action |
---|---|
PB_ExcelSpreadsheet.ZIP | Download |
0 comments on “PB Excel Spreadsheet” Add yours →