Search results

Good Morning To All, I am having a problem an excel pivot chart that I'm building using data from Access. I am putting 3 graphs in one worksheet, but when I add the second sheet the ".SetSourceData" is not working correctly. This is causing my 2nd Graph to link to my first graph. The below code...

Good Morning, I have a quick question. Is there anyway to move an "Excel Pivot Chart" (The actual chart) around using VBA in access. I'm trying to mount the chart on a certain position of my spreadsheet but with no luck. I can't find any code that will set the charts location. If anyone...

I think I may have posted this in the wrong spot before. But here goes: Good Morning Everyone, Can any one tell how to pull information from a QueryDef and make it populate into fields in excel. I have all of the code working up into this point but I do not know how to add the information...

Good Morning Everyone, Can any one tell how to pull information from a QueryDef and make it populate into fields in excel. I have all of the code working up into this point but I do not know how to add the information. Below is the code that I am using. Public Sub ASFFPull() Dim dbs As...