Reply

Solid edge reports using an excel macro ?

[ Edited ]

 

Is there a code that can be used in an excel macro that will carry out the equivalent of the user(s) selecting a solid edge assembly file..(.asm) then right click with a mouse, and then selecting the command "report" ?

Thanks in anticipation

Nodski

 

Posted by: John Vizi
Post date: 9/6/2010 12:02:31 PM

2 REPLIES

RE: Solid edge reports using an excel macro ?

[ Edited ]

 

Source with attachment' Add reference to "Solid Edge Install Data Type Library (SEInstallData.dll)"' Add reference to "Windows Scripting Host Object Model"Sub Demo() Call OpenInReport("C:\Program Files (x86)\Solid Edge ST3\Training\Coffee Pot.asm")End SubSub OpenInReport(strFile As String) Dim objInstallData As SEInstallDataLib.SEInstallData Dim objFSO As IWshRuntimeLibrary.FileSystemObject Dim objShell As IWshRuntimeLibrary.wshShell Dim strInstallPath As String Dim strReportPath As String Dim strCommand As String Set objFSO = New IWshRuntimeLibrary.FileSystemObject Set objInstallData = New SEInstallData Set objFSO = New IWshRuntimeLibrary.FileSystemObject Set objShell = New IWshRuntimeLibrary.wshShell strInstallPath = objInstallData.GetInstalledPath strReportPath = objFSO.BuildPath(strInstallPath, "report.exe") strCommand = """" & strReportPath & """ """ & strFile & """" ' God I hate VB! objShell.Run strCommand Set objFSO = Nothing Set objShell = Nothing Set objInstallData = NothingEnd Sub

 

Posted by: Jason Newell
Post date: 9/7/2010 4:49:22 AM

RE: Solid edge reports using an excel macro ?

[ Edited ]

Thanks for your response...

Our I.T. man has said I should not mdoify .dll files as it might affect others, ( thought it would only be my pc ).

I am investigating the BOM custom macro within solid edge...This may take awhile !

Thanks again

Nodski

 

Posted by: John Vizi
Post date: 9/20/2010 11:13:38 AM