SaveCopyAs Path

[Shatneriffic]

Hello

I'm trying to use VB.NET to save an open spreadsheet to a network drive and am receiving errors when run the code. Here's the line where the problem exists.

excelWorkbook.SaveCopyAs("//wsent01ts/callgrp/reports/Accts 120 ME.xls");

I can save it manually to this path: \\wsent01ts\callgrp\reports\Accts 120 ME.xls

Any ideas? Thanks!

 

[RiverGuy]

Did you try using the backslashes, UNC style instead of the forward slashes?

 

[Shatneriffic]

Thanks for the idea. However, when I do that, it gives errors after each back slash saying something to the effect that an 'escape' had been found coded multiple times.

 

[Sorwen]

SaveCopyAs requires backslashes in a windows environment. Starting there what is the exact error message you are getting? Why is there a semicolon after the line? You are doing this in vb.net or are you doing it in c++/c#? Also at what point exactly in your code is that error popping up? The only way it should come up multiple times on that line is if you are looping through multiple files.

-I hate Microsoft!
-Forever and always forward.
-My kingdom for a edit button!

 

[RiverGuy]

Good call Sorwen, I just noticed the semicolon in his code. It must be C#.

Here's a list of escape sequences to work around in C#.

http://blogs.msdn.com/csharpfaq/archive/2004/03/12/88415.aspx