PDA

View Full Version : How to create a macro that will produce a csv file from a button



wedd
11-22-2010, 02:05 AM
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. :beerchug:

Bob Phillips
11-22-2010, 03:29 AM
The answer is undoubtedly, yes!

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

wedd
11-22-2010, 03:59 AM
I have a csv file (eXAMPLE below)

(csv file) R: \\cluster2\Dept (file://\\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
11-22-2010, 04:56 AM
Just open it within Excel with the macro recorder on, it will create your code.