+ Reply to Thread
Results 1 to 7 of 7

How to verfiy that a file write to a URL location worked or not

  1. #1
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2016
    Posts
    2,712

    How to verfiy that a file write to a URL location worked or not

    If i try and write a file to a URL address and it doesnt work how to know the write failed. I tried using code like the following

    Please Login or Register  to view this content.

    where New_file_name1 is the URL
    FileFOrmat =6 means a csv file

    right now if i use the above code and the file does not get written then no error is generated so i have no way of knowing if it worked or not

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,765

    Re: How to verfiy that a file write to a URL location worked or not

    By URL do you mean sharepoint address? Have you got synchronised particular folder?
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  3. #3
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2016
    Posts
    2,712

    Re: How to verfiy that a file write to a URL location worked or not

    what do you mean by "Have you got synchronised particular folder?"

    and yes i mean a sharepoint address

  4. #4
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,765

    Re: How to verfiy that a file write to a URL location worked or not

    You can synchronised sharepoint folder (via OneDrive) and navigate with them via File Explorer not a browser. Then you can save a file with local path.
    I am doing that with lots, lots file when people creates reports etc. everyone saving file in their synchro folder and onedrive do the rest.
    Last edited by KOKOSEK; 05-12-2023 at 05:37 AM.

  5. #5
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2016
    Posts
    2,712

    Re: How to verfiy that a file write to a URL location worked or not

    how do you synchronise a sharepoint folder? Also, if one does NOT synchronise the folder is there a way to acces the folder?

  6. #6
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,765

    Re: How to verfiy that a file write to a URL location worked or not

    You do not have anything like this in browser view:
    Capture.JPG

  7. #7
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2016
    Posts
    2,712

    Re: How to verfiy that a file write to a URL location worked or not

    if you dont sync folder how to verify URL location?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 04-19-2023, 02:17 AM
  2. [SOLVED] Summing hours worked, per date, per location
    By MachineSh0p in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-23-2021, 03:40 AM
  3. [SOLVED] Write Sub procedure to format excel and write case/if statement to text file
    By vbronton in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-06-2018, 08:26 AM
  4. [SOLVED] Macro to Save Excel File to a SharePoint location and then e-mail that location in Outlook
    By NickyHavey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-11-2016, 09:27 AM
  5. [SOLVED] [Help]macro to open file browser, to select a location, and save the location to a cell
    By zhuleijia in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-06-2013, 09:56 AM
  6. Replies: 1
    Last Post: 10-31-2012, 11:19 AM
  7. [SOLVED] How do I write the formula to calculate someones time worked
    By deusy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-16-2005, 04:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1