ICANSEEYOU7687

This maybe WAYY to general of a question. But I have a user here that somehow had a huge junk of his emails duplicated (thousands I believe). Would there be an easy way to index all the emails, cycle through them and tell if an email is a duplicate of one?

I am going to try not to post my code. I am not the most creative programmer and dont want to embarrass myself. (Although this might be the problem to begin with) But I am trying to use DriveMapAdd("Q:", "\\xxxx\xxx\xxxx") in my code, and it does not work at all. But if I make a new script, and use the exact same line it works perfectly. Ive tried with several different methods, including using the net use Q: command with @ComSpec, with different arguments, and every place I can think of. I even placed it right after the Func OnYes(). The drive does exist, as it works if I run the same line of code as a new script. This would tell me my code is doing something funky. So if I need to post it I can, I wil just need to try to clean everything up a bit As always, sorry for my dumb questions, but everyone here is so helpful!

When you open a connection to AD, is the information sent in plain text?

Sorry if these seem really dumb, I havent used autoit in a while and my programming is a little rusty. I have a script in mind that I want to try, and it is mainly going to require waters AD scripts. One of the first things that I need to do, is create a folder on a network drive as a different users. I am going to make a service account hard coded into the script that is used for some initial folder and file creation depending on the user that does this. Is it possible to create a networked share as a different user? I feel like you might be able to do this with command prompt but I have no idea XD Also on a similar note, can I add AD domain accounts as permissions on a network folder from another account? Once again I will use that service account I create in AD (which will have permissions on the root folder). Once the script creates the folder, it will then add the users account to the folder permissions list. I hope this wasnt to confusing, but everyone here is always so helpful! Thanks for looking! -Wesley

Thanks! I have been fiddling and its not a file thing like I thought. Its a termination thing. My loop is not terminating correctly like it was in the first excel file. I do not know why but I should be able to work with this a little better

Im really frustrated and confused. I have two almost identical excel spreadsheets I am trying to load into autoit I am using... Global $oXLC_Excel = _ExcelBookOpen("C:path375.xls") Local $aArray = _ExcelReadSheetToArray($oXLC_Excel) My first excel file it loads fine, but the next one it cant load it into an array and i have NO idea why. The have different data in them, but are structurally identical. And if someone could refresh me on how to use the @error...its been a while and google returned nothing helpful. I just dont understand why its not even loading. It definitely finds the file fine, and it even opens the excel document correctly. Any help would be greatly appreciated. Thanks *EDIT* if I can just do If @error Then MsgBox(0, "Failure", @error) Then this is returning a "1", which is saying object does not exist. When it does clearly find and open the excel sheet.

That seemed to work! Now if I pull out these values as text, and I for example take out two numbers 13:00 and 12:00 and I strip out the 13 and 12 and tried to subtract them will this cause issues if they are not considered integers? Thanks!

Here is the very generalized code i was trying to run. I have a lot more, but I just grabbed the parts that I thought were relevant #include <Excel.au3> Global $oXLC_Excel = _ExcelBookOpen("test.xls") Local $aArray = _ExcelReadSheetToArray($oXLC_Excel) ; $Cell = $aArray[2][5] MsgBox(0, "Cell", $Cell) Thanks for your quick response!

This is like my third post today and im sorry! I hate to be annoying... But now I am pulling in data from an excel sheet and the data im looking at is time. For example the time in the sheet says 1:00:00 PM, but since this is set to a time format, this is not its actual value. If you change the cell from time to "general" the value changes to 0.58777777 (or something like that) Does anyone have any experience with this? What I would really like to do is simply change the 1:00:00 PM to military time (So this would be 13:00), but by changing the format options, this only changes the way the cells are seen, but not the value that autoit pulls. Thanks! -Wesley

Worked! Thanks, I havent used autoit in a while and im a bit rusty. Thanks!

Sorry if this is a silly/stupid question, but I was curious how to do this. I am trying to check dates in an excel column to get usage statistics, and the date is formatted like MM/DD/YY. I would like to pull this out as a string, and separate this into 3 variables for month, day, and year to be able to do some basic calculations on. Is there an easy way to do this? Thanks

In a nut shell I have some excel files with data extracted from calendars and I am trying to get some statistics. One of the things I would like to do is compare on which days certain things happen. So I was curious if anyone had an easy way to convert a date in a format (something like XX/XX/XX) to a day Mon-Fri. Thanks!

im currently in the process of making a raided file store at home using freenas or openmediavault, or something similar. i had an idea of making my own dropbox like storage, where i can put a file into a specified folder, and it would automatically upload to my file storage. i would prob use some kind of encrypted ftp, but am unsure how well this will work with autoit. i have done some autoit, but this maybe beyond my scope, lol. but basically... i think the script would always be running, and check to see if the file already exists, and if not transfer it, and it could either check when a change was detected, or maybe check every ten minutes or something. or maybe if there is an dtp functuon a,ready, set a default override existing file to "no" just curious if anyone had any ideas, its going to be a while before i finish my system

Unfortunately I will not be back at work to work on this until friday. But I have tested the value of iValue for the accounts created after the password is set, and this does, in fact, return a value of "1"... Thanks for taking time and helping, either way!

Yes $iValue = _AD_SetPassword($username, "Pass.word1234") Does seem to work fine... But Global $sAD_Password = $first & $last &"1234" $iValue = _AD_SetPassword($username, $sAD_Password) Does not work.