excel 97

  1. S

    Add Validation list in VBA Excel 97/2003 (.xls)

    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...
  2. K

    import data from one workbook to another

    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...
  3. L

    Using IF in Excel97

    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...
  4. L

    Pivot Table Sorting

    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...
  5. C

    SaveAs Excel 5.0 & Excel 97 format

    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...

Some videos you may like

This Week's Hot Topics