RE: filecopy from excel

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi there Steven,

Thanx for the update...

I actually tried with both back slashes aswell as forward slashes!
Both work in WSS 2.0 whereas only back slashes seem to work in WSS 3.0
The problem I'm inclined to think is one of Name resolution...
Finally I trashed everything and reinstalled WSS 3.0 with the Basic option
where eveything gets installed on a single server.
This made the problem go away.
It isn't the result that I'd hoped for but I'm unable to spend any more time
trying to get it to work elsewise.

Thanks for you help!
""Steven Cheng"" wrote:

Thanks for your reply Alex,

Then, I think the "//wss3machine/sites/site/doclib/Testfile.txt" like path
should be the problem here. Based on my local test, sharepoint document
library doesnt seem to support this UNC share like path. And for file
browse, so far only IE and windows explorer or the office application
support opening it directly via http based link.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead


Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
msdnmg@xxxxxxxxxxxxxx


--------------------
From: =?Utf-8?B?QWxleA==?= <Alvie@xxxxxxxxxxxxxxxx>
References: <6C57E1DA-27EE-413F-A7C0-C594DF65E794@xxxxxxxxxxxxx>
<nlQi7veVJHA.348@xxxxxxxxxxxxxxxxxxxxxx>
Subject: RE: filecopy from excel
Date: Thu, 4 Dec 2008 07:21:09 -0800

Hi there Steven,

Thanks for the reply.

I'm doing the file copy from within an excel vba macro.
The syntax of the call is
filecopy source, target
source is "C:\Testfile.txt" and target is
"//wss3machine/sites/site/doclib/Testfile.txt"

TIA

Alex

""Steven Cheng"" wrote:

Hi Alex,

From your description, you're using some code to programmtically copy
files
between filesystem and sharepoint site's document library, however, you
encountered some "file not found error", correct?

As for the FileCopy command, are you using office's VBA macro or some
add-in based component to execute it? Also, would you provide the
complete
steps and the code(and sharepoint share url) you used. Thus, I can also
perform some tests on my side.

If there is anything I misunderstand, please feel free to post here.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead


Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you.
Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
msdnmg@xxxxxxxxxxxxxx

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 2 business day is acceptable. Please note that each
follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions. Issues of
this
nature are best handled working with a dedicated Microsoft Support
Engineer
by contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx
==================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.
--------------------
From: =?Utf-8?B?QWxleA==?= <Alvie@xxxxxxxxxxxxxxxx>
Subject: filecopy from excel
Date: Wed, 3 Dec 2008 12:42:55 -0800


Hi there,

I'm using the filecopy command to copy local files upto a sharepoint site.
This works fine when I'm running excel on the WSS machine, but when I try
to
run excel from a different machine, I get error 53 - file not found for
the
WSS target file name e.g.
//WSSMachine/Sites/Site/DocumentLibrary/DocumentName.

I'm able to browse the WSS site in explorer view so the web client is
working,
and I can ping the WSS server...

I'm hoping for some othere ideas!

TIA

Alex


.

Relevant Pages

  • Re: The Big Picture
    ... part of the pinnacle of the sport show not a support class in AMA. ... So WSS tuning levels are too expensive ... great that GP ends up with two segments, the fast full factory bikes ... in the class at the national championship level, ...
    (rec.motorcycles.racing)
  • RE: Sharepoint 3.0 Drop Down Menus not showing.
    ... I am in the final stages of testing for deployment of WSS 3.0. ... set the security level to "low" for trusted site zone, ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Public web sites on WSS
    ... I agree with Ian that WSS is one collaboration platform. ... admin of WSS site should add the user accounts and define the permission to ... Microsoft Product Support Services ... If you are outside the United States, ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Access to Remote Web Workplace
    ... You can use the RWW feature to access the SBS resource, such as TS, OWA, ... In addition, for the SBS with ISA installed, WSS option won't be available ... Microsoft Product Support Services ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: filecopy from excel
    ... I'm doing the file copy from within an excel vba macro. ... filecopy source, target ... As for the FileCopy command, are you using office's VBA macro or some ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.sharepoint.windowsservices)