Advertisement

07.25.2008 at 09:57AM PDT, ID: 23596110 | Points: 500
[x]
Attachment Details

Need to edit VBA code to work in new Excel 2007 enviornment

Asked by oraclexview in AutoCAD Software, Microsoft Excel Spreadsheet Software, VB Objects

Tags: , , ,

I currently have a VBA module code that was written to add data from an AutoCAD 2002 DWG file to a Microsoft Excel 97-2003 format file.  Now that our office is being upgraded to Microsoft Office 2007 (thus using Excel 2007) the code needs to be edited to automatically save the Excel workbook as a 2003 compatiable format using the Excel 2007 enviornment.  How do I do this?Start Free Trial
Attachments:
 
NBAddrExtract.zip (32 KB) (File Type Details) 
This is the AutoCAD vba file that is the subject of issue. In the zip file is a TXT format file. Change extention to DVB to look at code in AutiCAD vba.
 
[+][-]07.25.2008 at 11:02AM PDT, ID: 22090873

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.25.2008 at 12:36PM PDT, ID: 22091625

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]08.20.2008 at 09:02AM PDT, ID: 22271117

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628