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!

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

Recent content by littlek

  1. littlek

    Problem with File Size?

    Hi, I have tried many ways that I could think of, to keep the file size to as small as possible. Currently, I have a file which three worksheets have formula linked to another file. Because the number of lines in the source file are varied from month to month, that means I have to go into the...
  2. littlek

    In Excel, How do I Delete any row where a particular string occurs?

    AdmiralSeb, I assume that the sheet that contains the data is the active sheet, then make small modification to the code below Sub DelRowIfStringFound() Dim i As Integer Dim sStringSearch As String Dim iNumbofRows As Integer Dim sActiveSheet as string sStringSearch =...
  3. littlek

    How to find out who has the workbook opened when open file via Macro

    Thanks, Geoff. You are a true hero. Looking forward to your findings. Littlek
  4. littlek

    In Excel, How do I Delete any row where a particular string occurs?

    Try this code. Sub DelRowIfStringFound() Dim i As Integer Dim sStringSearch As String Dim iNumbofRows As Integer sStringSearch = "kk" iNumbofRows = 100 Sheets("sheet4").Select Range("A1").Select For i = 1 To iNumbofRows...
  5. littlek

    How to find out who has the workbook opened when open file via Macro

    Thanks for taking the time to reply my thread. Yes, when you open a workbook that is currently being modified by another user by a macro, Excel just goes ahead and opens the workbook with Read-only right. Thanks.
  6. littlek

    How to find out who has the workbook opened when open file via Macro

    Any suggestion to the problem is very much appreciated. When opening a workbook currently being modified by another user via a macro, Excel opened the file with Read-Only, without prompting with details as to who has the workbook opened. Is it possible to make the macro to pop up a message box...
  7. littlek

    How to find out which user has the file opened

    Pcfred, Thanks for reply to my thread. However, I have not mentioned the file is opened via macro, not manual (ie., file, open). littlek
  8. littlek

    How to find out which user has the file opened

    Can anyone hepl me with my problem. How do I find out which user has the workbook opened, by a dialog or mesage box, and then open the workbook and notify me when the workbook can be updated. Mny thanks.
See more

Part and Inventory Search

Back
Top