Here is a good post that accurately resets what Excel parses on when you paste text. I have known for a long long time, that the LAST text-to-columns settings is what is used when one pastes data into excel, but I thought I would see (I finally snapped for the last time) what other people did. Well, […]
Here is a good article with many links and debates. I have used the “accepted” answer and gotten 95% accurate results – so why not 100%? I have not solved that one. I am trying the 2nd answer which in the efficiency graph gives better results. http://stackoverflow.com/questions/18932/how-can-i-remove-duplicate-rows
Here is a nugget – a friend of mine made a dashboard with no VBA where the user IN EXCEL – pulls down a dynamic value to … lets say “may 2015” and the charts etc. update. One could do this in VBA, but, you don’t have to. I thought it was worth saving/sharing the […]
I have a client who wants some PDFs messed with. To do so, layers need to be split and recompiled. Here are links that will help me decide which SDK to use how to … well … do it. A good discussion of pdf libraries layers or content streams extract layers http://www.soft-xpansion.eu/files/pdflib/PDF%20Xpansion%20SDK%20Guide.pdf foxxit, sdk documentation PDFtron […]