Saving specific Excel worksheets from a given workbook to a new file
PrintOverview
This example VI shows how to remove specific Excel worksheets from a specific workbook, and save the resulting workbook to a different file. This example was made using Active X calls to Microsoft Excel 2007.
Downloads
Filename: excelexample.llb
Requirements: View
1. Open Excel in the background, invisible to the user.
2. Hide warning from excel that data will be deleted.
3. Open Excel workbook from the specified location.
4. Delete the specified worksheets in the opened workbook.
5. Save modified workbook to another location, preserving the original.
6. Quit Excel and handle any errors.
Requirements
Filename: excelexample.llb
Software Requirements
Application Software: LabVIEW Base Development System 8.6
Additional Software: Microsoft Excel
Reader Comments | Submit a comment »
Legal
This example program (this "program") was developed by a National Instruments Applications Engineer. National Instruments does not support this code or guarantee its quality in any way. THIS EXAMPLE PROGRAM IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND AND SUBJECT TO CERTAIN RESTRICTIONS AS MORE SPECIFICALLY SET FORTH IN NI.COM'S TERMS OF USE (http://ni.com/legal/termsofuse/unitedstates/us/).