VBA Find Code not working with XML file like it did in XLS file - Please Help

All,

I had code working in an XLS file, but it does not work in XML files. I had a find working in the XLS file and it looked like this

Please Login or Register  to view this content.

Setting the variable beginRow to Str(ge.Row) is giving me no value. It used to find the variable and put the column and row to start in. The find still finds the variable gMycell, but it does not convert it to a cell location when it gets down to the beginRow = Str(ge.Row)

Does anyone know a fix for this? I don't know why it does not work when it used to except for changing file types. This is all I can think of.

Thank you -- SEOT

Anyone have an idea on this one? I am going to run it by a friend tomorrow. I will let you know what they tell me. They might can get it. --SEOT

I found out more now. The XML file is not really an Excel file, so I am trying something else now. I am taking the .xml file that downloaded out of our accounting system and saving it as a .xls file like I used to use. Now, I try to use the code I used to have working with the .xls file, and I am getting the following error 'object variable or with block variable not set'

My code now is the following:

Please Login or Register  to view this content.

The error I get is on line 'beginRow = ge.Row'

Thanks for any help you can give. - SEOT

I have alot of global variables declared in another module in the Excel VBA code. Here is a long list of them

Please Login or Register  to view this content.

Anyone have a clue on this. I am still at a loss. -SEOT

Please Login or Register  to view this content.

beginRow = ge.Row
This line of code gives me a run-time error '91' - Object Variable or With Block Variable Not Set
I cannot figure out how to get past this error

Please Login or Register  to view this content.

My gbeginRow is declared in under the code above in a different Module, so it is declared in my program.

Still Stuck.... Anyone know???- SEOT

I found a work around, and I have most of my code working again. I got another point stuck, but I will post that in a different area as a different post. The work around is saving the XML down to an Excel 97-2003 Worksheet after downloading it off the system. I have it saving it in the old format in the code before working on the sheets. Then, I don't have to deal with XML. -- SEOT