PoggiPJ
Active Member
- Joined
- Mar 25, 2008
- Messages
- 330
I need some help writing a macro that will open a csv file from a URL, then import the data contained in that csv file into one of the worksheets. I will already know the complete URL. I do not need to download or save the CSV file, just pull the data into my workbook.
I would like to make this as transparent to the user as possible. Basically, the user will click on a command button to initiate the process, and be informed once it has completed, barring any error alerts.
Can anyone point me in the right direction, perhaps offer some similar code that i can modify? Thank you.
I would like to make this as transparent to the user as possible. Basically, the user will click on a command button to initiate the process, and be informed once it has completed, barring any error alerts.
Can anyone point me in the right direction, perhaps offer some similar code that i can modify? Thank you.