 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2006Tidying up VB...
Hi All, I have written a quite simple VB script, and have got a section that I would like to "tidy up" If anybody could offer any suggestions they would be greatly appreciated. The section of script is below: Application.Wait Now + TimeValue("00:00:5") SendKeys "{Tab}", True SendKeys "{tab}", True SendKeys "{tab}", True SendKeys "{Tab}", True SendKeys "{tab}", True SendKeys "{tab}", True SendKeys "{Tab}", True SendKeys "{tab}", True SendKeys "{tab}", True SendKeys "{tab}", True SendKeys "{tab}", True SendKeys "{Tab}", True SendKeys "{tab}", True SendKeys "{tab}", True SendKeys "{Tab}", True SendKeys "{tab}", True SendKeys "{ENTER}" Many Thanks, Mark It would help to know what all those tabs are there to achieve  SignatureHTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS www.nickhodge.co.uk > Hi All, > [quoted text clipped - 23 lines] > Many Thanks, > Mark They are there to tab through options on a website on IE I was wondering if there was maybe a loop that i could use? Thanks, Mark > It would help to know what all those tabs are there to achieve > [quoted text clipped - 5 lines] > nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS > www.nickhodge.co.uk Mark Ah, right, well you could use a for x = 1 to 10 type loop, but I doubt it will be significantly quicker SignatureHTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS www.nickhodge.co.uk > They are there to tab through options on a website on IE > I was wondering if there was maybe a loop that i could use? [quoted text clipped - 11 lines] >> nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS >> www.nickhodge.co.uk Nick, Ok then, thank you for your help. I will look into this option, do you know of anywhere that I can read up on this type of loop? Thank you, Mark > Mark > [quoted text clipped - 24 lines] > >> nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS > >> www.nickhodge.co.uk It won't be quicker Mark, it will be slower, and will be less clear IMO. I wouldn't bother personally. Signature--- HTH Bob (change the xxxx to gmail if mailing direct) > Nick, > [quoted text clipped - 33 lines] >> >> nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS >> >> www.nickhodge.co.uk Another way... SendKeys "{Tab 16}", True SignatureJim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "MarkHear1" <markhearsum@gmail.com> wrote in message Hi All, I have written a quite simple VB script, and have got a section that I would like to "tidy up" If anybody could offer any suggestions they would be greatly appreciated. The section of script is below: Application.Wait Now + TimeValue("00:00:5") SendKeys "{Tab}", True SendKeys "{tab}", True SendKeys "{tab}", True SendKeys "{Tab}", True SendKeys "{tab}", True SendKeys "{tab}", True SendKeys "{Tab}", True SendKeys "{tab}", True SendKeys "{tab}", True SendKeys "{tab}", True SendKeys "{tab}", True SendKeys "{Tab}", True SendKeys "{tab}", True SendKeys "{tab}", True SendKeys "{Tab}", True SendKeys "{tab}", True SendKeys "{ENTER}" Many Thanks, Mark Jim, Thank you very much for this. While i have your attention (if i still do) could i please pick your brains with another VB query? :-) Many Thanks, Mark > Another way... > SendKeys "{Tab 16}", True [quoted text clipped - 30 lines] > Many Thanks, > Mark Not sure what you are trying to achieve, but you could probably just control IE using activeX and just activate that button, that would be less prone to errors, sendkey might be a bit unreliable if it is to be used on other computers than yours? see exemple here: http://www.dailydoseofexcel.com/archives/2004/09/22/automating-internet-explorer/ > Jim, > [quoted text clipped - 39 lines] > > Many Thanks, > > Mark- Hide quoted text -- Show quoted text - Yes it will be used on other peoples computers, however i have no knowledge of activeX and would probably end up in a right mess!!! Unfortunately that website is blocked for me at work. Thank you, Mark > Not sure what you are trying to achieve, but you could probably just > control IE using activeX and just activate that button, that would be [quoted text clipped - 47 lines] > > > Many Thanks, > > > Mark- Hide quoted text -- Show quoted text - Hah! It's blocked because it has a link to a word like "D. Hicks" blog. Someones web filtering is sensitive. > Yes it will be used on other peoples computers, however i have no > knowledge of activeX and would probably end up in a right mess!!! [quoted text clipped - 54 lines] > > > > Many Thanks, > > > > Mark- Hide quoted text -- Show quoted text - Possibly, although i think it might just be because it's link a message board (somehow it allows access to google message groups) but it's quite strict on message boards usually. > Hah! It's blocked because it has a link to a word like "D. Hicks" > blog. [quoted text clipped - 59 lines] > > > > > Many Thanks, > > > > > Mark- Hide quoted text -- Show quoted text - Hi Bob, Thank you for your response, i some how managed to miss yours when i checked earlier. I am now about to start a new topic about VB again, so if anybody fancies helping me with that .... :-) Regards, Mark > Possibly, although i think it might just be because it's link a message > board (somehow it allows access to google message groups) but it's [quoted text clipped - 63 lines] > > > > > > Many Thanks, > > > > > > Mark- Hide quoted text -- Show quoted text -
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.