Thanks for the clarification Reeza! ... View more

Hi Reeza,   Here is a sample VBA code I am working on( Code does not work).  data _null_; file "c:\test\ir_formatter.vbs"; put 'Dim XL' / 'SET XL = CreateObject("Excel.Application")' / 'XL.Visible = False' / 'XL.DisplayAlerts = False' / 'SET objWorkbook1 = XL.Workbooks.Open("("C:\test\book2.xlsm")")' / 'XL.RUN "("'C:\test\book2.xlsm.'!sheet1.helloworld")" ' / 'objWorkbook1.save' / 'XL.ActiveWorkbook.Close' / 'XL.DisplayAlerts = True' / 'SET objWorkbook1 = Nothing' / 'SET XL = Nothing' /; run; /* Execute VBA */ x 'c:\test\ir_formatter.vbs'; filename vbs "c:\test\irformatter.vbs"; data _null_; rc=fdelete('vbs'); run; filename vbs clear; ... View more

Sorry for being unclear.   I have a sas program that creates an excel spreadhseet and lately I have been creating a pivot table in the excel using the data that my SAS program produced. I came to know that using some vba code in SAS, the refresh of the pivot table can be automated via SAS/VBA.   Hope I made it clear this time. ... View more

Reeza/Casey,   Please see my log notes:   NOTE: The export data set has 94 observations and 24 variables. NOTE: "/apps/sas/datasets/data7/email.xlsx" file was successfully created. NOTE: PROCEDURE EXPORT used (Total process time): ... View more

I do have write permission because I was able to write a .CSV file to the same location. ... View more

Sorry I mean PROC EXPORT.   Here is my code: %let data_path=%str(/apps/sas/datasets/dataf/); PROC EXPORT DATA= WORK.TEMP01 OUTFILE= "&data_path./email.xlsx" DBMS=xlsx REPLACE; SHEET="TEST"; RUN; ... View more