Referencing Excel Sheets

• robkmon

  SSC Enthusiast

  Points: 110

  More actions

  July 25, 2008 at 9:10 am

  #188586

  I am trying to reference an excel spreadsheet in VBA inside a script task within SSIS, but I don't know how to specifically reference cells inside my code. I basically just want to bring in text from the spreadsheet into variables to avoid hard coding each line in VBA.

  Any help is appreciated.

• Chuck Rivel

  SSCrazy

  Points: 2991

  More actions

  July 25, 2008 at 12:36 pm

  #848647

  i took a look around and came across this blog post that looks to be stating what it is you are trying to achieve:

  http://lorentsnv.spaces.live.com/blog/cns!235C78448ABCFC07!178.entry

  hth