Updating MS Excel tabs and specific cells

[ak_8]

Hello everyone,

We have "client_server" environment and our goal to automate updating multiple excel tabs and specific cells using EG.

When i had standalone license, it was easy to do using X window but since X windows disabled on the production server, I cannot do.

So i tried to use ODS which gives you flexibility (start_at, tab name) but the problem is that it generates new one and overwrites existing file so I cannot update per se.

Does anyone have any idea how it could be resolved?

Thank you!

[Reeza]

Try the macro here:

http://www.sascommunity.org/wiki/A_Poor/Rich_SAS_Users_Proc_Export

It's custom written by SAS users on here.

[ak_8]

Thank you - it does not work, i found this paper
https://communities.sas.com/t5/General-SAS-Programming/Updated-exportxl-macro-now-available/td-p/191...

where it was referenced, tried - no results

[Reeza]

---

@ak_8 wrote:
Thank you - it does not work, i found this paper
https://communities.sas.com/t5/General-SAS-Programming/Updated-exportxl-macro-now-available/td-p/191...

where it was referenced, tried - no results

---

What did you try and what does no results mean?

It is designed to work on a server as well.