Update a Querytable in an XLA
I want to update data from a Querytable. I want to do it each "x" minutes automatically. But the data I want to update is located in sheet of an add-in (xla). I try do it without sucess, it only works if the data is located in a workbook (xls).
The code that configure the data update is this:
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.RefreshOnFileOpen = Chk3.Value
.BackgroundQuery = Chk1.Value
.SaveData = True
If CHk2.Value Then .RefreshPeriod = CInt(TextBox1.Text)
It works when I export the sheet of the add-in to an active workbook. It doesn't work to update the sheet inside the add-in.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL