>>>>>How does one give a meaningful name to a workbook via automation?
>>>>
>>>>
oSheet.Name = "New Sheet Name"
>>>
>>>The workbook, Sergey - not the individual sheets. I've got that one done ;-)
>>
>>Sorry, I wasn't sure
oWorkbook.SaveAs("H:\temp\New Workbook Name")
>
>Okeedokee, that saves it. But I ain't ready yet!
>
>Intellisense gives me an ActiveWorkbook.Name property that all attempts by me to use result in errors. Yet in all my bungling, the property does get set somehow, and the WB name is displayed. Just looking for the correct syntax to set that property?
VB Help says that WorkBooks.Name property is ReadOnly :o((
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.