Skip to Content
avatar image
Former Member

GUI script to connect Excel

Hi, Friends,

I'm trying to use GUI script for auto-testing and batch update.

I know a bit VBA but have no idea how to get GUI script to connect existing Excel file.

Could anyone share some insights, please?

Really appreciate your help.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Dec 21, 2011 at 04:22 AM

    I found answer from else where.

    use following lines to open excel

    for example

    Set objExcel = CreateObject("Excel.Application")

    Set objworkbook = objExcel.Workbooks.Open("C:\Users\auwedon\Documents\work\Script\WIP\change_customer_group\customer_group.xlsx")

    Add comment
    10|10000 characters needed characters exceeded