Friday, May 17, AM. User posted Hi, I think you should change the corresponding area to the below: Response.
Thursday, May 23, PM. User posted Keep in mind,. User posted Hi, Can you please post it a bit more clear. Any way,check the below link. User posted. User posted It's my code Clear Response. HtmlTextWriter writer Me. Columns 0. Did you get any solution since you asked this question here? Actually, I just found a solution which I do not really find clean but Open resultFileName resultFile. Close Application. Add a comment. Active Oldest Votes. I tried the below and it worked perfectly: ThisWorkbook.
I have the compatibility pack installed and it still doesn't work. Not sure why. Any ideas? What happens if you try to "save as" under a different file name?
I just tried that and it did not work. I stepped through the code and made sure it hit that line of code and it did so I'm not sure if it has to do with my current setup on my machine or what.
I'm at a loss. The machine I'm testing it on has both and installed I ran the code in , but I'm not sure that would make a difference. I tried it on another machine with a similar setup as mine both and installed and it worked.
Very weird. Sorry to waste your time, I guess it's a just an issue with my machine's setup for some very odd reason. Show 1 more comment. Add method, saving and then closing. Nicolas C. Jay Jay FYI - I did not build the web site and the person that did is gone. They can open - read only still. The only difference btwn his pc and mine is the version of excel we are running Not really.
It is possible, but they currently view reports on the web site and the accounting director wanted to add the excel spread sheets. They don't need to save them back to the location, just edit - save to their pc and e-mail to her. Ah - well, if they don't need to re-save back to the network location, is the file opening in read-only mode that big of a problem?
In fact, if you don't want them overwriting the files in the 'scweb' location, then having them open read-only is actually a pretty good idea. The thought occurs -- one workaround would possibly be to set the Windows Read-Only property on these spreadsheets once they're placed in the 'scweb' location:. Here is another weird issue. If you close it and try to open that file - or any other excel file - it comes up read only. They still cannot save to the original location even the 1st time.
The content you requested has been removed. Ask a question. Quick access. Search related threads. Remove From My Forums. Asked by:. Archived Forums.
Excel for Developers. Sign in to vote.
0コメント