[reiterjt]

I have a macro that opens a drawing file, activates the BOM, and then writes all the information to a text file. I then have a separate macro in excel that imports the text file for manipulation. How can you combine the steps into one?

I have added the Microsoft Excel 12.0 Object Library reference, which allows normal excel commands such as "Range()" to be accepted. Right now I have the following:

Workbooks.Open FileName:="\\Blgnas\engineering\PROCESS & DESIGN\TEMPLATES\SupplyChainExport.xlsm"

The excel workbook does not visibly open, however, upon trying to open the workbook in excel it says it is already open. The code is successful when used within excel vba, but not SW vba.

Anyone have any suggestions?

[cnc_joseph]

B4 U open u have to create an object.

Set MyExcelApp = CreateObject("Excel.Application")
MyExcelApp.Visible = True
MyExcelApp.Workbooks.Open FileName:="\\Blgnas\engineering\PROCESS & DESIGN\TEMPLATES\SupplyChainExport.xlsm"