Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- local home "/Users/andreea/Downloads/attachments"
- local filelist : dir "`home'" files "*.xlsx"
- tempfile bonds
- foreach f of local filelist {
- di "`f'"
- if ("`f'" == "Bonds-1991-January-February-March Proceeds.xlsx") {
- import excel using "`home'/`f'", firstrow clear
- save `bonds'
- }
- else {
- import excel using "`home'/`f'", firstrow clear
- append using `bonds'
- save `bonds', replace
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement