excel 97

Hi guys! I'm currently working on a macro where I need to populate a validation list for a cell. The list comes from a string that's joins elements from an array. Here's the code: If Not IsArrayEmpty(Clas) Then For i = PrimeraClase To UltCla Clase = CStr(Ana.Cells(i...

Sir, I am using 4 excel workbooks in Office 97 namely 1. Master.xls 2. Administration.xls 3. Accounts.xls 4. Pending.xls My workbooks look like Administration.xls<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> <TABLE...

I want to be able to print "looseletters.ca" in C2 when any text/number is entered into B2. I have used te formula below entered into C2 but cannot get it to recognise any date entry into B2 even when using the wildcards * or ? =IF(B2=" ","looseletters.ca,""") I know it is probably a very...

I want to sort a total line of volumes under a certain date in excel 97. If the volumes are over 50 I want to see them or separate them. See example below. <TABLE style="WIDTH: 460pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=614 border=0 x:str><COLGROUP><COL style="WIDTH...

Hi all, I have been searching all over to resolve this problem and cannot find any help. I have creates an Excel Object in VFP to access a Excel file but VFP dose only reads Excel 5.0 format. So I then save the excel file to the new format. This works well I get a popup which the user has to...