Maarten002

Oops, i forgot the "%1" at the end of the path , that was why my script was giving a lot of strange errors (in line 400 and something while my script only had 5 lines...). Thanks a lot, very appreciated!

I'm writing a script that i want to put in the contextual menu of the finder. I was already able to put the compiled script in the contextual menu (HKEY_CLASS_ROOT/*/shell/...). The thing I'm missing is how to get the name of the file/files that i right clicked on. Anyone an idea? Thanks

Ahh, found it, these pdf files were compressed and therefore the code looked scrambled when I opened it with a texteditor. I decompressed them and now I'm able to translate them. Problem solved .

Hi all I need to translate several pdf files. I have the original strings and their translation in a excel table, so putting them in an array and loop trough that array is not an issue. However, I have no clue how to find/replace a text in a pdf file. I've opened the pdf in a texteditor but was unable to find any of the strings... It seems that the pdf is encoded/encrypted/locked in some way. Anyone has an idea? Thanks

Alright, I'll give that a go. I just hope I'll not get lost in the scare brackets . Thanks Melba23!

Hello all A 2D array can be initialized like this: $array[3][4]=[ ["00","01","02","03"],_ ["10","11","12","13"],_ ["20","21","22","23"]] But how can I initialize a 3D array ($array[3][4][2])? Thanks

Maybe i misunderstand your question #4, but the position of the icons on you desktop are saved in the registry at this location: HKEY_CURRENT_USERSoftwareMicrosoftWindowsShellBags1Desktop ItemPos...(display resolution) But how to interpreted this info, i don't know...

Awesome, that did the trick! Thanks.

That sounds a lot faster! Problem is that i'm already using this in a script with over 1000 lines where i use this "object" to get all my info. If i have to rework all this, it would take some time and i don't think my boss would like to hear this . Stupif thing is that i didn't noticed it earlier because in the past days, i was using an excel sheet that did had a header (that wasn't important for the script) and so i didn't noticed the not-reading of the first row... But thanks for the responce, if nobody can tell me what i'm doing wrong, i'll rewrite the script and go with your approuch (or i just add an empty row at the beginning of the sheet...).

Hi water, thanks for the reply. Problem is that the build in functions are a bit to slow on big files (over 300000 lines), and this script needs to run on big files

Hello all I'm trying to read a sheet of an excel file but for some reason, the script below is giving me the first cel of the second row in stead of the first row. Any idea what i'm doing wrong? Thanks! Const $excelFile=@ScriptDir & "\Test.xlsx" Const $excelSheet = "[Sheet1$]" Global Const $adOpenStatic = 3 Global Const $adLockOptimistic = 3 Global Const $adCmdText = 0x0001 $objConnection = ObjCreate("ADODB.Connection") $objRecordSet = ObjCreate("ADODB.Recordset") $objConnection.Open ("Provider=Microsoft.ACE.OLEDB.12.0;" & _ "Data Source=""" & $excelFile & """;" & _ "Extended Properties=""Excel 12.0 xml;HDR=Yes;IMEX=1"";") $objRecordSet.Open ("SELECT * FROM " & $excelSheet, $objConnection, $adOpenStatic, $adLockOptimistic, $adCmdText) $objRecordSet.MoveFirst ConsoleWrite($objRecordSet.Fields(0).value & @CR)