Leaderboard

Hi, is it possible to set conditional formating to a new table? And if yes - can someone show a short example? Thanks Dizzy

No need to have a form, just get the input object and set it with _IEFormElementSetValue. I know it is misleading, but should work...

What is the DDL of this table (its CREATE TABLE persons ... statement) ? Also put in plain english what you want and the conditions you put to get the wanted result.

I don't get your where clause. What number do you want to check, persons.age, persons.height, persons.weight ? What is the purpose of the LIKE ColName ?

and to the forum @Sergi

Hello I got a question about a script I got if anyone can answer me please would be appreciated.. pm me

Ok but the #include at top.. there's is 3more files to come with it.. I don't have these files but is it possible for it to create a server on my network then via his PC inject the other files ? Sorry bad English and thanks appreciate it

Opens up a semi-transparent resizable GUI window, then takes a screenshot of the size and location with PrintScreen #include <GUIConstants.au3> #include <WindowsConstants.au3> #include <ScreenCapture.au3> HotKeySet("{PRINTSCREEN}", "Takepic") $gui = GUICreate("gui", 100, 100, @DesktopWidth /2, @DesktopHeight /2, BitOR($WS_POPUP, $WS_THICKFRAME), $WS_EX_TOPMOST) GUICtrlCreateLabel("", 0, 0, 100, 100, -1, $GUI_WS_EX_PARENTDRAG) WinSetTrans($gui, "", 150) GUISetState(@SW_SHOW) While 1 Sleep(100) $winsize = WinGetClientSize($gui) $winpos = WinGetPos($gui) WEnd Func Takepic() WinSetTrans($gui, "", 0) Local $randomness = Random(0, 999999) $randomnumber = Round($randomness) _ScreenCapture_Capture($randomnumber&".jpg", $winpos[0]+7, $winpos[1]+7, ($winsize[0]+$winpos[0]+6), ($winsize[1]+$winpos[1]+6)) Exit EndFunc

Hi, There have been far too many occasions recently where the Mod team have been trying to determine whether a particular thread is legal and a member has posted offering help to the OP. If the Mods are concerned about a thread, please refrain from posting within it - and certainly do not offer anything at all useful - until the all-clear has been given. After this announcement has been posted, we will regard any future instances as unfriendly acts and the poster can expect to be sanctioned - you have been warned. M23

As of now please do not post or link to any code or software which allows the downloading of YouTube content. Any such content that is already available on the forum will be removed by the Mods as and when it is discovered. Thank you for your cooperation - whether forced or voluntary. M23

Hi, A quick bump to get this back into view as the prohibition still stands. M23

As it seems that some members do not bother to read the "Announcements" section, I have added the above to the list of prohibited activities in the Forum rules. M23

And just in case you were wondering, we were not joking: M23

AutoIt v3.3.14.4 has been released. Thanks to everyone involved, both visible and behind the scenes. Download it here. Complete list of changes: History

AutoIt v3.3.14.3 has been released. Thanks to everyone involved, both visible and behind the scenes. Download it here. Complete list of changes: History

Hi, You may well be getting a warning from your browser that the site SSL certificate has expired - and indeed it has. When Jon last moved server the automatic alert for certificate expiry was not carried over. He is on the case, but it may take a while to get the certificate renewed. In the meantime, nothing has changed here and the site is as secure as it ever was. Our apologies for the inconvenience - we hope things will be back to normal soon. M23

Jon, Now that is what I call fast service! M23

The forum is currently being upgraded - this post details the status. Content may look badly formatted at the moment. This is normal until the background rebuild tasks have finished. There is no need to re-edit your old posts or signatures to fix them, this should happen automatically. Please resist the urge to do so The post rebuild is estimated at 9 hours - it's not a quick task. Current Status: Forum upgraded - 100%AutoIt code boxes rebuilt - 100%Double-spaced paragraphs fixed up (as best I can) - 100%Forum to Wiki Access - 100%Signatures rebuilt - 100%Posts rebuilt (emoticons, bbcode, attachments, images, quotes) - 100%Legacy BBCode fixed in signatures​color - 100%color=rgb() - 100%url - 100%img - 100%size - 100%Search engine online - 100%

