Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SaveAs "subscript out of range" error (COM - SOAP)
Did you paste that line?
Should be... workbooks(1).SaveAs (pathFileName & FileName & ".xls") workbooks (plural) and you left out the quotes around .xls. -- John johnf202 at hotmail dot com "Matthia" wrote in message ... Hi to all, I receive this error n.9 "subscript out of range" when I try to SaveAs my workbook on other file. I close excel file on my isolated method on COM in visual basic (and then I open my Excel file on other COM method...). If I try these methods by a simple client in VB I don't receive errors, but I must use a java application that communicate with my COM methods via SOAP, then when I use these my COM go on that error. My code on error is: Excel.Workbook(1).SaveAs (pathFileName & fileName & .xls) I don't use my public workbook variable (example: xlWB) because strangely this reference on other methods result Nothing when used on Java - SOAP - COM - Excel, but work great with VB client. Please, help me, thanks to all. -- -------------------------------------------------------------------------- ---- Nick : Matthia E-Mail : IRC Nick : Matthia - Matt_WORK - Mat* ICQ N. Casa : 136775978 ICQ N. Uff. : 133038922 -------------------------------------------------------------------------- ---- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Select method of Range class failed" Error | Excel Discussion (Misc queries) | |||
Create pivot table, error "Range is not valid" | Charts and Charting in Excel | |||
Error Message "Subscript our of range" | Excel Discussion (Misc queries) | |||
Run-time error "1004" Select method of range class failed | Excel Discussion (Misc queries) | |||
Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) |