| 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. Yeah, I don't paste, I have code in office but I wrote this post from home... I have miss 's' letter in my post, my code that goes to error is: Excel.Workbooks(1).SaveAs (pathFileName & FileName & ".xls") Then, who help me? -- ------------------------------------------------------------------------------ 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) | |||
| Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
| SaveAs "subscript out of range" error (COM - SOAP) | Excel Programming | |||
Linear Mode
