SpeedyKevin
New Member
- Joined
- Apr 26, 2019
- Messages
- 17
Hello all!
I have the macro below that exports certain columns to a file (in this a m3u8 file). Is there a way I could have excel allow me to type in the file name I'd prefer before exporting?
Thanks,
Kevin
Sub ExportToNotepadOVERALL()
Sheets("OVERALL_CLIPS").Select
WriteRangeToTextFile Range("D6:D86"), "file4.m3u8", vbTab
Sheets("Sheet1").Select
Shell "notepad.exe file4.m3u8", vbMaximizedFocus
End Sub
I have the macro below that exports certain columns to a file (in this a m3u8 file). Is there a way I could have excel allow me to type in the file name I'd prefer before exporting?
Thanks,
Kevin
Sub ExportToNotepadOVERALL()
Sheets("OVERALL_CLIPS").Select
WriteRangeToTextFile Range("D6:D86"), "file4.m3u8", vbTab
Sheets("Sheet1").Select
Shell "notepad.exe file4.m3u8", vbMaximizedFocus
End Sub