View Full Version : How to create a macro that will produce a csv file from a button
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.
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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.