Forum Discussion

lars_kralemann's avatar
lars_kralemann
New Contributor
12 years ago

Errror message while calling command 'DDT.ExcelDriver'

Hello!



Since last week I get an error message 'VBScript runtime error. Unspecified error' when I'm calling the command 'DDT:ExcelDriver'.

Until this time I never had problems calling my Excel files.

I'm working on Windows XP SP3, no changes on my system except the usual Windows Updates. Could this be a possible reason?

Error appears with version 9.30.3373.7 and 9.31.3889.7.



Anyone who can help me?

Thanks in advance

Lars

4 Replies

  • fayrehouse's avatar
    fayrehouse
    Frequent Contributor
    12 years ago
    Can you paste a bit of your code, where the error occurs?  Might help folks to spot something :)
  • lars_kralemann's avatar
    lars_kralemann
    New Contributor
    12 years ago
    Hi again!



    Here are a piece of code:



    Sub Testrun



    projDataPath=ProjectSuite.Variables.VariableByName("projData_path")                               

    ExcelDriverPath = projDataPath+"DB_Chk_Combination1.xls"                            

    Call DDT.ExcelDriver(ExcelDriverPath,"Sheet1")



    While Not DDT.CurrentDriver.EOF                    Aliases.CardDesigner.editors.TagValue.coBox_Combination.ClickItem(DDT.CurrentDriver.Value("Combination"))

    Call  DDT.CurrentDriver.Next()

    Wend

    DDT.CloseDriver(DDT.CurrentDriver.Name)  

     

    End Sub



    The error occurs when calling "Call DDT.ExcelDriver(ExcelDriverPath,"Sheet1")". The pathes are correct, I checked it several times!

    Regards

    Lars
  • karkadil's avatar
    karkadil
    Valued Contributor
    12 years ago
    Is it possible that variable projData_path doesn't have trailing backslash character?
  • lars_kralemann's avatar
    lars_kralemann
    New Contributor
    12 years ago
    When I define a wrong path or Excel file name I get an 'Excel worksheet does not exist' error.

    After I correct the values the error mentioned above appears again....