Replies

Memories…..

Whoooa….

Wicked Steve, that did fix both issues, Thanks.

I have learned from this and can use this code structure in future. Thanks very much!

Hi,
Steve’s latest workbook sample works for me if I enter 1/14/2010 or 1/15/2010, but not if I enter 1/14/2010 or 1/15/2010. What I fail to understand is that the date’s in the worksheets are formatted as dd/mm/yyyy, or is that just how I see it on my pc due to my windows date settings?

I cannot get it to work with dd/mm/yyyy at all.

Sorry for hijacking the thread, it’s just that I was interested to see this working.

Nathan

Hi Andy,

I am going to need to take a back seat on this one I’m afraid as my experience in insufficient in this area. I am hoping that Jerry or another lounger will be able to assist you, I will be looking on and hoping to learn from it as I am very interested in this type of thing. I just never know where to start…..

Goog Luck

Nathan

Hi Ankit,

I’m not currently in a position to assist with the 2nd part of your requirement until I can get the 1st part working properly. If you answer Steve’s last post then hopefully we will be able to move on from there.

Nathan

But you don’t mention where the issue is. Which date is wrong and what is it doing exactly as it works through the code?

Steve

Hi Steve,
I am hoping that another lounger may comment that uses the UK date format dd/mm/yyyy. I spent a fair bit of time yesterday playing with this and it mostly works, by that I mean the code steps through and works as expected. However, the filter does not generate the correct result.

The individual sheets all have 4 rows of data, 2 rows for 14/01/2010 and 2 rows for 15/01/2010. Therefore if I enter the date as 14/01/2010, I would expect each sheet to be filtered to 14/10/2010 each showing 2 rows, and therefore 10 rows of data being copied to the consolidated sheet.

The result that I get is each filter shows nothing, but all 20 rows are copied to the consolidated sheet. In my previous attachment, I commented out the “reset filter section” so that when the code is completed I can see the filter result. Clicking the dropdown arrow shows that 14/10/2009 is selected, even though no data is visible. Re-selecting 14/10/2010 manually at this point shows the correct result, with 2 data rows visible.

How all data is copied to the consolidated sheet when there is no data visible from the filters…….. No idea?

I am convinced that this is a regional date issue, because the code appears to be correct.

Google turned up the following – “Using dates in AutoFilter can be tricky if not using the US date format”, but I am no nearer a fix.

http://www.ozgrid.com/VBA/autofilter-vba-dates.htm

I’m hoping this makes a little more sense…

Thanks,
Nathan

OOps, I forgot to respond to this thread (I spoke with Hey Jude by PM).

No joy for me in IE8 and I gave up , downloaded FF instead and it plays perfectly.

Thankyou Tony for the explanation, and Thanks both for your help.

Well now I’m waiting to hear if it worked Weird that it worked in IE tho isn’t it?

Hey Jude

Yes, it did work, perfectly, Thanks very much! It’s layout is also much easier for me to understand, Thanks!

It has always worked for me fine in IE, why the difference with FF?

I opened it with FF and it’s text too…looking

Hey Jude

For you it will show as text in both FF and IE, because the images are saved and are pointing to my C drive. I assume that to troubleshoot it, one would need to set up a folder with a few images and point part of the file to that?

But there must be an underlying reason….

What is the entire name of your file including any grammatical marks?

Hey Jude

Image Index.htm – which is saved locally.

How bizarre, I can upload the htm but not as txt.

I have an idea. Have you imported your bookmarks from IE to FF yet? Because I did that and they import and export in HTML in FF so you could do that and see if you can view those? I know I did it and when I imported them from the html file on my desktop they all worked.

Bookmarks>Organize bookmarks> Import and Export> Import or Export HTML

Can you copy an example of one of them so we can see?
Hey Jude

Yes I have, but they don’t show the icons either, just a bog standard “looks like a page”.ico

?

Can upload jpg, but not txt…..

Welcome to the lounge Dopje, it’s good to have you with us.

Hi Ankit,

Please could you post a small sample of how you would like the summary to look.

Also, the code was provided by and appears to work for Steve, and I can see that it works for you also. It does not work correctly for me in the UK, and I presume that it is something to do with regional dates. Where are you and what date format do you work on?

Thanks
Nathan