subscript out of range

**josros60** · 01-16-2013, 04:27 PM

I have a spreadsheet in excel named "writeoff" and I print every month a report from a website in excel format.
then i have a macro to link the report printed from website by the way name of file is "ReportProxyServlet" to cells on writeoff sheet by account number.

But every time i run the macro I am getting this error "run time error 9, subscript out of range".
I am attaching the two files.

here it's the code:

Please Login or Register  to view this content.

thank you

**6StringJazzer** · 01-16-2013, 08:08 PM

The workbook ReportProxyServlet is not open when you run this macro. If this file exists you need to open it first to be able to refer to it in the Workbooks collection.

Modify your code to look like this. This assumes that the file is in the same folder as this workbook. If not, modify the call to Open to include the correct path:

Please Login or Register  to view this content.

**josros6074** · 01-17-2013, 02:15 PM

Thank you.

I modified with your suggestion don't get error anymore but the amounts from "ReportProxyServlet" report doesn't transfer to column e on "WRITEOFF" worksheet.

for exam writeoff sheet has a column with account numbers that match ReportProxyServlet accounts number, so I want the macro to look for the accounts # that have amounts to transfer to writeoff sheet.

thanks again.

**josros6074** · 01-17-2013, 03:58 PM

I thought about it, and i think what need help is in the same code to add vlookup function to look for the account find the amount and post it to to writeoff she in the in the right cell.