jian_xin85 Posted September 13, 2006 Share Posted September 13, 2006 i have 2 excel forms that are link together but are 2 different files how can i keep them link in the html ...... the error is from a excel sheet the error states:"run time error '1004' method 'open' of object "worksheet failed"can any one help me or provide me with any solution???? Link to comment Share on other sites More sharing options...
justsomeguy Posted September 14, 2006 Share Posted September 14, 2006 The client downloads the Excel file before opening it. So, if you are referencing another file in a macro or something, they click on one file to download it and the other file is still on the server, it's not on the local computer. Even if they click to open one, then the other, the files are probably saved in IE's cache with different filenames then what you are expecting.So, no, you can't really do that. It would be better to have 2 sheets in the same file. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now