Forum upgraded to 4.1.17.1 Please delete your browser cache if you have any problems. 4.1.17.0 Accounts flagged as spammers are now more visibly different on the member list in AdminCP Added quite a few new embed providers codepen.io coub.com deviantart.com docs.com funnyordie.com gettyimages.com iFixit.com kickstarter.com meetup.com mixcloud.com mix.office.com on.aol.com reddit.com reverbnation.com screencast.com screenr.com slideshare.net smugmug.com ustream.tv Google Maps (requires free Google API key) Default location for an AdminCP tab honors the admin's ordering Staff notification emails for tickets in Commerce now include the ticket ID Auto-saved content in the editor will now expire after 48 hours If you load an editor that has previous auto-saved content you will now be prompted to keep or remove it You can now set pre-filled reasons for Warning actions that will automatically populate the member notes editor when a moderator warns a user Escape key will now cancel quick-edit on titles Adds a setting to restrict member birthday view to admins only or to completely disable prompting for birthday to member There are now more "save and reload" options in various places to keep your place when editing content or settings New check all box when viewing activity on a member profile for easier moderation You can now hide posts that are unapproved rather than just approve or delete When a moderator changes the status of a report in the ModCP the system now puts a reply in moderator comments noting the change When you see a "could not write file" error the file it was trying to write now shows in the error logs You can now quickly edit tags when viewing an item without having to edit it if you have permission If you are using multiple devices to login to a site you will be less likely to be logged out Tags can now be quickly edited when viewing an item Administrators can now create custom RSS feeds for various content Enhancements to IP discovery tools for moderators Actions for reports in ModCP now show when status is changed as a comment Redesigned support tool More REST API methods Password strength rating and requirement option Guest terms of service alert Minimum age requirement Ban Filters are now Word Filters and can set words to automatically moderate Display name history is now available on profile view Better analytics integration Leaderboard 4.1.16.0 Large number of bugs fixed in focus areas: Commerce, Pages databases, and IPS Connect Performance improvements in: profile view, sitemap generator, posting replies, and Activity Streams We now try to more reliably detect the AWS S3 endpoint for those using S3 file storage More efficient license key checking to keep the keys from being checked too often which can slow your site down There is now a column in tasks view to show the last time it ran to help diagnostics When a member changes their email or password they now get an email confirmation If group promotion based on date is enable the system will now auto-promote even if a member does not login There is now a setting to change the number of topics per page in the forum view If you move your site to a new URL you no longer have to update a constant if using the image proxy You can now press ctrl/cmd+enter in any editor window to submit the reply In Commerce ticket view there are keyboard shortcuts to perform common actions (such as press 'r' to open reply box or 'n' for note) There is now logic to prevent double-posting when the initial post encounters an error on submit Moderators can now remove all followers from an item Contact Us is now configurable with various options Announcements can now be restricted by member group Admins now have a setting to have members automatically follow content they start or reply to. Members can optionally override this. The editor will now show a message if a link that can be embedded (image, video, etc.) failed to embed for some reason. Admins get more detailed error reasons. If your datastore (cache system) is not working properly the AdminCP will now show you a warning telling you that it needs attention. When a member is banned/suspended the system now shows a more friendly page with information on their ban. Previously it showed a permission denied page. Redesigned ticket listing in Commerce New My History view in Commerce Security Questions for account security 4.1.15.0 Commerce Customer Standing Data now loads via AJAX for faster loading Lots of Commerce related bug fixes Passwords on new hosting accounts are now more secure REST API now supports adding Staff Notes to support requests REST API now supports editing purchases Remember me cookie is now 90 days rather than 7 days A race condition is fixed where the site may call to check the license way more often than needed Performance improvements on activity streams Performance improvement to online list widgets 4.1.14.0 This is a maintenance release to fix reported issues. In addition to a strong focus on overall stability, this release contains: Official PHP 7 support Major performance improvements to Activity Streams 4.1.13.0 New per-group setting to highlight posts made by certain groups. 2 theme settings control the color and border, which are editable in the easy theme editor. New setting to make providing a billing address optional for purchases in Commerce. Personal conversation management improvements: Can now filter personal conversations to just read/unread. Can now move multiple personal conversations into a different folder at once. Can search by recipient/sender name. Notifications about Calendar events now include the event date. New setting to control which images sizes should have a watermark applied in Gallery. New setting to control which IP pool to use for SparkPost if you have purchased dedicated IP addresses. Better handling of upgrades if files have been modified. The sidebar widget for showing Downloads files can now show just free or paid files. When searching templates or CSS files in the AdminCP template editor, it will search for templates or CSS files with a name matching the term provided, in addition to searching the content of them. When viewing a log in the AdminCP, it will now show you on which page the log occurred and by which member. When the search index is being rebuilt, a message is now shown on the search results page to indicate why results may not be complete. The "details" modal for applications and plugins now has a tab which shows the hooks associated with that application or plugin. The placeholders that display on date/time inputs (e.g. "HH:MM") can now be translated. Rebuilding the search index, and rebuilding posts after a 3.x upgrade now processes newest posts first for a more user-friendly experience after upgrading. When a file is deleted, a log is created and a new setting controls how to keep these logs for.

