Export worksheet to another workbook without overwriting existing entries (search?)
I am attempting to make a thing that will take the data from the current workbook (OVC Process v1.0.3.xlsm), Sheet named "Data" and after clicking button, upload that data into another workbook "OVC Metrics.xlsx", Sheet named "Data" on a Sharepoint site. I can do the copy/past function, but I need help with the overwrite function.
Here's what I got:
If anyone could help me with this I'd be greatful.
Please Login or Register to view this content.
If you are overwriting some of your data, then your last row variable based on column A data probably needs to be based on the actual column with the most data. So replace this
with thisPlease Login or Register to view this content.
That will give you the last row with data in any column.Please Login or Register to view this content.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
Excellent! This works locally. Now I need to figure out how to upload to sharepoint site. When I update the LoadFilePath to the sharepoint address, it gives me a "subscript out of range" error. Any tips on this?
click the debug button to see which object it is that the compiler cannot find. Remember when putting it on the sharepoint drive that some of your filenames or sheet names might change, so the code has to be modified to adapt those changes.
Got it! This worked after I updated links on the wkb2
thanks for the feedback, Don't forget to mark the thread as solved.Originally Posted by Photomommie
Regards, JLG
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks