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


--
DenMiller57
------------------------------------------------------------------------
DenMiller57's Profile: http://www.excelforum.com/member.php...o&userid=34175
View this thread: http://www.excelforum.com/showthread...hreadid=539414

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" <(E-Mail Removed)>
wrote in message
news(E-Mail Removed)...
>
> 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
>
>
> --
> DenMiller57
> ------------------------------------------------------------------------
> DenMiller57's Profile:
http://www.excelforum.com/member.php...o&userid=34175
> View this thread: http://www.excelforum.com/showthread...hreadid=539414
>