Macro reading columns incorrectly using ajax client

sangland2 — Wed, 25 Nov 2020 16:16:04 GMT

I use the code below to locate the correct column number (by name) to use in GetCell function.

' get column numbers of interest

for RowIter = 0 to sObject4.GetRowCount-1 ' traverse rows in table

if RowIter = 0 then

for ColIter = 0 to sObject4.GetColumnCount-1

set colName = sObject4.GetCell(RowIter,ColIter)

if colName.Text = "Invoice Value" then l_col_value = ColIter end if

end if

MsgBox l_col_value

.....

set l_value = sObject4.GetCell(RowIter,l_col_value )

I have been struggling to find a reason why I get a different result in the designer and with the web browser

This post explained that the a natural sort order of columns in straight tables is necessary to get the same result.

Do not drag and drop columns if you want to use macros like this.

Re: Macro reading columns incorrectly using ajax client

marcus_sommer — Sun, 04 Sep 2016 09:10:57 GMT

Had you checked the values of your table (maybe with some selections to don't run through thousands of cells):

for RowIter = 0 to sObject4.GetRowCount-1

for ColIter = 0 to sObject4.GetColumnCount-1

msgbox(sObject4.GetCell(RowIter,ColIter).Text)

maybe they are different to your expectation.

- Marcus