I have a Workbook from which I need to save a range of cells as a CSV file, I have managed a VBA macro to save to the location I want and in CSV format.
I know need to push the contents of one sheet only out to this file I'm using the cell D16 to define the range (currently Output!$A$2:$AK$30) just need to workout how to convert the contents of this cell to a range in the save as command.
Many Thanks
I know need to push the contents of one sheet only out to this file I'm using the cell D16 to define the range (currently Output!$A$2:$AK$30) just need to workout how to convert the contents of this cell to a range in the save as command.
Many Thanks