Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I always get the above error when my code was executed the
second time continuously. If I only run it once, there are no error. ----------------------------------------- Public Sub CreateExcelFile() Dim xlApp As Object Dim xlWorkBook As Excel.Workbook Set xlApp = CreateObject("Excel.Application") Set xlWorkBook = xlApp.Workbooks.Open("C:\test.xls") 'This portion will format the column B into a text column with leading zeros. Dim i As Integer Dim strT As String i = 1 strT = "" Do While Cells(i, "B").Text < "" strT = Cells(i, "B").Text Cells(i, "B").Formula = "=text(" & strT ", ""00000"")" i = i + 1 Loop xlWorkBook.SaveAs "C:\test1.xls", xlNormal xlWorkBook.Close Set xlWorkBook = Nothing xlApp.Quit Set xlApp = Nothing End Sub ----------------------------------------- I tried searching in the MS Knowledge Base & it returned article 815406, suggesting to install a post-Office 2000 SP3 fix. However I can't find the link to this fix... I'm not sure if the article is related to my error & how do I overcome it? Thanks! LT. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Charts.Add error '1004' Method 'Add' of object 'Sheets' failed | Charts and Charting in Excel | |||
Method 'Range' of object '_global' failed | Excel Discussion (Misc queries) | |||
runtime error 1004 method range of object '_global failed | Excel Discussion (Misc queries) | |||
"Run-time error '1004'" Method 'Range' of object '_global' failed. | Excel Programming |