Forum upgraded to 4.1.12.1 This is a maintenance release to fix reported issues and add refinement to existing features. In addition to bug fixes and performance improvements, it includes following enhancements: New Features: • When you mouseover the badge showing who liked a post, you will now see a larger list of who liked that post. You can still click to get the full list. • Ratings now show half-stars for the average (for example, if one user votes 3 stars and another 4, it will show 3 and a half stars) and there is now an indication if you have rated something. • A "Preview" button has been added to the post editor which shows how the post will appear after BBCode processing. Tabs show how the post will appear on desktop, tablet and mobile. • Users can now choose to ignore notifications for being mentioned in posts by particular users. • You can now filter searches by specific forums/categories. • You can now control whether open and click tracking should be used for emails sent by SparkPost. Activity Stream enhancements: • The filter dropdowns now have an "Apply" button for better usability (previously you had to click outside the dropdown). • The "Expanded/Collapsed" toggles are now clearer. • Hitting back from a clicked item in any activity stream now remembers your position and loaded results. Other enhancements and improvements: • The way dates are formatted can now be customised by language strings. For example, if you want to change the date format to "DD-MM-YYYY" that is now possible. With this change, the new default is US-style ("March 4, 1992") rather than the previous European-style ("4 March 1992"). • Advertisements no longer have padding which makes them easier to position in other areas such as headers. • When comparing revisions of articles in Pages databases, a new browser-based diff tool is used which is more user-friendly and moves the computation from the server to the user's browser for greater performance. • Better indication of files pending approval in Downloads. • The version number for themes now displays in the AdminCP list. Also included: 4.1.11 This is a small maintenance release to fix a few issues reported in 4.1.10. In addition to bug fixes and performance improvements, it includes following new/changed features: • Integration with SparkPost replaces Mandrill for optional email service as Mandrill is stopping their current service toward the end of April. • Questions in Question and Answer forums can now be sorted by most votes. • The "All Activity" activity stream now has an RSS feed. • The filter bar at the top of the activity stream no longer sticks to the stop of the screen when scrolling. • If you receive a browser notification your notification menu will now reload to get the latest notification. • More consistent visual feedback when a post submit or edit is processing to reduce duplicates. • Sidebar widgets now how rounded corners to match rest of Suite. • Recaptcha style is now a per-theme setting. • You can now set which theme should be the default for the AdminCP separate to which should be the default for the front-end. Also included: 4.1.10 This is a maintenance release to fix reported issues and add refinement to existing features. In addition to bug fixes and performance improvements, it includes following new/changed features: • Instant notifications are now dismissible. • The sidebar has been added back to the stream pages. • You can now sort by most downloaded in Downloads app. • The ModeratorCP and AdminCP IP Address Tools now allow you to track the IP addresses used to vote in polls. • A new setting has been added to disable the RSS feed for activity streams. • A new setting has been added to specify the minimum display name length. • Adds a new "can unban" moderator permission separate to the "can edit profiles" permission being used previously. • IP addresses now show in reports. • There is now a constant-level setting to disable the ACP IP address check in case of being locked out of the ACP. • Several improvements to Commerce to make some features clearer: the Shipping Rates configuration pages now indicate to the admin if a potential mistake has been made, the front-end indicates to admins if no support departments have been set up, and the renewal settings wording has been clarified. Also included: 4.1.9 This release fixes reported issues from clients in our bug tracker and support tickets and adds refinement to existing features. New or Changed Features • When your link auto-embeds in a post such as with an image, YouTube video, Twitter link, etc. an option will now display to revert the embed back to a plain text link if you do not want the embed. • New setting to disable embedding. • Facebook/Twitter integration improvements • If you are an administrator and encounter a system error, additional debug output will now display. Regular members will see the normal error message. • Custom Fields for Support Requests in Commerce now show on the front-end. • If an advertisement is set up with a main image, but not smaller images for tablets/mobiles, the ad would not show at all on tablets/mobiles. This has changed so the main image will display on all devices unless smaller images are provided. • Topics scheduled to automatically lock or unlock will now reflect this in the topic listing and when viewing the topic. • Placing a link to a Facebook status will embed when possible. • When viewing a report, the container (for example, the forum) the content is from is displayed. • Three character searches are now allowed in the Admin CP Live Search. • The Account Settings page now uses vertical rather than horizontal tabs to prevent overflow. • If Gravatar is enabled, and a user has not defined an profile photo, then their email address will be used to fetch from Gravatar unless explicitly set not to. • Gfycat embeds now use their oEmbed endpoint rather than their JS API. • Using Amazon CloudFront as https provider will now be recognized as valid secure connection. • The member REST API endpoint will now return custom fields. • The Developer Center for Plugins now shows the filename in the list of hooks, and when editing a hook, a breadcrumb includes a link back to the list. • Inline notifications can now be dismissed • Efficiency improvements to the search index • You can now close a poll independently of the topic

