Search results for query: *

Eureka! and I'm an idiot! After all of that I finally realized that I wasn't saving it after the module ran. Sorry about the wasted time, and thank you for the code, it works perfectly. Now one last piece... I have the macro and module saving to a location under \Documents\tbl_benchamrk.xlsx...

KJV1611, I feel like I need to apologize and thank you in advance! For the life of me I cannot get this to work. Here's what i am doing... I took your code(just changing my file location), plugged it into a module and tried to call it up as i mentioned before. Onclick the event procedure runs...

BUMP!

Thank you for the reply.. i have a couple more questions. Previously when the user clicked the button to compare their choices it would run a Marco that ran through all of the queries and such and then output the .xlsx file which was called tbl_benchmark and autostart the file. Now i changed...

BUMP!

Thank you in advance for any help on this... I have built a benchmarking program in access... once the user makes their selection of the items to compare, the program will output an excel file. The file has column headers for each possibility on the form and thus has lots of empty columns. I...

ok... i think we are getting closer with the "web tables" option. But i don't think i was good enough at describing how to get to the prices from the URL in your query, http://www.discounttire.com/dtcs/tires/falken/home.do, you are now that page in which you must choose a tire line... you can...

Hmmmmm... doesn't time out for me. I just clicked in now and it loaded quickly. If you are able to come back to this and have some time you can navigate to it www.discounttire.com select "by Brand" Falken then any line and any size inside that line Again, all im interested in is the table...

BUMP!

I am working to build a spreadsheet that will update retail pricing from www.discounttire.com. I create the web query get to the location I want and select the table that has the info I need, all is well. Then later I go to refresh it and the data is now pulling from a new table from the page...