w3hello.com logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML videos Categories
Excel - VBA - Call path of excel object or current excel.Appliation

The Application 's .Path property is not what you want.

YOu have declared timeXLS as an instance of Excel.Application.

vFiles(iFile).Path

vFiles is an array/variant, not an object. Combine the two methods (you're close!) because .Path is a member of the Workbook object, try instead:

REVISED

... = timeXLS.Workbooks(vFiles(iFile)).FullName





© Copyright 2018 w3hello.com Publishing Limited. All rights reserved.