Hi Tomreid
I am really thankful for your help and finding time to answer my question. I have done what you had suggested but now another message pops up that says:
Runtime Error: '-2147467259(80004005)':
[Microsoft][ODBC Driver Manger] Data Source name not found and found no default driver...
Guys, I am new to Excel VBA and desperately in need of help.
I do not know if it is possible to do in Excel/VBA but this is what I want to do.
"Create a template in excel for users with sales data with subtotals for a week, month etc.I want them to just open the file where it refreshes/connects...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.