Old JChem 4 Excel function not working

Hi All:

I have some existing codes (see below) that now do not work with new JChemForExcel (1.1.2). Specifically, calling jchemExcel.ImportFile(file, sheet.Name) no longer works. Does anyone know if this function still supported. If not, what is the replacement new function?

Thanks,

Tom

===================================================

    Dim file As String
    Dim wb As Workbook
    Dim sheet As Worksheet
    Dim addin As Office.COMAddIn
   
    Set addin = Application.COMAddIns("JChemExcel.Functions")
    Set jchemExcel = addin.Object
   
    'Open another workbook and make the 1st sheet active
    Set wb = Workbooks.Add
    Set sheet = wb.Sheets(1)
    sheet.Activate
   
    ' Hide the metadata row by setting the height to 0
    sheet.Rows(2).rowHeight = 0
       
    ' Find the ChemCart path.
    file = ChemCart.GetPath
       
    If Len(Dir(file)) > 0 Then
        ' Import the file, delete, then close this book
        bRet = jchemExcel.ImportFile(file, sheet.Name)

        ChemCart.applyFieldOptions
        Kill file
    Else
        'Display error
        MsgBox "SDfile to import (" & file & ") not found."
       
    End If

 

 

Hi,

the API was not official in the previous versions (we have just included it as an example for you :)).

The new method name for the import from file function is (C# header):

ImportFromFile(string fileName, object workbookName, object worksheetName, object append)

Only the file name is mandatory. If the workbookname and worksheetname is not specified, it will import into the active ones. The append option does not work yet.

 

In 1.1.3 we are going to officially publish the APi together with documentation, and sample code in Java, .NET and VBA.

However from now on the interface is going to be backward compatible.

 

Regards,

Tamas.

 

 

Please visit our download side:

https://www.chemaxon.com/download.php?d=/data/download/jchem4xl/JChem_for_Excel_API_Guide.zip

 

containing some example how our new official API itnerface works.