Recent content by ankuun

Sajan; Good idea! I will try that but returning 1 for anything greater or equal to 1 might be a problem. Narayank; Its good to hear from you again! Your answers are always awesome! Good article and nice suggestion.

Hello everyone, My pivot table returns zeros in -1.86517468137026E-14, 1.46549439250521E-13, -2.28261853862932E-13 format and I need my formulas to read this as zeros. I changed the output numbers to accounting, numeric but it didn't work. Example; Pivot output A1: -1.86517468137026E-14 A2...

Shrivallabha, This code is excellent. Thank you and everyone in this thread so much for your help! You guys are awesome!

Shrivallabha, I love the recent code!!! Your code worked great but I have one more thing to ask; excel list doesn't update when I delete one of the files in the folder It only updates when a new file is added. Do I need to make this a loop?

shrivallabha: First one (ListAndHyperlink) worked great and it is exactly what i needed. Actually, is it possible to hyperlink the file names instead of heaving a separate list that says click here? Thanks a million! Krishnakumar: Thank you so much for the link. It is great to be able to...

All, I am kind of new to vba and I got lost during your discussion. Would anyone explain whats going on little more simply? Thanks!

I found this online and it looks like it would work but how do I hyperlink them? Also, thanks for those links SirJB7 Sub ListAllFiles() Dim fs As FileSearch, ws As Worksheet, i As Long Set fs = Application.FileSearch With fs .SearchSubFolders = False ' set to true if you...

I had no luck! Do you have the link by any chance?

Hi all, I need a macro to look into a folder (i.e. C:\Documents) and list all the files (*.pdf) in a spreadsheet and hyperlink them. Thank you very much!

This works great! You got it to work exactly how I wanted it. Thank you very much Narayan. You are really good at this! I really hope you will be interested in my future questions/posts :) I greatly appreciate your help!

I see! That changes everything, I can't believe I missed constants part. However, I still can't get "ClearContents" part work separately. Whenever I run the macro, it clears the first row when there are several more rows.

Narayan, Your code looks like it would work but for some reason it only clears the firs row without deleting any other rows. When I read your code, looks like it got everything and there is no reason why it wouldn't work. I think I need to spend some time on modifying your code. Thank you so...

Hi, Yeah, whenever its convenient for you. I really appreciate your help! Thank you!

Narayank, I really appreciate your help and interest. This is a very silly (but annoying) problem and I will try to explain all the requirements. The whole idea was making a form without using Infopath. I wanted copy InfoPath's Repeating table option to excel. Row 6 will always be there to...

Narayan, I have been trying this code and I am still having difficulty with clearing row 6. The code you posted clears row6 at the same time with row 7. I mean, when you try to delete row 7, it automatically clears row 6 too. I think I need a private macro where this macro (above) will run...