I am in the business of providing URLs to Excel users and other programmers. Such URLs links point to CSV data. Excel users would like to use it in a way that they can "Refresh" at will and programmers depend on CSV data format.
The problem I am facing is that for CSV formatted data, the URL ends up looking like: "http://www.my.com/file1.csv". Excel treats any URL ending in "csv" as a file for which it needs to prompt user every time refresh is desired. I found a property in the Connection to disable that prompt. (Its on Connection Properties window --> Usage tab --> Prompt for file name on refresh). However this becomes a pain for the end user to disable that prompt for every data connection/URL.
My question is: Is there a way to disable that property of prompting for a new data file for each Refresh? In fact, ideally it should be such that its set for all Excel data content downloaded from my site.
Any help is greatly appreciated.
thanks,
Vinay
[email protected]
Bookmarks