If not everymorning, then everytime a user clicks refresh on the site. So the info is real time. Original workbook is about 7 pages and has nasty formulas that need to run...How do i use VB script to link an excel file to our webpage and have it update everymorning?
What you need to do is write a server side code that will generate a file on the fly. That is when a request is made, the code will drnamically return a page with content type excel and the data section has the contents required in the excel file.
I dont know all your requirements. Optionally if you are getting the information from a MS Sql server and you require a physical excel file to be stored on the server, then you might consider using DTS package
No comments:
Post a Comment