" I am using2003. I need to download 'Complete NAV Report in Text Format' from the website: 'http://www.amfiindia.com/navreport.aspx' and search and find a few data for my use. Is it possible to do this using a VBA Macro? Even if you can give me a few hints, I can follow up.
go to data - import data -web query and type your report URL
then you can perform a text to column
Given this is a simple one, you can even do this macro through recording it.
just go to macro - record new macro. Once it begin to record just do everything one time, from import web query, typing the address, selecting which area you wish to import, and the the text to column task.
once it's finished just stop the macro recording and there you have!
If you still find yourself lost, follow up with more detail