+ Reply to Thread
Results 1 to 2 of 2

VBA to paste in Sharepoint file

  1. #1
    Forum Contributor
    Join Date
    06-01-2015
    Location
    Chennai,India
    MS-Off Ver
    Microsoft Office 2021
    Posts
    146

    VBA to paste in Sharepoint file

    Hi all,

    Is it possible to paste the data to the file uploaded in the share point. ? I have the below scenario. Please assist me.

    > Summary File - If I enter "No" in column H then automatically that particular line should be moved to the respective workbook in the SharePoint based on Name and Country.

    > Eg. If I enter "No" in the column H of the first line item in the summary file and the name and the country is RK and DE accordingly so that the first line item should be moved to the workbook named as "RK_DE" which has been already uploaded in the SharePoint ..

    > The above needs to be followed for other scenarios as well as per the summary file.

    I have attached the summary sheet and the 2 SharePoint files as well.

    I have already tried it from my end however it is not working.
    Attached Files Attached Files
    Last edited by Revathi kannan; 11-24-2020 at 01:30 PM.

  2. #2
    Forum Contributor
    Join Date
    06-01-2015
    Location
    Chennai,India
    MS-Off Ver
    Microsoft Office 2021
    Posts
    146

    Re: VBA to paste in Sharepoint file

    Can someone tell me is there any possibilities to do the above requirements since I have been trying this out for past 12 hrs. but I am not getting my result.

+ 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. Vba to copy data from cells and paste into a workbook saved in Sharepoint
    By zlanglois05 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-23-2020, 01:28 PM
  2. Open file from sharepoint - getting a blank file
    By no_Fate in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-15-2018, 01:17 PM
  3. VBA to select SharePoint Content Type when saving Excel file to SharePoint
    By Luffk73 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-24-2017, 05:22 PM
  4. Select file and copy values from SharePoint excel file
    By peetman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-17-2014, 06:26 AM
  5. Opening SharePoint file with VBA - disable SharePoint "Contacting the server" message
    By kopite2002 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-22-2013, 01:56 AM
  6. Replies: 0
    Last Post: 10-08-2013, 10:54 AM
  7. Macro to get the latest file (excel file) from sharepoint sites
    By vigneshwaran in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-13-2012, 09:45 AM

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