Forum upgraded to 4.0.10.2. User / Followed Content wasn't working.

Added a "Post #" indicator at the top right of a post as I know some people like saying "look at post #4" rather than linking.

Added a "Back to Top" button.

2nd attempt to upgrade to 4.0.9 The bug when creating a link to a post and & being turned into &amp; should be fixed. Release Notes In addition to many bug fixes and performance improvements, some specifics include: New Features & Settings Legacy PayPal gateway to allow for older PayPal Subscriptions to still be recognised.Attachment Type Restrictions: You can now choose from three options for file attachments in any post content: No files, Images only (this will actually check to make sure an uploaded file is a valid image) or All files (this is default) - If you choose "All files" you have the option to provide a list of allowed file extensions.Merge Concurrent Posts: If a user makes a post or comment and then makes another post or comment on the same item before any other user, the posts will be merged. There is a setting to disable or set the time limit for this to happen. There is a clear, visual indication when a merge happens to avoid confusion to the end user.Moderators can click and hold on topic and other item titles to quickly edit.New setting to optionally set products in Commerce to have a grace period to remain active for a period of time after expiration.New setting to specify domains to exclude from having rel='nofollow' added to links.The "+ Create" menu at the top of the page now has an option to create an announcement.New button to post a status within the status updates widgetYou can now embed Pages database entries by pasting their link.New widgets for blog entry, gallery images and downloads files feeds.Widgets displaying content feeds can now be given a custom title.Other Improvements The subject lines for emails sent about new content have been changed slightly so email clients can group them better.Some widgets providing duplicate functionality have been merged. For example, "Latest Topics" has been merged into "Topic Feed".Announcements now show on every page by default (but can still be removed).When upgrading, if you have a large database you are presented with an option to run queries manually. You can now opt to run them anyway.Disabling Applications New ability to disable but not uninstall an app.IPS apps that are not up to date will be disabled on upgrade to prevent things breaking.The Support system in the AdminCP will now disable non-IPS apps in addition to all plugins as part of its diagnostics. It will also show you a list if what it is disabling to help you find problems.Notes for translators The public-facing navigation tabs now have language strings separate from the application title (this means translators will need to re-translate the application tabs upon upgrade).

