hi, the last command in my macro is 'RunCode'and in the area provided to enter function name i have the following text
SHELL("COPY C:\COLL.csv+C:\CORR_STD.csv+C:\PUBS.csv+C:\AUTHRS.csv+C:\PXS.csv+C:\PX_RACE.csv+C:\PRIOR_TXS.csv+C:\TX_CRS+C:\CRSE_AGNTS.csv+C:\BSLNE_ABNR.csv+C:\AES.csv+C:\LATE_AES.csv+C:\BST_RESP.csv+C:\TRL_COM.csv+C:\PH1_EP.csv+C:\PH1_DLT.csv C:\CDUS.csv")
which as you'd imagine is intended to take the 16 files named by the copy command and stack them one atop the other into the resulting 'CDUS.csv' file -- but it doesn't; instead i get a 'File Not Found' message.
the 16 files are created in the same macro prior to firing off the SHELL command and to test the possibility there's something awry with it, i removed the quotations, parentheses and the SHELL word and pasted the remainder into an adhoc 'bat' file i created which i then proceeded to execute. it ran w/o a hitch! so what gives with all of this. i am concluding all the ingredient files are around else the command wouldn't have run and that there's nothing intrinsically goofy w/ the syntax (at least on DOS), so having eliminated the usual suspects, what's left? anybody?
“The philosophy of the school room in one generation will be the philosophy of government in the next." --- Abraham Lincoln
SHELL("COPY C:\COLL.csv+C:\CORR_STD.csv+C:\PUBS.csv+C:\AUTHRS.csv+C:\PXS.csv+C:\PX_RACE.csv+C:\PRIOR_TXS.csv+C:\TX_CRS+C:\CRSE_AGNTS.csv+C:\BSLNE_ABNR.csv+C:\AES.csv+C:\LATE_AES.csv+C:\BST_RESP.csv+C:\TRL_COM.csv+C:\PH1_EP.csv+C:\PH1_DLT.csv C:\CDUS.csv")
which as you'd imagine is intended to take the 16 files named by the copy command and stack them one atop the other into the resulting 'CDUS.csv' file -- but it doesn't; instead i get a 'File Not Found' message.
the 16 files are created in the same macro prior to firing off the SHELL command and to test the possibility there's something awry with it, i removed the quotations, parentheses and the SHELL word and pasted the remainder into an adhoc 'bat' file i created which i then proceeded to execute. it ran w/o a hitch! so what gives with all of this. i am concluding all the ingredient files are around else the command wouldn't have run and that there's nothing intrinsically goofy w/ the syntax (at least on DOS), so having eliminated the usual suspects, what's left? anybody?
“The philosophy of the school room in one generation will be the philosophy of government in the next." --- Abraham Lincoln
