Advertisement

09.30.2008 at 08:21AM PDT, ID: 23774933 | Points: 500
[x]
Attachment Details

named ranges do not appear in the xls

Asked by knn083 in Microsoft Excel Spreadsheet Software

Tags: , , ,

Hi,
I am creating named ranges programatically in the dynamically created .xls:

Public Sub doFinalSheetFormatting(dontshowup As Boolean)
        Range("B13:y13").Select
        If Range("B14").Value <> "" Then Range(Selection, Selection.End(xlDown)).Select
        With Selection
            .HorizontalAlignment = xlRight
            .Interior.ColorIndex = 2
        End With
        Range("B12:Y12").Select
        Range(Selection, Selection.End(xlDown)).Select
        ActiveSheet.ListObjects.Add(xlSrcRange, Selection, , xlYes).Name = ActiveSheet.Name & "List"
        Columns("K:Y").NumberFormat = "0.000%"
        Range("a1").Select
End Sub

in a different sub this file get's saved as:
    newWB.SaveAs filename:=newFileDir & newFileName

When I open the file in 2003 the above created named range does not exist. When I open THE SAME FILE in 2007 i see the named range

Need to make it work in 2003
Please advise
THank you in advanceStart Free Trial
[+][-]09.30.2008 at 09:22AM PDT, ID: 22606910

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.06.2008 at 12:38PM PDT, ID: 22653608

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.29.2008 at 12:06AM PST, ID: 23058982

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 - Hierarchy / EE_QW_2_20070628