I did an upgrade to the latest version but rolled it back because a couple of things were looking dodgy at the backend. I think there were 10 posts that got removed as a result.

Had a bad error during an installation and the forum database got corrupted. I gave up trying to fix it after a couple of hours and have restored this morning's backup. Sorry for the inconvenience.

Forum updated to 4.0.7 from 4.0.6.

Added a plugin to show recently updated files in the Downloads section.

I added a plugin to restore ability to view user's Display Name history. It's in the profile view at the top right.

Removed the geshi code highlighting. It was causing some problems for a few users. No idea why. Edit: Tweaked the code and re-added for testing. Edit: And removed again.

There appears to be a problem uploading .au3 files into the Downloads system. I thought it was mime type related but after some testing I'm fairly certain that it's a weird bug caused by the file extension ending with a numeric. I've reported the bug and the workaround for the time being is upload as .zip.

I've reset the editor, I think the trac button might have been causing issues.

Since the last upgrade, several members have reported that they cannot get an editor pane when trying to post. There is nothing that can be done at the server end - it seems that this is a cache/browser issue when the editor javascript does not load. The only thing we can suggest is to clear the browser cache and restart the browser. M23

Forum upgraded from 4.0.5.1 to 4.0.6. Release Notes

I've got an implementation of the code collapse/expand/popup buttons working. This was the main thing missing from the new forum in my mind. ; ; Checks the documentation for various errors #Region Includes #include "include\OutputLib.au3" #EndRegion Includes #Region Global Variables #EndRegion Global Variables #Region Main body of code Global $g_nExitCode = Main() Exit $g_nExitCode #EndRegion Main body of code #Region Main() ; =================================================================== ; Main() ; ; The main program body. ; Parameters: ; None. ; Returns: ; None. ; =================================================================== Func Main() Local $nReturn = 0 ; Create the output window and initial message. _OutputWindowCreate() _OutputProgressWrite("==== Output for " & StringTrimRight(@ScriptName, StringLen(".exe")) & " (Help Check) ====" & @CRLF) _OutputProgressWrite("Checking... ") ; The path to the Help Check directory. Local Const $sPath = @ScriptDir & "\include\Help Check" ; The path to the Help Check script. Local Const $sScript = $sPath & "\Help File Check.au3" ; Build the full command to execute. Local Const $sCmd = '"' & @AutoItExe & '" /AutoIt3ExecuteScript "' & $sScript & '"' ; Run the script. $nReturn = _RunWaitForwardOutput("_OutputBuildWrite", $sCmd, $sPath) ; Check the return value. If $nReturn Then _OutputProgressWrite("failed (" & $nReturn & ")." & @CRLF) Else _OutputProgressWrite("complete." & @CRLF) EndIf ; Write closing message and wait for close (if applicable). _OutputProgressWrite("Finished." & @CRLF & @CRLF) ; Two CRLF's in case of chained output. _OutputWaitClosed($nReturn) ; Return the value. Return $nReturn EndFunc ;==>Main #EndRegion Main()

Forum upgraded to 4.0.4 Release Notes

Forum upgraded to v4.0.3 - General bug fixes. Release Notes

There has been a problem with the conversion of posts that contain backslashes outside of code blocks and they have been stripped out. So this: C:\Program Files\Something Will have become this: C:Program FilesSomething However anything that was using the [ code] or [ autoit] code boxes will be ok (i.e. the really important stuff) because they were processed differently during the upgrade. ; This will have been ok $var = "C:\Program Files\Something"There is no easy way to fix this aside from doing a full rollback to Saturday morning, and as the code boxes are intact I'm not going to do that. I'm going to write some scripts to look for commonly used paths that are used to fix them up, such as: C:\Program Files C:\Windows C:\Windows\System32 C:\Program Files\AutoIt C:\Program Files\AutoIt\Include  

