Advertisement
Guest User

Untitled

a guest
Aug 21st, 2019
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. local home "/Users/andreea/Downloads/attachments"
  2.  
  3. local filelist : dir "`home'" files "*.xlsx"
  4.  
  5. tempfile bonds
  6.  
  7. foreach f of local filelist {
  8.  
  9. di "`f'"
  10.  
  11. if ("`f'" == "Bonds-1991-January-February-March Proceeds.xlsx") {
  12. import excel using "`home'/`f'", firstrow clear
  13. save `bonds'
  14. }
  15.  
  16. else {
  17. import excel using "`home'/`f'", firstrow clear
  18. append using `bonds'
  19. save `bonds', replace
  20. }
  21.  
  22. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement