I hope this is descriptive enough.
I have an Excel file that contains data that is updated once a day (using the OnTime method). The source that updates the data is only available on the machine that is running the Excel file (i.e. everyone on the network cannot get the data on their local machines).
What I am trying to do is to use VB (or a macro) that will open the Excel file on the machine where it resides when a local user activates it. That way if the Excel file ever is shutdown or the server crashes (it is a Unix box -- so Microsoft scheduler won't work). That way the data in the serverbased Excel file will refresh. I have a macro that will copy the data from serverbased Excel file into a local based Excel file.
I really hope I am being descriptive of my problem. I have used the:
workbooks.open
command to open the serverbased Excel file, but it opens it on the local machine, and I need to open on the server.
Thanks to anyone that can help solve this.
I have an Excel file that contains data that is updated once a day (using the OnTime method). The source that updates the data is only available on the machine that is running the Excel file (i.e. everyone on the network cannot get the data on their local machines).
What I am trying to do is to use VB (or a macro) that will open the Excel file on the machine where it resides when a local user activates it. That way if the Excel file ever is shutdown or the server crashes (it is a Unix box -- so Microsoft scheduler won't work). That way the data in the serverbased Excel file will refresh. I have a macro that will copy the data from serverbased Excel file into a local based Excel file.
I really hope I am being descriptive of my problem. I have used the:
workbooks.open
command to open the serverbased Excel file, but it opens it on the local machine, and I need to open on the server.
Thanks to anyone that can help solve this.
