GUI script to connect Excel

[Former Member]

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.

[Former Member]

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")