Desktop productivity for business analysts and programmers

Send to Excel in an existing Excel session

Reply
Contributor EH
Contributor
Posts: 32

Send to Excel in an existing Excel session

[ Edited ]

Hello all,

 

I often use Send to Excel to export my output dataset for further use in Excel. EG then starts a separate session of Excel, also when Excel is already open. Is it also possible to Send the output to a new Workbook in an existing Excel session? I am running EG 6.1.

 

When having two separate Excel sessions, I cannot use copy - paste values. Also, I cannot use formulas from the first Excel to the second session.

 

Hope my problem is clear!

 

Thanks for your suggestions,

 

Cheers,

Eric

Esteemed Advisor
Esteemed Advisor
Posts: 7,241

Re: Send to Excel in an existing Excel session

It sounds like one of two issues, and I don't use EG so not sure which.  First, it could be that EG is using something could DDE to send the data to Excel.  This is very old technology and really shouldn't be used at all anymore.  If you want to create output, then use one of the new tech's, e.g. tagsets.excelp, libname excel, even proc export.  As I said though I don't use EG so don't know if that is indeed the problem.

 

The other issue could be Excel's object instance, generally speaking Office objects like to be exclusive, i.e. one object, within multiple workbooks within it.  Depending on implementation.  

 

At the end of the day however the best recommendation when anyone mentions the name, is not use Excel at all for any purpose as it was never designed to do <insert what you want to do with it here>.

Respected Advisor
Posts: 3,065

Re: Send to Excel in an existing Excel session

When I use Send to Excel in EG say from the Output window a box pops up saying do I want to open a new workbook/session or add to an existing workbook/session. Does that not happen for you?

Contributor EH
Contributor
Posts: 32

Re: Send to Excel in an existing Excel session

No it is not the case.

 

Doc says: "You can send the results to a new document or an active document. If you send the results to an active document and you have multiple documents open, you can select which document to send the results to."

 

This question is not asked.

 

So please when any of the SAS employees has arrived...

 

After reading more of the same doc, it seems that I have to install the SAS Add-In for Microsoft Office. After I did, nothing changes. The other way around also does not work: I can choose "Open a SAS data source" from Excel, but it does not show my own (WORK) datasets or any of my own defined libraries.

 

Thanks for your reply!

 

Cheers,

Eric

Super Contributor
Posts: 305

Re: Send to Excel in an existing Excel session

Hello,

 

Have you tried writing the table in a library defined within metadata and afterwards trying to open the table using Sas Add-Inn?

 

I use this technique quite often and there is no problem to have the data in the same excel session.

 

 

Contributor EH
Contributor
Posts: 32

Re: Send to Excel in an existing Excel session

[ Edited ]

Thanks,

 

Those metadata is readonly for me. I define my libraries by "submit sas code when server is selected". Still, it is a start!

 

Thanks again,

Eric

Respected Advisor
Posts: 3,065

Re: Send to Excel in an existing Excel session

I'm using EG 7.11 and SAS Add-In 7.1 and I get this window:

 

screenshot11.jpg

Contributor EH
Contributor
Posts: 32

Re: Send to Excel in an existing Excel session

Unfortunately I do not get this popup. However, I have seen it before, so maybe it is a configuration issue? Thanks! Eric
Contributor EH
Contributor
Posts: 32

Re: Send to Excel in an existing Excel session

[ Edited ]

Rethinking, it may have something to do with the fact I am running EG on a BI Server. That server apparently is capable of starting an Excel session on my PC and dumping data into that session, but it probably cannot join an existing Excel session. Can somebody confirm this, or is there hope for me :-). Cheers, Eric

Respected Advisor
Posts: 3,065

Re: Send to Excel in an existing Excel session

So do you remotely logon to your BI Server and run EG there? If so EG would only know about server Excel sessions not your PC Excel sessions.

 

Try opening Excel first on your BI server before a send. Do you get the window pop up then?

Contributor EH
Contributor
Posts: 32

Re: Send to Excel in an existing Excel session

No, EG is running on my PC sending SAS commands to the BI Server and receiving output in the output tab. That output can be sent to Excel, but only to a new Excel session for every other dataset.

 

Eric

 

Ask a Question
Discussion stats
  • 10 replies
  • 705 views
  • 2 likes
  • 4 in conversation