with your original file open, open a new excel file.
in the new file go to tool--macros and click run macros. your original macro in the OPEN ORIGINAL FILE will show up. run it and save your new file with what ever name you want. close your original file
I just posted this question on the MS VB forum.
how could this be done through VBA in Excel? Or, can it be done?
"I am very new to VB and, am trying my hand at VB6.
I think!, I know how to creat a text file and have a string written to it.
What I am trying to do is have a column header, say...
I have asked this question before, and, the one or two responses given were general though much appreciated.
How can I protect the code in ONE single module from being accessed and viewed by the user in an EXCEL workbook and still have the VBA editor and other modules accessible.
Can a single...