Importing data from oracle over ODBC in sheet which has preexisting columns with formula

[pam79]

Hi all,

I have sepnd 2 days seraching on net to get answer to what I am trying but in vain. Any help on this is HIGHLY appreciated.

Here is what I am trying to do:
I have one sheet in which I am fetching data from ODBC (Oracle conection). This data goes into column A1:T200. This data is imported as table (Table1) may be becuase I am using
With Sheets("Sheet1").ListObjects.Add(SourceType:=0, Source:=Array(Array( ......)

In column V, I have created formula based on Table1_ColumnT.

I need to refresh/import Table1 frequently and before that I need to clearcomtent or delete the table. I am facing issues with both these.
If I do clearContent before importing new data, it gives me error 1004: A table cannot overlap a range ....
If I do delete on Table1, my column V (where formula resides) becomes column B and then gets overwritten when refresh/import happens.

I badly need help in this as after 2 days I am going no where.

Thanks in advance.

[stojko89]

You can try using this function to add the forumla after the table is copyed to the sheet.

Please Login or Register  to view this content.

Offset = how many rows down from the active cell, how many columns right of the active cell.
You can change that.
Thats one option how to do it maby some one will come up with a better solution.

[pam79]

Thanks for quick response. I will try this but my limitation is, I am going to give this excel file to others once ready and they would be adding further formula columns as needed. They wouldn't be writing VB code for the same hence I would prefer to have the formula in excel column rather than in VB, if possible !

Anyone can please help here ?

[stojko89]

Actualy this addeds the formula to the cell you want. It doesn't keep the formula working in the background.
Well, As you wish. I can't help you the other way, sory.