I would like to come up with some VBA code that will perform the following actions:
'Ask user which tab to import
'Show user listbox of tabs only allow one tab to be imported
'Ask user which fields to import
'Show user listbox of column headers allow many columns to be imported
'all fields formatted as text
'Pull selected columns from selected tab into a new table
'Show user confirmation of number of rows imported
I have used TransferSpreadsheet before, and I can work with record sets and other common VBA stuff. I am just not sure on the syntax for performing theses actions.
Can anyone give me a push in the right direction?