Export Selected Columns as CSV VBA

[Mohsin Malik]

Hello All,

Is there any way to 'Export' the selected column (user selected columns) as CSV. I have attached a mockup (screenshot) that gives a clear thought about the scenario. The 'User' will be able to select the 'Columns' for the export of 'tblInventory' and by clicking 'Export as CSV' button will export the 'Selected' columns as CSV.

Thank you
Mohsin

 

[pbaldy]

Should be possible. You can use a QueryDef to modify the SQL of a saved query, using the selected items. You could then use TransferText to create a file using that saved query.