Cannot post to worksheet, possibly locked?

  • Thread starter Thread starter DenMiller57
  • Start date Start date
D

DenMiller57

I have some automation code where I am posting some data from an Access
DB to a formatted, unlocked Excel Spreadsheet. The Workbook (wb) has 3
worksheets (ws) named MEL, ERD, RCPT. The problem I am having is
posting to the ERD ws. At first I thought it was because the ERD was
ws(2), but then when I swapped with MEL with ERD and made the ERD the
first ws, it still would not post to the ERD. In both cases, I had no
problems posting to ws MEL whether it was ws(1) or ws(2). This wb is
formatted with many merged cells. However the cells in the MEL
worksheet are formatted no different that the ERD worksheet. I thought
the ws does not show it being locked. So as a test, I have created a
blank, unformatted WB with the only thing different is that the cells
are merged identically to the ERD and MEL ws. The data posts to the
cells in both worksheets correctly. What else can I look at to solve
this problem. I can post the automation code is necessary. I think the
problem is in the Excel ws, am I correct and how can remove any locks or
limitations to the ws? Thanks for any direction.
Dennis
 
I ran in to a similar problem last week. I solved it by copying all my data
from the "infected" worksheet over to a new worksheet and deleting the
first. You might have the same luck if you try.

Vaya con Dios,
Chuck, CABGx3


"DenMiller57" <[email protected]>
wrote in message
news:D[email protected]...
 
Back
Top