Search results for query: *

Skip do you think setting those objects could be causing other issues? I will play around with this to see if it helps. combo there are no renamed items in the pivot table.

genomon I don't believe it is a refresh issue as I have tried this as well and still gives the wrong data. It actually seems like it corrupts the pivot table because even when I go and manually try and modify and refresh it afterwards it still is messed up.

I have the need to create several hundred named ranges and have created a VBA script that will loop through and create them. However it puts quotes on each end of the definition when creating it and then I have to go in and delete the beginning quote and ending quote for each one.. Do While...

I am having some very strange issues when trying to update a pivot tables pagefields using VBA. The pagefields do get updated with the correct information but the output of that is returned in the Pivot Table is not correct. When I create a new PT and use the same selection criteria I get the...

Brilliant! Thanks so much Skip! You just saved me a ton of work my friend!

Skip Thanks again I can see the power of using Index & Match now. So now if I wanted to utilize this for multiple countries at a time how would I handle it if I added an additional column Country Brazil 10/1/2012 2.0264 Brazil 10/2/2012 2.0268 Brazil 10/3/2012 2.02585 Brazil 10/4/2012 2.023...

So I used this method and it works! Thank you for making me think outside of the standard box. But I am still a bit confussed on how it works would you be able to explain how this works? Sorry I am no expert and would really like to understand this. Thanks,

Because I have transactions that happen on those weekend days and I have to make sure the correct exchange rate is used in order to properly report the data. You have me intrigued a bit where are you going with this?

Hey Skip, Ther problem is I have several years worth of currency that I have to go through and to manually add in each Sat & Sund would take forever to do. So I am looking to see if there is a way to identify the gap add the two addtional rows and then populate the data via VBA instead of...

Hey Everyone, I have a spreadsheet that contains two columns. Date and Currency Rate Date Rate 10/1/2012 2.0264 10/2/2012 2.0268 10/3/2012 2.02585 10/4/2012 2.023 10/5/2012 2.018875 10/8/2012 2.0306 10/9/2012 2.0297 10/10/2012 2.0355 10/11/2012 2.041725 10/12/2012 2.0426 10/15/2012 2.0426...

Gruuu, It didn't work out. Thanks again for the information I did learn a bit more about manipulating IE with so your time was not wasted! Thanks again!

Gruuu, Thanks for all of the help. I truly appreciate it! If this doesn't work I am going to have to reach out to the IT folks and see if they have something blocking this ability.

Another swing and a miss... I tried using upper but it failed I used the UCase in its place. Am I missing something here? For Each oHTML_Element In HTMLDoc.getElementsByTagName("input") If InStr(UCase(oHTML_Element.outerHTML), "ONCLICK") <> 0 Then oHTML_Element.Click: Exit For End...

Yes I agree. I am getting a bit frustrated at this. My mind is about fried at this point so please forgive this next question. How would I use this new statement?

So when I cycle through the elements it appears that even though there is a onclick in the input string the properties are not showing anything. So I am assuming that is why the .click doesn't do anything <input class="img" type="image" src="img/btn_submit.jpg" border="0" height="30"...

Gruuuu, Thanks for the information. I have been playing around with something similar all morning to try and resolve this but it still doesn't process the element. So I added the part to check the onclick value and for some reason it is not picking up the onclick value. So I put a msgbox...

Hey guys I have an Excel workbook that connects to a website and processes data based on the user that is using the workbook. I just found out that they are moving the website app to another company and the login is just a tad bit different. I was just notified today that they are going to move...

I have several very large tab delimited text files that I need to import into access. When I import them using the import wizard all of the date values fail to import. I get a "Type Coversion Error" on every record when I try to import the date fields as actual dates. I have modified the...

Ace, Yes both combo box's and DateSold contain that same number format.

Ace, I figured out what the problem was. I was putting an "OR" between my date ranges. sWhere = "(" & sWhere & ")" & " And " & sDate & " Or " & eDate So it would show everything >= sDate or everything <= eDate! So changing the Or to an And cleared up the issue. sWhere = "(" & sWhere &...