cleae content from excel using sas

[sam1231]

Hi All,

Can i clear tab content using DDE SAS or VBA SAS? 

Which function should i use?

I dont want to delete tab. i just want to clear content in particular range R7C1:R100C10

Thank you all!

[SASKiwi]

This post maybe helpful regarding VBA: https://communities.sas.com/t5/Integration-with-Microsoft/Execute-Excel-VBA-Macro-using-SAS/td-p/372...