jardenp
Active Member
- Joined
- May 12, 2009
- Messages
- 373
- Office Version
- 2019
- 2016
- 2013
- 2011
- 2010
- Platform
- Windows
I've searched on this and can't seem to find what I need. I've been working with an old script I found here that doesn't play well with 2010 and copies all the sheets in the current workbook.
I'm looking for VBA code (Excel 2010) to copy all the data from my active sheet (it will always be columns A-C with maybe 10-30 rows) and append it to Sheet1 of file C:\PathTest.xlsx. There are no headers to worry about in the active sheet--row 1 will contain data.
The destination file location won't change, but the active file name and location will. This is to be part of a larger macro.
The destination file will need to be opened, written to, saved, and closed, unless it's possible to manipulate file data without doing that. I do not want any pop up dialog boxes about saving or closing the destination file if possible.
Thanks!
I'm looking for VBA code (Excel 2010) to copy all the data from my active sheet (it will always be columns A-C with maybe 10-30 rows) and append it to Sheet1 of file C:\PathTest.xlsx. There are no headers to worry about in the active sheet--row 1 will contain data.
The destination file location won't change, but the active file name and location will. This is to be part of a larger macro.
The destination file will need to be opened, written to, saved, and closed, unless it's possible to manipulate file data without doing that. I do not want any pop up dialog boxes about saving or closing the destination file if possible.
Thanks!
