Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Bug: Run-time error '-2147417848 (80010108)'
I have been getting the following error:
Run-time error '-2147417848 (80010108)' Method 'Paste' of 'object'_Worksheet' failed The code below is generating that error when i choose yes to save thi file as i am closing the excel file. the code works fine if i jus click on save the save button before closing. another strange thing i that after my code generates this error, excel won't close. it i still partially functional. i can open a file. however, once i open th file, there is content in the cells that i can see in the forumla ba but the part of the screen where the worksheet is supposd to be is al white. i'm thinking that this is some kind of bug in excel. anyone kno whats going on? Btw, the error is generated on the line marked with an asterik Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel A Boolean) Workbooks.Open ("C:\Documents and Settings\Adam\Desktop\Monthl Sales\Bars 2004.csv") Workbooks("Bars 2004.xls").Worksheets("Total Bar MASTER").Activate Range("D10:O12").Copy Excel.Windows("Bars 2004.csv").Activate Range("D10").Select *Excel.Workbooks("Bars 2004.csv").Worksheets("Bars 2004").Paste Excel.Workbooks("Bars 2004.csv").Close End Su -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Bug: Run-time error '-2147417848 (80010108)'
to add to that... this is very interesting. my excel is now consumin
all available cpu usage and my total cpu usage is at 100% until decide to end the process -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automation error '-2147417848 (80010108)' excel 2007 | Excel Discussion (Misc queries) | |||
Run time error '-214741848 (80010108) | Excel Programming | |||
Automation error -2147417848 (80010108) | Excel Programming | |||
Excel 2000 - range.calculate error - 2147417848 | Excel Programming | |||
Run time error 2147417848(80010108) | Excel Programming |