I am getting a run time error 9-subscript out of range while executing an excel macro file.How may i eliminate it?


#1

strong text


#2

Hi,

This error due to some object which you looking from your script is not available in the excel.
Better share your script here, so that we can identify the issue.


#3

Macros.zip (20.0 KB)


#4

@sarathi125 ??


#5

Hi, Checked the excel file and the .vbs script as well. you are referring Y, D and F drives, ensure that all are available. and remove space in the folder names.