spdude8307
New Member
- Joined
- Jun 4, 2017
- Messages
- 1
Hey,
I've been struggling with this and I can't seem to figure it out.
I'm trying to write a VBA code to export an excel worksheet named "Final" as a .prn file and then convert that into a .dat file. The file location needs to be the same as where the workbook is (dynamic), as the workbook is saved in several different drives so I can't use a fixed file location.
Thank you so much
I've been struggling with this and I can't seem to figure it out.
I'm trying to write a VBA code to export an excel worksheet named "Final" as a .prn file and then convert that into a .dat file. The file location needs to be the same as where the workbook is (dynamic), as the workbook is saved in several different drives so I can't use a fixed file location.
Thank you so much