How to Read text from already Opened Notepad

Hi All,

I am trying it from a long time and not able to solve it, i am a bit new to the VBA

My issues is:
I have a notepad which is already open and i have to read the text and analysis, (the notepad dosen't have any location as it is downloaded from a website)
i have tried creating a object with "Shell("Notepad", vbNormalFocus)", but by doing so it opeining
even tried using createobject, but is of no use
"Set obj = CreateObject("notepad.application")
Set objnotepad = obj.Windows(1).text"

Any help on this is really appreciated
Thanks in advancd

Why? It's much easier to save it and read it from disk

Actually i am downloading the textfile from a website through vba and i tried saving it but not able to save to local system a i am not able to click the saveas button in IE 11 version, so the alternative is to open the text file and process it

If any suggestion on this will be greatly helpfull, i am trying it from past 5 hours but not able to crack if

You shouldn't be using IE to download files so I think you've gone off track - please post the code you have

Below is my code, at the end of the macro a text file will open

Please Login or Register  to view this content.

I mean the bit before that - I don't want to see the nasty IE hacking

There are multiple ways t download a text file, here are more ways than you can shake a stick at http://stackoverflow.com/questions/1...nload-file-vb6

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

the website "pubmed" can be considered as reference for it

So you're extracting data from pubmed?

Yes, can't i do that, its a public source right the best to my knowledge

Yes, there's not problem but they offer an API, so why would you want to download files like this? Have a look here: http://www.excelforum.com/excel-prog...se-pubmed.html

There's also http://www.excelforum.com/excel-prog...xml-print.html

Actually this is a part of flow that need to be incorporated, what i have is that i need to provide a platform where user will navigate to pubmed webpage their user will search and select particular criteria's then click the button to download, then marco need to run and extract the data in notepad and save it to the local desktop, there are many search type which cannot be controlled,

but thanks alot for sharing that post, will have a look into in,
but if any help on it, will be use-full for me, either how to click on save-as button in IE11 and above or to extracted text from already open notepad

Your code isn't doing as you describe, it's searching on behalf of the user - not allowing them to search on pubmed?

If what you describe is what you need, (rather than what your code does) then why not simply allow the user to choose a text file to work with after they've saved it? - They can simply use the built in dialogs then

Below is the file with a small part of the big picture

Leaving for the day, will look in HTML query tomorrow, thanks for you help Kyle, really appreciate it,

and if you have any suggestion for my question "How to Read text from already Opened Notepad",, will be helpful