Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unable to run macro in Office 2007
Hi,
I have one macro which runs in Excel 2003 but dosent run in Office 2007. This macro also runs in compatibility mode excel but dosent work in 2007 macro enable excel. Please find below is the code. Is there any reference which we need to setup. This macro is to get the data from database. Please find below is the code and where I am getting the error. Error I am getting is "Runtime error 424, Object required". Please help me in this. Sub Get() Dim i1 As Integer Dim str1 As String i1 = 2 While [querylist].Cells(i1, 1) < "" --This is the place where I am getting error in Excel 2007 CreateQuery (i1) i1 = i1 + 1 Wend Worksheets("Sheet1").Select ActiveWorkbook.Save End Sub Thanks, Mahesh |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unable to run macro in Office 2007
I'd try:
While Range("querylist").Cells(i1, 1).Value < "" -- Jim "Mahesh" wrote in message ... Hi, I have one macro which runs in Excel 2003 but dosent run in Office 2007. This macro also runs in compatibility mode excel but dosent work in 2007 macro enable excel. Please find below is the code. Is there any reference which we need to setup. This macro is to get the data from database. Please find below is the code and where I am getting the error. Error I am getting is "Runtime error 424, Object required". Please help me in this. Sub Get() Dim i1 As Integer Dim str1 As String i1 = 2 While [querylist].Cells(i1, 1) < "" --This is the place where I am getting error in Excel 2007 CreateQuery (i1) i1 = i1 + 1 Wend Worksheets("Sheet1").Select ActiveWorkbook.Save End Sub Thanks, Mahesh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to open Office 2007 files using Office 2002 XP | Excel Discussion (Misc queries) | |||
Unable to open files after installing Office 2007 refresh !!! | Excel Discussion (Misc queries) | |||
Where in Office 2007 can I record a macro? | Excel Worksheet Functions | |||
Performance not upto Office 2003 standards in Office 2007 | Excel Discussion (Misc queries) | |||
Unable to access the Office Online Web site in Office 2003, Excel | Excel Discussion (Misc queries) |