Recent content by AKarim

Hi Glenn no you are right the link isn't working, a friend sent me the link and the code, so I hadn't tried it. I have the code but have issues on the site too Cheers K.

Just to update, found an alternate solution (requiering additionnal functions) you can use an Excel addin : http://xcell05.free.fr/morefunc/english/ works perfectly ! thanks to you guys for having taken time to answer ! if any solution without this tool, still welcome of course, but I guess...

hi, Glenn, you are right it actually works with the file opened, not when it's closed, but I need it to be closed :-( (because the update will be digging in 15 other files, so I don't want to have to open the 15 files each time) Skip, sorry I don't catch your question

In fact if I put ='C:\completepath\Site1\Proj1\ExcelProj1.xls'!_Name this works If I change into ='.\relativepath\Site1\Proj1\ExcelProj1.xls'!_Name doesnt works (opens the windows to choose the xls file for the ref) and when I try...

Hi Skip yep I tried this out, but don't know why it doesnt work Can't remember if I have to insert specific characters in front of the ' in the string ? ...$B2;".xls''!_...

Hi to all I have an issue getting the value of a cell from a file to an other : I have created the files and docs as follow : Portfolio Portfolio.xls Site 1 Proj1 ExcelProj.xls Proj2 .... Site 2 ... In ExcelProj.xls I have named the cell L1 ...

Thanks SkipVought, the reason why I had to create those multiple worksheets is that the calculation of those costs are completely different, I thought about merging, but I can't do it, the worksheet is un understandable afterwards. Any other clue please ;) ?

Hello to all, I have a file with multiple informations about costs in 5 different worksheets having different columns. I'm generating 5 PivotTable from each of those 5 worksheets to format all of them the same way : A B C D CostYear1 CostYear2 CostYear3 This works fine...

Hi all, How can I print all the informations concerning my contacts from the names.nsf as we could do in organizer (address, phones, ...), but without having only one per page ?

No, the T20 uses a win2k, and the PC a win 98.

Hi I would like to know how could I transfert datas from the hard drive of my IBM T20 computer to my PC. I do not have any network. I think it is possible to do so via the serial or parallel por, do I need a special soft and how do I configure the ports. Thanks for any help.

Hi I would like to know if it is possible to delete, or maybe even better synchronize my ISP mail and my Notes pro mail ?? Allways when i replicate my mail with my ISP i get all the mails that are on the server, even if I have all ready downloaded them previously and deleted them on my notes...

Hi I allways have a problem using Notes : in the Sent view, you can see all sent messages, including the filed ones. When you want to delete the sent messages you have in this view the sent mailed and the filed sent mesasges (that in fact you would like to keep). So I'm trying to do a view, same...

Yes, Mike, this works really fine, but not in a MDIForm !<br>There's no KeyDown event in that type of form...<br><br>Karim

The problem is that there is no OnFocus event for a Label