02-25-2007, 02:06 PM
There are several ways a macro can work with Excel sheets:
1. use keyboard in Excel.
2. use ExcelSheet class and other Excel functions in Excel.
3. use database functions, which manipulate excel workbook file directly, not through Excel.
What would be better for you - 2 (in Excel) or 3 (directly in file)?
1. use keyboard in Excel.
2. use ExcelSheet class and other Excel functions in Excel.
3. use database functions, which manipulate excel workbook file directly, not through Excel.
What would be better for you - 2 (in Excel) or 3 (directly in file)?