Reeza; That worked! Thank you! Lawrence ... View more

I realized there was an error in description:   It works fine as is- The issue I am having is attempting to embed this into a macro var as so that put '[OPEN("T:\P_PPR\PPR_Program\xxx\PPR\2015MY\Report\&MEDCTR\2015 MidYear &MEDCTR Med Ctr All Outliers.xls")]'; properly is rendered as: put '[OPEN("T:\P_PPR\PPR_Program\xxx\PPR\2015MY\Report\ROS\2015 MidYear ROS Med Ctr All Outliers.xls")]'; And opens the file   Thank you ... View more

Ballard- To your questions- Both the file and the folder exists already.  In addition, excel is already open as well (through an X command) As to the errors-   As is without the macro input the script works fine. If you attempt to use the macro language as stated in the thread  then nothing happens- I have tried a couple of other iterations that have resulted in the file not being found as the Macro vars remain undefined.     Thanks for your help   Lawrence     ... View more

Thanks Mark & Astounding! That works. Mark-The final observation should have been 3 and not -3.  That was a typo. In short I will explain- What the zeros and ones represent are a patient's assessment in an ICU- 0 is not mobile, 1 is mobile. I have a physician who wants data on when a patient is mobile on the second assessment. And I chose Mark's answer as correct as it was the first one posted (that worked)  but they both do the job!  Lawrence ... View more

SASKiwi- Thanks- I had come to the same assessment. The issue at large is that there are two separate network environments-windows and UNIX. Currently there is no connectivity-I was trying to do an end run about having to set up an UNIX account and having to manage everything through FTP/ PERL scripts etc etc. Lawrence ... View more

Thanks RW9 and Reeza- OOOh a macro that will convert over xml files to XLSX files- I have to go check that out! ... View more

Reeza; Yes saving it to a xls format in itself and doing a proc import works. The issue is that I have some 2000 files! RW9-Sorry if i was not more articulate- What I had tried to do, and knew that it would fail, was to simply copy the file and rename the extension to xls. CVS does not work in this case as the files are multi-tabbed. In short what I was attempting to do was to find a faster way to import the data as many times I can build a pipe to import the file names and then a macro to import the data from each file, reassemble all the data. Usually it works really fast. I have another method to get at the same data by pulling directly from the database. Unfortunately it is slow moving and will take about 2 days to process it all. Cynthia-the XML mapping works insofar as it imports the different worksheets. However I am not sure if there is a parameter to set the row to start importing the data. Also that the some of the worksheets have names greater than 32 characters presents an issue as it won't import those sheets.  Thanks for all your assistance on this. I consider this issue closed. Lawrence ... View more

@Reeza- What gets generated is a multi-tabbed document with six different sheets in it. It is hard to post as it has a lot of HIPAA protected data and internal data reserved only for the medical centers. By trying to mask everything takes a bit, but I will see what I can do. Thanks Cynthia. I will take a look. RW9- I have the code that generates the file but I don't have the data as it grabs information from the server and then exports the files. Long story to why I don't have the data  previous to April. I do have a program that retro-fill in the data but it takes a long time actuall to process each day. I did try resaving as an Excel file which failed. Saving as a CSV is not possible. Lawrence ... View more