Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Run-Time Error 2147221080 (800401a8)

Posted on 2017-10-12
Low Priority
Last Modified: 2017-10-16
Every time I attempt to run excel through a database we set-up in it, I get the error "Run-Time Error 2147221080 (800401a8) Method Worksheet of object _Workbook failed."

The guy we had create this doesn't know what is wrong. I am not an expert of excel so I can't explain much. From what I know, it seems when we run the program, it adds a "1" to the end of one of the templates it's referring to. This stops our whole process. We cannot figure out where the 1 is being added from and why. PLEASE HELP!!

The debugger refers to the line, wkbkOutput.Worksheets(1).Range("A" & lngOutputRow).Value = wkbkInput.Worksheets(1).Cells(lngInputCurrRow, INPUT_COLUMN_DATE) ' date

This was working perfectly fine last week, all the sudden on Monday this error happened. Nothing was updated on my computer. The issue came out of the blue, but has been happening to other people in my office.
Question by:Maelynn Dickson
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 60

Expert Comment

ID: 42329173
need to see the values here

wkbkOutput.Worksheets(1).Range("A" & lngOutputRow).Value = wkbkInput.Worksheets(1).Cells(lngInputCurrRow, INPUT_COLUMN_DATE)

Open in new window

put this

MsgBox lngOutputRow & "-" & lngInputCurrRow & "-" & INPUT_COLUMN_DATE

Open in new window

or this

dim test
test = lngOutputRow & "-" & lngInputCurrRow & "-" & INPUT_COLUMN_DATE
MsgBox test

Open in new window

before offending code and save/close and open again and see what is happening...

Author Comment

by:Maelynn Dickson
Do I put that new code in replace of the current one?

LVL 60

Expert Comment

you said it is giving error and showing some code...
copy paste this on top of that line, save close open and you should see a popup with values
so we can see whats wrong, hopefully

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Join & Write a Comment

In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question