Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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