Excel Pivot Table from Access VBA

Hi All,

I am trying to write code that will create a pivot table from an access database. I tried to record myself doing this action but i cannot really make heads or tails of the code. What i am trying to do is to create a pivot table that is coming from a variable source, one month the source may be from a certain location on my computer and the next it will be a different location. Here is the code that i am getting when i record myself, i have tried to change some of the variables but nothing seems to be working. Any help is greatly appretiated, thanks in advance!

Please Login or Register  to view this content.

I am going to want to change the location of the file to a variable and the file name to a variable. I am getting an error in the highlighted section.

I fixed my problem, for anyone in the future having this problem i refered to this website, it helped a lot

http://www.java2s.com/Code/VBA-Excel...omdatabase.htm