Hi there!
I'm looking for a little help in regards of creating a macro that will let my user select a csv-file and insert into a specific sheet.
I have Googled my way to the code below, which imports the file fine, but inserts into a new workbook. I can't seem to have it paste the content into the active sheet.
The code may seem quite complex, but it's the only solution I have found so far - Feel free to point me in the direction of something more simple!
At the moment i use a Apple Service to run through the csv and replace semicolon with comma, being able to do this in the same macro would also be fantastic!
Thanks!
Name | Class | Dorm | Room | GPA |
---|---|---|---|---|
Sally Whittaker | 2018 | McCarren House | 312 | 3.75 |
Belinda Jameson | 2017 | Cushing House | 148 | 3.52 |
Jeff Smith | 2018 | Prescott House | 17-D | 3.20 |
Sandy Allen | 2019 | Oliver House | 108 | 3.48 |
Title1 | Title2 | Title3 |
one | two | three |
example1 | example2 | example3 |
Lead | Title | Phone | Notes |
Jim Grayson | Senior Manager | (555)761-2385 | Spoke Tuesday, he's interested |
Prescilla Winston | Development Director | (555)218-3981 | said to call again next week |
Melissa Potter | Head of Accounts | (555)791-3471 | Not interested, gave referral |
Player | Position | Nicknames | Years Active |
---|---|---|---|
Skippy Peterson | First Base | 'Blue Dog', 'The Magician' | 1908-1913 |
Bud Grimsby | Center Field | 'The Reaper', 'Longneck' | 1910-1917 |
Vic Crumb | Shortstop | 'Fat Vic', 'Icy Hot' | 1911-1912 |
Item | Cost | Sold | Profit |
---|---|---|---|
Keyboard | $10.00 | $16.00 | $6.00 |
Monitor | $80.00 | $120.00 | $40.00 |
Mouse | $5.00 | $7.00 | $2.00 |
Total | $48.00 |
Item | Cost | Sold | Profit |
---|---|---|---|
Keyboard | $10.00 | $16.00 | $6.00 |
Monitor | $80.00 | $120.00 | $40.00 |
Mouse | $5.00 | $7.00 | $2.00 |
Total | $48.00 |