I've now changed the Directory path Folder to C:\Temp\csv.   I still get the error;   SYMBOLGEN: Macro variable DIR resolves to C:\Temp\csv C:\Temp\csv cannot be open. ... View more

Also under SYMBOLGEN in the log, I'm getting DID resolves to 0.   I'm using an UNC path without any Quotes or Apostrophes.   Any ideas? ... View more

Thanks I did that.   The code looks OK but I'm getting an  error saying the dir path cannot be opened?     ... View more

Ok, I've posted the full code I'm running, problem is no tables imported into EG?   %macro drive(dir,ext); %local cnt filrf rc did memcnt name; %let cnt=0; %let filrf=mydir; %let rc=%sysfunc(filename(filrf,&dir)); %let did=%sysfunc(dopen(&filrf)); %if &did ne 0 %then %do; %let memcnt=%sysfunc(dnum(&did)); %do i=1 %to &memcnt; %let name=%qscan(%qsysfunc(dread(&did,&i)),-1,.); %if %qupcase(%qsysfunc(dread(&did,&i))) ne %qupcase(&name) %then %do; %if %superq(ext) = %superq(name) %then %do; %let cnt=%eval(&cnt+1); %put %qsysfunc(dread(&did,&i)); proc import datafile="&dir\%qsysfunc(dread(&did,&i))" out=dsn&cnt dbms=xls replace; run; %end; %end; %end; %end; %else %put &dir cannot be open.; %let rc=%sysfunc(dclose(&did)); %mend drive; %drive('F:\Data\Reports\Test_Reports','xls') ... View more

One more for you, I want the .xls file to be imported into my SAS EG Project as a table.   The macro is running but I'm not sure whether I should use apostrophes, Quotes or nothing.   & I'm not getting any output?   Thanks ... View more

Gotcha, thanks Reeza,   So it's similar to what I've used in SQL Server a tvf or svf.   Thanks ... View more

Thanks Kurt,   I replaced the 'dir' with my UNC path to a Network Folder & xls as the file type.   I'm getting an error as the path is > 32 characters.   So this what my code looks like at the start;   %macro drive("\\abc\def\ghi\My_Report","xls"); %local cnt filrf rc did memcnt name; %let cnt=0; By the way I've tried Apostrophes & Quotes top wrap the path.   Any suggestions how I can replace the path?   Do I add a line that says dir = 'Path_name' - for example? ... View more

Thanks Reeza I'll have a read.   Cheers ... View more

Thanks Reeza but i still don't follow.   I'm used to VBA where you write a macro & then Call it.   But any variables need to be Declared, where are the values declared in the script OR do I need to see the Macros own script so I can see what it's doing?   Thanks ... View more