https://communities.sas.com/t5/SAS-Programming/I-have-an-Excel-file-with-VBA-code-I-need-to-convert-to-SAS-9-4/m-p/779962#M248462 <P>I am not sure, I've not used it before and don't know how.</P> Fri, 12 Nov 2021 13:31:06 GMT kswarfield 2021-11-12T13:31:06Z https://communities.sas.com/t5/SAS-Programming/I-have-an-Excel-file-with-VBA-code-I-need-to-convert-to-SAS-9-4/m-p/779582#M248313 <P>I have an Excel VBA macro that I need to convert to SAS 9.4. The purpose of this file is to create a new spreadsheet that contains all files and the information on creation/last modified dates and owner from a Shared Drive. The Excel macro takes so long it times out 95% of the time. I need to convert it to SAS 9.4 for efficiency, but VBA is not my strong suit.</P><P>Is there code I can run that will do the same thing in SAS or a way to convert the VBA to SAS language?&nbsp;</P><P>I have attached the code in a Word doc as xlsm file types are not supported.</P><P>&nbsp;</P><P>Thank you in advance!</P><P>Kimberly</P> Wed, 10 Nov 2021 15:42:07 GMT https://communities.sas.com/t5/SAS-Programming/I-have-an-Excel-file-with-VBA-code-I-need-to-convert-to-SAS-9-4/m-p/779582#M248313 kswarfield 2021-11-10T15:42:07Z https://communities.sas.com/t5/SAS-Programming/I-have-an-Excel-file-with-VBA-code-I-need-to-convert-to-SAS-9-4/m-p/779588#M248317 <P>Like a directory listing?</P> <P><A href="https://support.sas.com/kb/24/820.html" target="_blank">https://support.sas.com/kb/24/820.html</A></P> <P>&nbsp;</P> <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/406132">@kswarfield</a>&nbsp;wrote:<BR /> <P>I have an Excel VBA macro that I need to convert to SAS 9.4. The purpose of this file is to create a new spreadsheet that contains all files and the information on creation/last modified dates and owner from a Shared Drive. The Excel macro takes so long it times out 95% of the time. I need to convert it to SAS 9.4 for efficiency, but VBA is not my strong suit.</P> <P>Is there code I can run that will do the same thing in SAS or a way to convert the VBA to SAS language?&nbsp;</P> <P>I have attached the code in a Word doc as xlsm file types are not supported.</P> <P>&nbsp;</P> <P>Thank you in advance!</P> <P>Kimberly</P> <HR /></BLOCKQUOTE> <P>&nbsp;</P> Wed, 10 Nov 2021 16:08:34 GMT https://communities.sas.com/t5/SAS-Programming/I-have-an-Excel-file-with-VBA-code-I-need-to-convert-to-SAS-9-4/m-p/779588#M248317 Reeza 2021-11-10T16:08:34Z https://communities.sas.com/t5/SAS-Programming/I-have-an-Excel-file-with-VBA-code-I-need-to-convert-to-SAS-9-4/m-p/779697#M248376 <P>Why not just read the text generated by the DIR command?</P> <P>Does your SAS installation not allow operating system commands to be called?</P> Thu, 11 Nov 2021 03:28:31 GMT https://communities.sas.com/t5/SAS-Programming/I-have-an-Excel-file-with-VBA-code-I-need-to-convert-to-SAS-9-4/m-p/779697#M248376 Tom 2021-11-11T03:28:31Z https://communities.sas.com/t5/SAS-Programming/I-have-an-Excel-file-with-VBA-code-I-need-to-convert-to-SAS-9-4/m-p/779962#M248462 <P>I am not sure, I've not used it before and don't know how.</P> Fri, 12 Nov 2021 13:31:06 GMT https://communities.sas.com/t5/SAS-Programming/I-have-an-Excel-file-with-VBA-code-I-need-to-convert-to-SAS-9-4/m-p/779962#M248462 kswarfield 2021-11-12T13:31:06Z