I can answer most questions related to macros, worksheet functions, VBA, Office automation (calling/using other MS Office programs) and geocoding using Google Maps. I have 10 years experience using and programming in MS Excel and other office applications. I have extensive experience linking and using DLLs in Excel.
Macros, worksheet functions, VBA, linking of DLLs and Office automation, geocoding using Google Maps.
|Katt||01/08/14||10||10||10||Thank You so much that worked :) .....|
|brian||10/03/07||10||10||10||Thanks Gyula, I managed to install the .....|
|Michele||10/03/07||10||10||10||Thank you so much for taking the .....|
|Sherry,||09/18/07||10||10||10||Thanks, just what I needed.|
Hi Al, you can use the Excel VBA Evaluate function. But it requires evaluating another function or sub as per below. No need to declare your constants but you need to add to the custom function below
As far as I know you cannot do this with the built-in Windows Zip. You could do this with a third party program like 7Zip or WinZip, something like: strDestFileName = "c:\temp\TestZipFile.zip" strSourceFileName
Hi Raja, There is a good discussion on this with he solution at http://www.ozgrid.com/forum/showthread.php?t=56282 It requires some more advanced level programming skills but I assume if you created
Brian, here you go from David's site: ReversI() can be used to reverse the order of items in a row, column, or range. It can be used to reverse itself. Applied to a SINGLE ROW, the macro will
Hey Steve, the easiest way is to use Excel's validation. It is under the menu Data-Validation-Select list instead of any value. Just google "Excel validation" to get some examples. Another option
Answers by Expert: