Add "about:blank" to trusted sites via VBa

[JasperD]

Hi VBA gurus,

is it possible to add "about:blank" to IE's trusted sites via VBA?
Thanks,

Jasper

[dominicb]

Good evening JasperD

Yes, it's possible. But you're going to have to do a bit of work around it.

You will need to do some tinkering with Explorer - set about:blank as a trusted site and then open your registry and do a search for about:blank to see what entries it creates. The trusted sites are all stored in the registry.

It'll be somewhere around here :
HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Internet Settings\ZoneMap\EscDomains

Once you know what entries need generating then you're home and dry. It won't be that hard to set those up through VBA.

If you want the easy way out, you could always try using SendKeys, but that's a bit flaky and can't always be trusted.

HTH

DominicB

[JasperD]

Hi Dominic,

thanks so much for your reply - I figured I had to do it through registry manipulation.
I use it to store values into the clipboard in VBScript and since VBScript doesn't have direct access to the clipboard, I needed to use a workaround by going through an IE object.
Turns out that IE delays the process by so much that parallel VBScript gets to be slower than serialized VBA, so I kept it within VBA.

[TMS]

Can't you just write to and read from a text file?


Regards, TMS

[JasperD]

Hi TMS,

thanks for your interest & reply!
I guess I could, but this is related to my topic : http://www.excelforum.com/excel-prog...each-time.html

Would writing it to a textfile and then get the results in excel from there be
a) quicker than putting the results into the excel sheet directly
b) fail less often?

Also, how would I identify when all hundreds of text files have been written to disk so I can tell VBA to go ahead and pull the content?

Thanks for any help provided!

[TMS]

Ah, hadn't realised . Well, clearly you have considered a text file approach.

I was thinking in terms of a 'normal' clipboard entry which is simply the last thing you copied, or wrote, to it. If there need to be multiple entries, perhaps date and time stamping, and possibly using some sort of application and/or session identifier would help you to group and process the data. That would also provide a mechanism for deleting and/or archiving old entries.

Just food for thought as I'm not 100% sure how it would be implemented.

Regards, TMS

PS: thanks for the rep

[JasperD]

To be honest, the data gets disposed of as soon as I pasted it into my sheet - so the text files don't need any specific identifiers (I could identify by putting the product code into the file name written for example).
My questions are genuine - would writing it to disk be faster and less error prone?

[TMS]

And maybe my reply was naive and simplistic. As I said, just food for thought. My assumption was that the VBScript, or the Clipboard, had some character limitation ... and it seems that it may be limited by RAM/Virtual Memory (http://www.ehow.com/how_7808949_incr...clipboard.html).

Another thought is that maybe there are some special characters in your data that terminate the copy to the clipboard.

That said, it's all hypothetical and I am not in a position to test the theory.

Sorry.