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

strong text


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.

Macros.zip (20.0 KB)

@sarathi125 ??

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.

1 Like