varArray = Split("C:\New folder\text.xlsx|D:\New Folder\text1.xlsx|E:\New
folder\text2.xlsx", "|")
Set objExcel = CreateObject("Excel.Application")
For lng = LBound(varArray) To UBound(varArray)
Set objWorkbook = objExcel.Workbooks.Open(varArray(lng))
For Each wks In objWorkbook.Worksheets
wk
Dear All,
Did anyone try this ..
Regards
Yogananda
-- Forwarded message --
From: yogananda muthaiah
Date: Wed, Jan 25, 2012 at 10:06 PM
Subject: VB Script - looping of files
To: excel-macros@googlegroups.com
Dear All
I have 3 excel path mentioned below which needs to be loop
