Excel inventory integration

[auto]

hi everyone,
i would like to ask this question, i am using excel for my inventory list which has the item sku and qty etc. but some items i do not keep them in stock, just i take it from my wholesaler when i get an order, but i need to have the qty of my wholesaler to see if i can rely on him cause if he is out of stock i cant sell the item, now my question, is there some way in excel to schedule an automatic integration from my wholesalers website into my excel spreadsheet and update the quantity of the items that i don't stock myself? doing it manuely every day for tens of items i am getting nuts....

 

[RonB1111]

See if this helps:

Excel 2007+:
http://www.jkp-ads.com/articles/webquery.asp

Earlier versions of excel:
http://www.techrepublic.com/article/pull-data-into-microsoft-excel-with-web-queries/6115870

 

[auto]

thank you very much it helped great!!!

 

[RonB1111]

You're welcome. Thank you for the feedback.

 

[auto]

oops, i see now that its not working, the reason is because when i log in to my wholesalers website i need to login first with my user and password and its not recognizing my login information so after 60 minutes when it needs to refresh the information it erases all previous info from before and not putting in the new info because i am not logged in, now is there a way to do it it should automatically login by itself?

 

[RonB1111]

See this thread:
http://www.mrexcel.com/forum/showthread.php?t=178862

Also look at the last post on this thread:
http://www.excelforum.com/excel-pro...-query-connection-to-login-automatically.html