excel 2007 query question
in [General]
|
Prev: Formating cells - "Too Many Different Cell Formats" Error
Next: How do extract cells from hundreds of excel files and put in one n
From: Ed Ferrero on 19 Nov 2009 23:12 Hi Gary, >i just want the query to run in both versions. are you saying that > rng.QueryTable.Refresh BackgroundQuery:=False > > should work in both versions? > Yes, try it. The difference in versions is that creating a data query in 2007 will automatically put it in a ListObject. So you could have both ListObject and QueryTable objects in one workbook - some created in 2003, some created in 2007. The code will handle both types. Ed Ferrero www.edferrero.com
From: Gary Keramidas on 20 Nov 2009 15:41
ok, i'll have them try it. i thought they had an issue with that query refresh in 2007, that's why i was looking to change it. the problem is, i don't have the client's as400 or data to run the query myself, so it takes a while to get it tested, thanks. -- Gary Keramidas Excel 2003 "Ed Ferrero" <ed(a)edferrero.com> wrote in message news:%23XSwJfZaKHA.1652(a)TK2MSFTNGP05.phx.gbl... > Hi Gary, > >>i just want the query to run in both versions. are you saying that >> rng.QueryTable.Refresh BackgroundQuery:=False >> >> should work in both versions? >> > > Yes, try it. > > The difference in versions is that creating a data query in 2007 will > automatically put it in a ListObject. > So you could have both ListObject and QueryTable objects in one workbook - > some created in 2003, some created in 2007. The code will handle both types. > > Ed Ferrero > www.edferrero.com |