Here's the problem. I want to copy the data from one excel file to another excel file. I already have done the destination file which im created using filesystemobject in my code. Before im getting data to be copied in the destination file from one excel file but in this case i used recordset. I used the path of the excel file(source file) as datasource of the recordset. THis is working already but it came to another problem. The recordset is holding only 255 chars but some cell in the source file is holding more than 255 chars. So i have come to an idea that i should copy the data from cell to cell. From Source file to another file. Question: How do i activate the source file which is existing. Let say: C:\SourceExcelFile.xls
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.