Change the source file name at run time

• RMK

  Grasshopper

  Points: 19

  More actions

  April 6, 2006 at 2:40 am

  #67251

  Hello,

  I have several excel files of the same format, same table format, but with different values. The table names and columns are exactly same.

  Now i want to change only the name of the files and the data to be transformed.

  What could be the best way to change source file name at run time.

  please help me..

   

  Thanks in advance.

• gshouse

  Say Hey Kid

  Points: 664

  More actions

  April 7, 2006 at 8:03 am

  #631494

  I'd use an ActiveX script

  set oConnection = oPackage.Connections("ConnectionName")

    oConnection.DataSource = "FileName.xls"