How to create a macro that will produce a csv file from a button

[wedd]

Hi vba experts,

I would like to know if it is possible to create a csv macro enabled button using vba. If so, how? And would you have sample code of how this can be done.

[Bob Phillips]

The answer is undoubtedly, yes!

But as for an example, more details please. What are you trying to do, inputs, outputs, constraints, etc.

[wedd]

I have a csv file (eXAMPLE below)

(csv file) R: \\cluster2\Dept Data\Migration Data\NOMSALES Output.csv


I would like to enable a macro to run from a button to open that file within a workbook

[Bob Phillips]

Just open it within Excel with the macro recorder on, it will create your code.