Downloadind data from internet into

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:25 PM GMT

QuestionEdit

" 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.

Thanks"

AnswerEdit

example

go to data - import data -web query and type your report URL

http://www.amfiindia.com/spages/NAV0.txt

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

Advertisement

©2024 eLuminary LLC. All rights reserved.