SiteMaze Posted May 6, 2008 Share Posted May 6, 2008 I would like to paste 1-CSV to Excel Worksheet-1, then 2-CSV to Excel Worksheet-2, and so on. Can someone help with the COM? I couldn't find it in ExcelCOM UDF and prefer not to add cell by cell. Thanks! Arsenal Football Fan Club in Singapore Link to comment Share on other sites More sharing options...
SiteMaze Posted May 6, 2008 Author Share Posted May 6, 2008 ; 1-CSV _ExcelSheetActivate($oExcel, "1") $f_2arr_CsvFile = _CSVto2DArray($glb_str_RunFiles&"\1.csv") _ExcelWriteSheetFromArray($oExcel, $f_2arr_CsvFile) ; 2-CSV _ExcelSheetActivate($oExcel, "2") $f_2arr_CsvFile = _CSVto2DArray($glb_str_RunFiles&"\2.csv") _ExcelWriteSheetFromArray($oExcel, $f_2arr_CsvFile) Arsenal Football Fan Club in Singapore Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now