+ 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 (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,266

    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. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    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 (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,266

    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 (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,266

    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