Open and Save a Web Page at Text

[geoffcodd]

Hi there,

I want to be able to open a Web Page and save it as a Text file using vba, but I need to do it in the background so you don't see explorer.

Any ideas anyone?

Thanks in advance
Geoff

 

[KenHigg]

Hum...

If you save a web page as a text file, won't you get the html tags, etc.? What use would all that be? (If you don't mind me asking)

Ken

 

[geoffcodd]

Hi there,

I then import the text file and take the information from the 4 of the rows that I need, I have it working manually but need to automate the download and saving of the web page.

Thanks
Geoff

 

[KenHigg]

Hum...

Seems like you could use a copyfile. Copy the .html file over to your local machine and rename it with a .txt.

But I'm not sure how the 'FileSystemObject' works...

Example from VBA Help:

FileSystemObject.CopyFile "c:\mydocuments\letters\*.doc", "c:\tempfolder\"

Ken

 

[geoffcodd]

Thanks Ken,

I have automated the download now I get a text file with html tags but I can work with that.

Thanks
Geoff