cleae content from excel using sas - SAS Support Communities

Obsidian | Level 7

Obsidian | Level 7

cleae content from excel using sas

Posted 08-18-2019 04:25 PM (876 views)

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!

1 REPLY 1

PROC Star

Re: cleae content from excel using sas

Posted 08-18-2019 07:21 PM (855 views) | In reply to sam1231

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

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Call for Content EXTENDED

Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.

Submit your proposal!