https://communities.sas.com/t5/SAS-Programming/How-to-IMPORT-COPY-an-Excel-file-that-another-user-has-open/m-p/657639#M197104 <P>You are talking about stuff that system admins have nightmares handling on windows. A user can inadvertently permanently lock an excel file.</P> Thu, 11 Jun 2020 17:56:25 GMT smantha 2020-06-11T17:56:25Z https://communities.sas.com/t5/SAS-Programming/How-to-IMPORT-COPY-an-Excel-file-that-another-user-has-open/m-p/657602#M197075 <P>I have a program that has to read an Excel file from a server for some data. I want to write a program that will run un-attended every day. I can write such a program and it all works properly, except on those days when the program runs and some other user has the Excel file open. PROC IMPORT does not seem to work. Nor does copying the file to my local hard disk (and then I know no one has it open) because my SAS code using FCOPY() won't copy the file when some other user has the Excel file open. So, how can I either IMPORT or COPY an Excel file that another user has open?</P> Thu, 11 Jun 2020 16:57:47 GMT https://communities.sas.com/t5/SAS-Programming/How-to-IMPORT-COPY-an-Excel-file-that-another-user-has-open/m-p/657602#M197075 PaigeMiller 2020-06-11T16:57:47Z https://communities.sas.com/t5/SAS-Programming/How-to-IMPORT-COPY-an-Excel-file-that-another-user-has-open/m-p/657611#M197084 <P>Would it be possible to get a duplicate file made elsewhere by the creation process where you have access, best that no one else has access?</P> Thu, 11 Jun 2020 17:21:35 GMT https://communities.sas.com/t5/SAS-Programming/How-to-IMPORT-COPY-an-Excel-file-that-another-user-has-open/m-p/657611#M197084 ballardw 2020-06-11T17:21:35Z https://communities.sas.com/t5/SAS-Programming/How-to-IMPORT-COPY-an-Excel-file-that-another-user-has-open/m-p/657612#M197085 <P>I don't want to re-engineer the process. I want to use the data set on the server.</P> Thu, 11 Jun 2020 17:24:08 GMT https://communities.sas.com/t5/SAS-Programming/How-to-IMPORT-COPY-an-Excel-file-that-another-user-has-open/m-p/657612#M197085 PaigeMiller 2020-06-11T17:24:08Z https://communities.sas.com/t5/SAS-Programming/How-to-IMPORT-COPY-an-Excel-file-that-another-user-has-open/m-p/657613#M197086 <P>If you haven't already tried, does this solution work?&nbsp;</P> <P><A href="https://stackoverflow.com/questions/15439507/import-excel-data-into-sas-whilst-spreadsheet-still-open" target="_blank">https://stackoverflow.com/questions/15439507/import-excel-data-into-sas-whilst-spreadsheet-still-open</A></P> Thu, 11 Jun 2020 17:25:38 GMT https://communities.sas.com/t5/SAS-Programming/How-to-IMPORT-COPY-an-Excel-file-that-another-user-has-open/m-p/657613#M197086 biopharma 2020-06-11T17:25:38Z https://communities.sas.com/t5/SAS-Programming/How-to-IMPORT-COPY-an-Excel-file-that-another-user-has-open/m-p/657624#M197093 <P>My bad, I should have mentioned that we run on Windows, there is no such option on Windows. Any other ideas?</P> Thu, 11 Jun 2020 17:36:59 GMT https://communities.sas.com/t5/SAS-Programming/How-to-IMPORT-COPY-an-Excel-file-that-another-user-has-open/m-p/657624#M197093 PaigeMiller 2020-06-11T17:36:59Z https://communities.sas.com/t5/SAS-Programming/How-to-IMPORT-COPY-an-Excel-file-that-another-user-has-open/m-p/657637#M197102 Can you use x command and do a system copy instead? It may work when an xcopy failed. Thu, 11 Jun 2020 17:46:44 GMT https://communities.sas.com/t5/SAS-Programming/How-to-IMPORT-COPY-an-Excel-file-that-another-user-has-open/m-p/657637#M197102 Reeza 2020-06-11T17:46:44Z https://communities.sas.com/t5/SAS-Programming/How-to-IMPORT-COPY-an-Excel-file-that-another-user-has-open/m-p/657639#M197104 <P>You are talking about stuff that system admins have nightmares handling on windows. A user can inadvertently permanently lock an excel file.</P> Thu, 11 Jun 2020 17:56:25 GMT https://communities.sas.com/t5/SAS-Programming/How-to-IMPORT-COPY-an-Excel-file-that-another-user-has-open/m-p/657639#M197104 smantha 2020-06-11T17:56:25Z