Programming

Excel Date format changes
I get CSV files that I convert to .XSLX files. My problem lies with the timestamps. They show as MM/DD/YYYY H:MM:SS ie: 08/03/2010 08:12:00. The problem is that this translates to August 3rd, 2010.... where it should actually be March 8th, 2010. I've tried going to Data-->Text to column--> and selecting DMY... 15 Mar 2010 14:39

Picture AlternativeText property Equivalent in Excel 97
Hi Is there a property in the Picture Object of Excel 97 equivalent to the AlternativeText property ? I need to use it as a Tag. Mishell ... 15 Mar 2010 13:30

months to full calender year
I have a monthly cash flow schedule that spans 4 calendar years. Each month has date representing the month (e.g. mar-2010). I need to distinguish between months that for which the whole calendar year appears on the schedule and those that are partial calender years. Any ideas how to do this? ... 15 Mar 2010 12:21

Minimum row height
Hello I'm using the Auto fit row height and it works very well but is there a way I can have a minimum height for the rows such as 105? thanks ... 15 Mar 2010 12:21

Auto row fit height
Hello The Auto row fit height works nicely but what if I want a minimum height? How could I set it to go no less than 105 thanks ... 15 Mar 2010 14:39

paste values without copy-paste values
Can I replace the copy-paste values code with something like <range>.cells(i,j).value = <range>.cells(k,l).formula ? (or .text or .? or ....) I have a standard list with standard columns, and operational lists with subsets of columns. I also have an equivalence table between columns, to accomodate for title... 15 Mar 2010 11:13

test for exernal links
Is it possible to test if a workbook has external links to another workbookl what i am trying to do is display a message when a user closes a workbook saying the workbook has external links. How would i code this?? ... 15 Mar 2010 12:21

Strange error message when loading a collection with an item of userdefined type
Hello, I think your problem is that you cannot coerce the UDT to a Variant to pass to the Add method. You may as well create your own Record class rather than using a UDT and pass an instance of that to the collection instead. HTH. -- aflatoon ----------------------------------------------------------------... 16 Mar 2010 09:08

How well does MS Office 2003 run on Windows Server 2008, IN PRACTICE ?
Hi How well does MS Office 2003 run on Windows Server 2008, IN PRACTICE ? (!) Microsoft say it runs fine, but are there any significant problems in practice? (eps re MS Access 2003). http://www.microsoft.com/windowsserver2008/en/us/supported-applications.aspx Microsoft Office Microsoft Office 2003 ... 16 Mar 2010 01:22

LookUp If Greater Than and LessThan
Trying to find a formula that will compare a number between 2 columns are return the 3rd column Something onlong the lines of =If(And(Number>Col_A,Number<=Col_A),Col_c,"NotFound") Col_A Col_B Col_C 20100101 20100129 JAN 20100129 20100226 FEB 20100226 20100402 MAR so if Numbe... 15 Mar 2010 06:48