Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. AKarim

    Links to closed files using a relative file path

    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.
  2. AKarim

    Links to closed files using a relative file path

    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...
  3. AKarim

    Links to closed files using a relative file path

    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
  4. AKarim

    Links to closed files using a relative file path

    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...
  5. AKarim

    Links to closed files using a relative file path

    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''!_...
  6. AKarim

    Links to closed files using a relative file path

    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 ...
  7. AKarim

    PivotTable from a PivotTable

    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 ;) ?
  8. AKarim

    PivotTable from a PivotTable

    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...
  9. AKarim

    Print the personnal address book contacts.

    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 ?
  10. AKarim

    Transfert datas from a IBM T20 to a PC

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

    Transfert datas from a IBM T20 to a PC

    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.
  12. AKarim

    Delete Internet mail from server when replicated

    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...
  13. AKarim

    Folder archive Field name

    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...
  14. AKarim

    Keyboard shortcut on a button

    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
  15. AKarim

    Keyboard shortcut on a button

    The problem is that there is no OnFocus event for a Label
  16. AKarim

    Domino v5 & NT service

    Hi everyone<br>How do i launch the Domino server v5 from NT service ? How the .exe called thnxs for any help !<br>KArim
  17. AKarim

    Keyboard shortcut on a button

    Yes i thought about doing this after Mike gave his solution, but i'm using a MDIForm and events are only on mouse actions.<br><br>thnx to U<br>Karim
  18. AKarim

    Keyboard shortcut on a button

    Yes thanks Mike for the idea !!!<br>I tried it it works, as long as the menu is visible [As my window musnt have a menu the shortcut do not work]<br>Any other idea, or maybe is there a way of using the menu option invisible ?
  19. AKarim

    Keyboard shortcut on a button

    Hi, <br>I have a graphical button, without any caption. I would like to assign a shortcut to it, but I only know to put &quot;&Compose&quot; in the caption property so that it works. The only thing is that if I do so the text appears in the button even if it is a graphical button. <br><br>Does...
  20. AKarim

    Export a report with VB

    For information :<br>&nbsp;&nbsp;&nbsp;&nbsp;Dim Result As Integer<br>&nbsp;&nbsp;&nbsp;&nbsp;Dim MainJob As Integer<br>&nbsp;&nbsp;&nbsp;&nbsp;Dim InitFile As Integer<br>&nbsp;&nbsp;&nbsp;&nbsp;Dim ExportName As String<br>&nbsp;&nbsp;&nbsp;&nbsp;Dim CrystalName As...

Part and Inventory Search

Back
Top