Export to excel problem

[bretdunlap]

I have a challenge with an export. I can easily export my query to excel when I open it is there. The challenge is when I use ms pub or word to merge the data.

I have a tab that calculates some of data. so I need to use that data, I can see it whne I open it as well. The problem is wehn I merge the data from any other tab that ends with $ i get the previously saved data.

the only way to see it for my merge is to open the work book then save it replacing the old one. Is there away to work around this or save the work book when new data is imported without wornings

 

[bretdunlap]

Found a work around added this to my merge code basically it opens and saves the file.

Dim XLapp As New Excel.Application
Dim ObjXL As Excel.Workbook

Set ObjXL = XLapp.Workbooks.Open("C:\Users\James Bret Dunalp\Desktop\Office Forms\Import excel\Family to exce query Prospects.xlsx")

ObjXL.Application.Visible = True
ObjXL.Windows(1).Visible = True
ObjXL.Worksheets(1).Activate
ObjXL.Save
ObjXL.Close
XLapp.Quit

 

[bretdunlap]

In addition I had to click the Microsoft Excel 12.0 library

 

[Adam101]

I was also looking for this its nice suggestion you have really helpful experience share with us ..
Thanks for this now I will try to make it done with the help of this chart..

 

[bretdunlap]

glad it helped this form has helped me so much I am glad I could give a little back.