Fixed up broken [ img] tags in signatures. That's all now. If there are still broken signatures they'll have to be fixed manually.

Search is online.

Signatures have been rebuilt but there is a bug so most bbcode still hasn't converted. In the majority of cases if you just open your signature for editing and then save it, it should be ok. Edit: I've run a script to fix up 'color' bbcode in signatures. Still have img and url to do.

We want the forum to be a pleasant place for everyone to discuss AutoIt scripting, and we also want to protect the reputation of AutoIt. So we ask you to respect these simple rules while you are here: Forum Posting 1. Do not ask for help with AutoIt scripts, post links to, or start discussion topics on the following subjects: Malware of any form - trojan, virus, keylogger, spam tool, "joke/spoof" script, etc. Bypassing of security measures - log-in and security dialogs, CAPTCHAs, anti-bot agents, software activation, etc. Automation of software/sites contrary to their EULA (see Reporting bullet below). Launching, automation or script interaction with games or game servers, regardless of the game. Running or injecting any code (in any form) intended to alter the original functionality of another process. Decompilation of AutoIt scripts or details of decompiler software. This list is non-exhaustive - the Moderating team reserve the right to close any thread that they feel is contrary to the ethos of the forum. 2. Do not post material that could be considered pornographic, violent or explicit - or express personal opinions that would not be acceptable in a civilized society. Do not post any copyrighted material unless the copyright is owned by you or by this site. 3. To protect this community, any files posted by you are subject to checks to ensure that they do not contain malware. This includes, but is not limited to, decompilation and reverse engineering. 4. Do not flame or insult other members - and just report the thread to a Moderator (see below) if you are so attacked. 5. Do not PM other users asking for support - that is why the forum exists, so post there instead. 6. Do not create multiple accounts - if you inadvertently created multiple accounts then contact a Moderator to close the unwanted ones. 7. Do not repost the same question if the previous thread has been locked - particularly if you merely reword the question to get around one of the prohibitions listed above. 8. Do not delete your posts, nor completely remove their content, if doing so will interrupt the flow of the thread. 9. Do not post in a thread while the Moderating team are actively trying to determine whether it is legal. The Moderation team will do their best to act in fair and reasonable manner. Sanctions will only be applied as a last resort and any action taken will be explained in the relevant thread. If moderation action is taken, you will need to acknowledge this through a dialog or you will be unable to post further in the forum. Please note that this dialog is not an agreement that the warning was justified - it is only there so that members are aware that moderation action has been taken and that they may have certain restrictions applied to their account. If you feel that you have been unfairly moderated then contact the Moderator concerned - using a PM or the "Report" button is preferable to opening a new thread (although new members may have to do this). But do be aware that the Moderation team has the final word - the rules are set out by the site owner and you are only welcome here if you respect his wishes. Signatures and Avatars There is no formal policy for the use of signatures but if a moderator thinks it is too big and/or distracting then you may be asked to tone it down. No-one likes wading through signatures that are a page high. Similarly for avatars, expect distracting flashing and animated gifs to be removed. Reporting If you feel a post needs Moderator attention, please use the "Report" button next to the post date at the top. You can then enter details of why you have reported the post - but there is no need to include the content of the post as that is done automatically. The Moderating team will be alerted to the post and will deal with it as soon as they can. If you suspect a EULA violation, do not expect the Moderating team to do all the work - please provide some evidence in the report such as a copy of (or link to) the EULA in question, as well as the section you believe has been violated. Finally, please do not enter into an argument with the original poster - that is why we have Moderators. Spam Please do not react to spam in any way other than reporting it. Multiple reports are combined by the forum software, so there is no need to announce that you have reported the spam - in fact doing so only increases the work for the Moderator who deals with it. Interacting with this website Anyone found abusing the website is subject to harsh punishment without warning. A non-exhaustive list of potential abuses include: Automated forum registration or login. Automated posting or sending messages on the forum. Automated manipulation of polls, user reputation or other forum features. Automated creation or comments on issue tracker tickets. Automated creation or editing of wiki pages. Other abuses which are either examples of excessive bandwidth usage or automation of the site. Use common sense. If you do not have common sense, don't do anything. Do not automate the forum, wiki or issue tracker in any way at all. Scripts which automatically update AutoIt such as AutoUpdateIt are acceptable as long as they are not abused and do not generate excessive bandwidth usage.

