internet explorer - Excel VBA and InternetExplorer causing errors on website -

-

I have some "smart" users who have written an Excel spreadsheet that automates some of their tasks on our intranet / tile sheet . It seems that the example of a built-in Internet Explorer is not doing everything I expect of a browser, e.g. Set up Cookies Is there a way to find out if a user is killing a web site with Internet Explorer's VBA COM object instance? I can not keep users from making creative solutions but I want to handle them. Thank you

Some things come to mind first, until any restricted information or web scraping data If you do not intend to make public, it is better to fix the site so that the site works with purpose, but the user can still use VBA to access the place. VBA is an important productivity tool for many businesses and can provide people the flexibility to "extend" a site for those places which may not be suitable for development requests.

However, if you insist on trying to break your user's application :) ... check the dom window. Visual property is not a sure-fire, but an example of many web-scraper Internet Explorer "Roboting" can not be invisibly also that cookies are not being set, they are only being removed on the fly. . If you are trying to limit page-hits with cookies, then you should consider the basic truth that any data stored on the client side is subject to change. Instead try to store such information server-side. As mentioned earlier, some methods do not submit proper headers, so that you can check them, and in the end there is a popular "captcha". Of course, none of these methods is stupid and all this are lacking.

Everyone said, if one thing I have learned, then it is that people will find a way to do their job. You can lock your interface as much as you want, but if the user believes that whatever they are doing is necessary to do their job, they will find an alternative solution to implement your "applicable" Will be very motivated to. And they will probably earn praise and recognition for their efforts. The user will keep this as long as you do not meet their needs which they believe

If you really want to kill the app, then to recognize it It is better that the requirement is not being met, and to fulfill it. If managers do not want to managers to support and maintain 100 different small applications to do this. If there is a "legitimate" hassle-free way to fulfill the need, then how will it be used normally? Everyone is pressed for time, so simple solution wins. If you are trying to make your app better than any one, why bother with the development of the house? A business unit manager will direct his employees back to business if an excuse is given


Comments

Post a Comment

Popular posts from this blog

c# - How to capture HTTP packet with SharpPcap -

-
I would like to capture all incoming HTTP packets on my machine. To do this, I am using SharpPcap which is a WinPcap The cover is. SharpPcap works very well, but it captures TCP packets and what it wants to do for me is a very low level. Does anyone know how can I easily get full HTTP requests / reactions from all these TCP packets? Thanks SharpPcap is already able to capture the packet in the same way That's what the virus does (just in the code instead of the GUI). And you can either either parse them directly or you can put them in the drive in the common .pcap file format. The steps to parse the capture are: Open a connection at any time Loop a while Or start capturing using an event callback Parsing the raw packet for the type you want If you are reading .PPP dump files In addition to calling you an offline capture reader is almost the same, there is no need to select an interface, and you can set the majority There is no need to do the modes. All st
Read more

jquery - SimpleModal Confirm fails to submit form -

-
I am trying to confirm jQuery to show yes / no confirmation when I submit a form. I had modified (in the last list) to capture and block form submissions. However, it only works with jQuery 1.2.6, a recent upgrade stops 1.3.2, if yes is clicked, then by submitting the form. But I can not understand what is wrong / inconsistent in my code now. Demo (which works in both versions of a simple window.href implementation). $ (document) .ready (function () {$ ('input.delete'). Click (function (e) {e.preventDefault (); var target = $ (e .target); Confirm ("Really delete this event?", Function () {target.click ()});});}); How about something like this? The idea of ​​catching clicks (and fire!) On the submitted event is not click event. $ (document) .ready (function () {$ ('# myForm'). Submit (function () {var f = this; Confirm (" Remove? ", Function () {$ (f). Submit ();}) Return; Return the initial session;}}}}; Hope That this is som
Read more

php - Multiple Select with Explode: only returns the word "Array" -

-
By using Wordpress I have created a multiple selection box so that users can select categories to exclude. When the page is initially loaded, I see my predefined default option. However, when I select a new value and I save ... I only see the word "Array" and have not chosen anything else? & lt; Class = "amultiple" id = "& lt; php echo $ value ['id'] ;? gt;" name = "& gt; php echo $ value ['id'] ;; gt; []" Multiple = "multiple" size = "8" & gt; & Lt ;? Php global option; Foreign currency ($ value as value $) {if (get_settings ($ value ['id']) === FALSE {$$ value ['id'] = $ value ['std']; } And {$$ value ['id'] = get_settings ($ value ['id']); }} $ Ranges = & amp; Amp; Categories ('type = post & orderbiz = name & amp; hide_empty = 1'); If ($ ranges) {$ ex_cat = implode (',', $ tt_cat_exclude); Forex Currency ($ range a
Read more