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

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top