SiteMaze Posted May 6, 2008 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
SiteMaze Posted May 6, 2008 Author 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
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