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

Help
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.

1 Like