+ Reply to Thread
Results 1 to 6 of 6

How do i insert a cloud pathway like sharepoint/teams folder in my macro to save documents

  1. #1
    Registered User
    Join Date
    06-13-2023
    Location
    London
    MS-Off Ver
    365
    Posts
    18

    How do i insert a cloud pathway like sharepoint/teams folder in my macro to save documents

    Hi all,

    im getting an error when i try to use a cloud folder location as my place to save images in, i can successfully use a local folder on my dektop but it fails when i try to use a url location

    im sure im doing soemthing wrong

    "X:\WFS\Reporting\Sukh\202401" & newFileName & ".jpg"

    thats the local folder but i want it to be a sharepoint folder url like

    https://its007149.sharepoint.com/sit...471201286E86E2



    Please Login or Register  to view this content.


    Appreciate any help on this matter

    Many thanks
    Last edited by AliGW; 01-23-2024 at 08:37 AM. Reason: Code tags corrected.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,916

    Re: How do i insert a cloud pathway like sharepoint/teams folder in my macro to save docum

    Administrative Note:

    Please include code tags around your code.

    Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Guideline #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    06-13-2023
    Location
    London
    MS-Off Ver
    365
    Posts
    18

    Re: How do i insert a cloud pathway like sharepoint/teams folder in my macro to save docum

    Hi

    i tried to add the# but it does not look like anything has changed?

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,916

    Re: How do i insert a cloud pathway like sharepoint/teams folder in my macro to save docum

    Did you select the code text first? Try again, please.

  5. #5
    Registered User
    Join Date
    06-13-2023
    Location
    London
    MS-Off Ver
    365
    Posts
    18

    Re: How do i insert a cloud pathway like sharepoint/teams folder in my macro to save docum

    ahh sorry i didnt select the code text first, i think its worked

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,916

    Re: How do i insert a cloud pathway like sharepoint/teams folder in my macro to save docum

    It has and I've cleaned up the extra tags you put in! Thanks.

+ 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. Save Individual Tabs into new Subfolder on Sharepoint folder
    By Chuckf1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-22-2022, 10:44 AM
  2. [SOLVED] How to shorten up folder pathway with this workbook.path
    By bdouglas1011 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-17-2018, 07:35 PM
  3. Save as pdf in current folder in Sharepoint
    By Jacc in forum Word Programming / VBA / Macros
    Replies: 5
    Last Post: 12-22-2015, 08:25 PM
  4. VBA to save file to sharepoint folder
    By rlsublime in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-20-2014, 04:56 PM
  5. [SOLVED] pathway reference to file givs out of range errormsg (pathway is set as variable)
    By phila7475 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2014, 04:51 AM
  6. Macro to open a folder containing documents
    By jrdunn78hawk in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-06-2012, 09:52 AM
  7. [closed - opening new thread] Save xlsm to Sharepoint/Web Folder
    By phi11yguy19 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-03-2011, 08:25 AM

Tags for this Thread

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