Exporting to Excel

[art297]

Nick,

I'd like to resolve the matter before I present the macro at SGF in a week and a half.  Please contact me, offline tomorrow, at:

atabachneck@gmail.com  I didn't understand your last message as you said that you'd use:

c:\nick\Dropbox\test.xlsx

instead of

c:\nick\Dropbox\test.xlsx

They look the same to me.  I tested the macro, before posting it, thus would really like to figure out what the problem is.

Art

[art297]

For anyone who has been following this thread, the 'need' that Nikolaos had caused us to revise the macro we had written so that it would be useful both as an action command from the SAS Explorer window and as a macro that one can call from either base SAS or EG.

Plus, in the process of accomplishing those modifications, we decided to expand it to include the capabilities of:

1. including a variable name header row than can display either variable names or variable labels

2. including the abilities to either create a new workbook, add a worksheet to an existing workbook

3. copy a table to a range of either a new Workbook, an existing worksheet, or a new worksheet

The published paper, unfortunately, won't reflect the updated code, but the code,powerpoint and updated paper can all be downloaded from:

A Poor/Rich SAS Users Proc Export - sasCommunity

BTW, many thanks to Nokolaos as, while we were trying to help him, he helped us by testing the code.

Art

[NickAnt]

Glad to help and, of course, to be helped! It is a very good piece of work.

Cheers,

Nick