bryVA
11-18-2009, 12:38 PM
Hello,
I was wondering if I could do an ADO transfer of information from one Excel file that I have open to an excel file on a sharepoint site. I have a sheet in the file on sharepoint that holds all the data in a table format. I need the macro to copy cell values of A2:Q2 in the file I have open to the one on sharepoint in the next available row in the table. Is this possible? Can an ADO work excel to excel or is there a better method? I am at a loss for how to accomplish this.
My goal is having an excel file on sharepoint updated from multiple users without having to open the file and then uploading it back to sharepoint.
Thanks for all your help,
-B
I was wondering if I could do an ADO transfer of information from one Excel file that I have open to an excel file on a sharepoint site. I have a sheet in the file on sharepoint that holds all the data in a table format. I need the macro to copy cell values of A2:Q2 in the file I have open to the one on sharepoint in the next available row in the table. Is this possible? Can an ADO work excel to excel or is there a better method? I am at a loss for how to accomplish this.
My goal is having an excel file on sharepoint updated from multiple users without having to open the file and then uploading it back to sharepoint.
Thanks for all your help,
-B