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!

Search results for query: *

  1. Tiglet

    Display missing group items in pivot

    Assuming you are using the Excel Add-In, then turn off the suppress missing option, then those cities will show with #missing or whichever mask you have applied to missing values Tiglet [reading] Living on Earth is expensive, but it does include a free trip around the sun every year
  2. Tiglet

    Custom lists/series in Excel 2003

    Thanks, Have a star - I've obviously indulged in too much beer over New Year. In fact when I sit quietly I'm sure I can hear my brain cells dying one by one Tiglet [reading] Living on Earth is expensive, but it does include a free trip around the sun every year
  3. Tiglet

    Custom lists/series in Excel 2003

    I'm sure there used to be a feature of Excel that allowed you to create your own series so you could effectively autofill across rows and columns. I think weekdays were built in automatically but you could write and add your own. I'm now using Excel 2003 and can't find it - Have I completely...
  4. Tiglet

    FSO (File System Object) & Shortcuts

    After a little more digging, apparently it's a "bug" in the FSO where it returns the attributes of the target file rather than the shortcut so a different approach is definitely needed. Thanks for all the suggestions Tiglet [reading] Living on Earth is expensive, but it does include a free...
  5. Tiglet

    FSO (File System Object) & Shortcuts

    Okay, thanks guys, I'll have a look & let you know how I get on Cheers Tiglet [reading] Living on Earth is expensive, but it does include a free trip around the sun every year
  6. Tiglet

    FSO (File System Object) & Shortcuts

    Yep, unfortunately, I've tried retrieving only *.lnk files but the FSO then retrieves the attributes of where the shortcut points to. This is really bugging me :-( Tiglet [reading] Living on Earth is expensive, but it does include a free trip around the sun every year
  7. Tiglet

    FSO (File System Object) & Shortcuts

    I have some code which effectively replicates the functionality of the Search function within Windows. However, when I am searching for files and it picks up a shortcut, it is capturing the attributes of the file that the shortcut points to rather than the shortcut itself. I have looked at the...
  8. Tiglet

    Built in Properties in Excel Docs

    xlhelp, Sorry, I actually posted this initially in the wrong forum - I've now posted it in the VBA forum and there is a thread ongoing there. The ActiveWorkbook approach doesn't seem to work as I'm not actually opening the files with the main code. If you would like to have a look at the thread...
  9. Tiglet

    List of Excel files with document properties

    I would if I could!!! I have this..... Sub test() Dim FileName As String Dim DSO As DSOFile.OleDocumentProperties Set DSO = New DSOFile.OleDocumentProperties r = 1 Workbooks.Add Dim xlsname As String Dim strauthor As String FileName = "C:\document.xls" DSO.Open sfilename:=FileName strauthor...
  10. Tiglet

    List of Excel files with document properties

    On Dim strauthor As BuiltinDocumentProperty it says "Compile Error User Defined Type not defined" I tried it as Dim strauthor As DocumentProperty as well. Do I need to do something else so the BuiltinDocumentProperty bit is defined? Tiglet [reading] Living on Earth is expensive, but it...
  11. Tiglet

    List of Excel files with document properties

    Skip, Unfortunately, I've tried that and I think it kicks out because it is an ActiveWorkbook reference. I don't want to have to open every workbook as it will take forever, some may have passwords and I guess it would change the date last accessed property anyway. It will be running on Excel...
  12. Tiglet

    List of Excel files with document properties

    Skip, Yep, I tried that but couldn't seem to get it to work in conjunction with the existing code. I don't think I'm defining it correctly. My code is at home, so I can post it in its entirety shortly Cheers Tiglet [reading] Living on Earth is expensive, but it does include a free trip...
  13. Tiglet

    List of Excel files with document properties

    Hi, I am trying to extract a full list of all Excel Spreadsheets on a drive showing their path and various document properties. I have found this excellent example on the web...
  14. Tiglet

    Format column cell to be 6 characters long

    Skip, Neat! and solves the "only picks up 4 & 5 characters long" of mine. I love it! Tiglet [reading] Living on Earth is expensive, but it does include a free trip around the sun every year
  15. Tiglet

    Format column cell to be 6 characters long

    Assuming Data is in Col A (starting at Row 1), then put this formula into Col B. NB.This will only resolve data that is 4 & 5 characters long. Everything else is assumed to be 6 characters =IF(LEN(A1)=4,"00"&A1,IF(LEN(A1)=5,"0"&A1,A1)) Tiglet [reading] Living on Earth is expensive, but it...
  16. Tiglet

    Built in Properties in Excel Docs

    Hi, I am trying to extract a full list of all Excel Spreadsheets on a drive showing their path and various document properties. I have found this excellent example on the web...
  17. Tiglet

    Format of elapsed time including fractions of seconds

    asrisk, I am a muppet. That was the problem all along!! Have a star! Tiglet [reading] Living on Earth is expensive, but it does include a free trip around the sun every year
  18. Tiglet

    Format of elapsed time including fractions of seconds

    asrisk, You're right, my apologies! Post should have read B1-A1 I still cannot get the formatting right though. I am now attempting to split the calculation using SECONDS-SECONDS however this still doesn't work. Tiglet [reading] Living on Earth is expensive, but it does include a free trip...
  19. Tiglet

    Format of elapsed time including fractions of seconds

    Hi, Does anyone know a way of taking elapsed time away from another elapsed time and showing the correct format. Eg 00:00:44.44 - 00:00:46.08 = 00:01.64 (The 00:01.64 is the bit I'm struggling with - I currently have a formula of A1-B1 - I'm assuming this would remain the same) Thanks...
  20. Tiglet

    Adding totals

    SUMIF would work and would have the benefit of being dynamic. A pivot table has the benefit of looking pretty and will capture all of the claim numbers. It would summarise all of the claim codes and all of their total claims in one go. There is a pivot table wizard and to help you get going...

Part and Inventory Search

Back
Top