The irony is that I'm not entirely sure that this topic doesn't infringe on the last point of having a google trademark in the URL. I hope it means the domain name url part and not anything else ...

This is due to me getting my Adsense account almost closed due to my "abuse". I only get 3 days warning when a violation occurs (which is easily missed in the console). Also it's not clear how many warnings trigger "bad things". Thanks for your cooperation

You are responsible for the content you post on this site. Most of the site is a public forum and the private sections have only limited controls over those who can access them - this is particularly true of "Chat". So treat posting here as if you were speaking in a crowded room surrounded by strangers. Recent high-profile defamation events on other sites illustrate that there are ways in which third parties can force personal data, including contents of personal messages, to be released by site owners. Be careful - libelous/defamatory posts can and have landed members of these other sites in legal hot water. Your anonymity is not guaranteed in such situations. M23

An update. I was not able to get the conditional formatting to use the correct relative reference for the comparison cell. I'd tell it =$B43, and the rule in the spreadsheet would be =$B4. I'd run it again and get different results. I didn't spot a pattern. That was when I was adding data to an existing sheet, tacking my results on below any filled cells. I switched to RC references in the comparison, and it worked. Here's the final code snippet: If $SAPDonglePosition Then Local $endrow = UBound($arOutput) With $workbook.ActiveSheet.Range("$" & $SAPDonglePosition & "$" & $startrow + 1 & ":" & "$" & $SAPDonglePosition & "$" & $startrow + $endrow - 1).FormatConditions.Add(1, 4, "=RC[-1]") .Font.Colorindex = 30 .Interior.ColorIndex = 22 EndWith EndIf

The Forum Rules specifically mention that "keyloggers" are a prohibited subject on this forum. Of late we have had several threads locked because they have strayed (usually unwittingly) into keylogger territory. Here is a reminder of what Jon (the site owner) has set out as the basis for acceptability: "how to check for a few keys being pressed is one thing" We are not going to define "a few" in absolute terms, but if you post any code which checks for the best part of the keyboard you can be absolutely sure that you are in breach of the rules, that your thread will be locked, and that sanctions may follow. So please do not post such scripts - we do not want to be heavy-handed, but after this announcement your excuses had better be very good ones! M23

I have this piece of code for generating an excel graph. Can some one help me in defining the "Range" in a different numerical way? ex. can i set the range as 1,1:2,2 instead of A1:B2? (This is not working anyway!) thanks in advance. Dim $oXL ;2 $oXL = ObjGet($FilePath) $oXL.Windows(1).Visible = 1 $oXL.Worksheets(1).Activate $oXL.ActiveSheet.Visible = 1 $oXL.Application.Visible = 1 $oXL.Charts.add() $oXL.ActiveChart.ChartType =51 ;bar chart= 51 $oXL.ActiveChart.SetSourceData($oXL.Worksheets(1).Range(A1:B2))

I use the following code written by Spiff58 to convert numbers into columns. ; =============================================================================================================================== ; Convert column numbers to excel column letters ; Written by Spiff59 ; http://www.autoitscript.com/forum/index.php?showtopic=115665 ; =============================================================================================================================== Func _ExcelColumnLetter($iColumn = 0) Local $letters While $iColumn $x = Mod($iColumn, 26) If $x = 0 Then $x = 26 $letters = Chr($x + 64) & $letters $iColumn = ($iColumn - $x) / 26 WEnd Return $letters EndFunc

Open console then type "hack -n PERSONTOHACK -hide -override"All done