I'm the first time here , I say everybody a good day
Can somebody please to learn me if ADO
can do an autofill method in a closed workbook ? ...
.... to do in a closed workbook the same action
like in VBA :
Range("B91:B700 0").Select
Selection.AutoF ill Destination:=Ra nge("B91:BB7000 "),
Type:=xlFillDef ault
???This is my first information that I need strongly !
2.The second thing is to know if ADO can do ClearContents in a closed
workbook like in VBA code :
Sheets("1").Ran ge("C91:BB22005 ").ClearContent s,
but with the workbook not open .
Thank you very much ,any sugestion is very
helpfull for me .
Can somebody please to learn me if ADO
can do an autofill method in a closed workbook ? ...
.... to do in a closed workbook the same action
like in VBA :
Range("B91:B700 0").Select
Selection.AutoF ill Destination:=Ra nge("B91:BB7000 "),
Type:=xlFillDef ault
???This is my first information that I need strongly !
2.The second thing is to know if ADO can do ClearContents in a closed
workbook like in VBA code :
Sheets("1").Ran ge("C91:BB22005 ").ClearContent s,
but with the workbook not open .
Thank you very much ,any sugestion is very
helpfull for me .