I've got a simple DataPump which extracts data from a table and import
them to an excel file. I would like to know if it is possible in vba to
create a new spreadsheet in my excel file prior the import in order to
import in this specfic spreadsheet (I want to be sure that my column
figure in my table of type float will be of type float in my new
sheet). Basically I want to automate what we can do in design mode by
clicking the Create button in the Destination tab of the proprieties
DataPump windows. Thanks