daveaus
07-07-2010, 05:51 PM
Hi everyone,
I am needing to create a VBA code that downloads a csv file from a website so that data can be extracted to a main Excel file. However, my macro gets interrupted by the windows message asking me to either save or open the csv file.
Does anyone know how to create a macro that can open the file without prompting to save? I don't want to save the csv file; I just need it for a second.
I apologise if this is a stupid question... I am fairly new to VBA and its a steep learning curve! Please help! : pray2:
Cheers,
I am needing to create a VBA code that downloads a csv file from a website so that data can be extracted to a main Excel file. However, my macro gets interrupted by the windows message asking me to either save or open the csv file.
Does anyone know how to create a macro that can open the file without prompting to save? I don't want to save the csv file; I just need it for a second.
I apologise if this is a stupid question... I am fairly new to VBA and its a steep learning curve! Please help! : pray2:
Cheers,