and a bunch of text saying that csv files will become xlsx files. All I see is an xlsm file with big yellow text boxes and green blocks of cells with someone's path name. What am I missing? I downloaded every link available on this thread. Karma Tip: Since you will become an expert in this sheet, why don't you make a short tutorial screenshare video and post that on youtube? That would be nice. Now, drink some thee, relax, look at the sun and the birds, and when your heart beat has dropped write a lovely thank you note to your fellow country man Lewis for coding the sheet and giving it away for free. Make sure you download the file from the "11-15-2019, 12:15 PM" post. Just read the instructions in the sheet and now that you have learned that the yellow boxes are buttons you are good to go. In regards to the (more than excellent) excel sheet that saves me hours of work each day. Get a mirror and do some double self reflection. If you see so many thank you notes you can be 100% sure that you are doing something wrong or that you don't understand how it works and in stead of asking politely how to help your sorry little butt you act like you paid the world to bow to your needs. [ [input type=”radio” id=”radDelimTabUnicode” name=”delimiter” value=”tab” />[label for=”radDelimTabUnicode”>Tab/Unicode[/label>įeel free to incorporate, make changes, etc.Dude, calm down. > delimiter = ‘\t’ ? xlText : xlCSV, // FileFormat [ delimiter = ‘\t’ ? xlText : xlCSV, // FileFormat [ $id(‘radDelimTabUnicode’).checked ? xlUnicodeText : [ ? $id(‘radDelimTab’).checked || $id(‘radDelimTabUnicode’).checked [ var xlUnicodeText = 42 // Now saving in UNICODE text I have made what I think are suitable modifications and include the changes for your entertainment.ĭiff output (with left-angles replaced with left-brackets for blog posting): Unfortunately I had a need to export some sheets in Unicode due to Arabic and Cyrillic characters in some cells. Not sure where I ran across it but it was a link somebody had posted. Let me know if you have any comments, questions, suggestions, or issues with this new application. Added the ability to specify the delimiter.Īs of right now this application is very simple, but I do hope to beef it up a little as time goes on.
0 Comments
Leave a Reply. |