Mircosoft Query

[brettvba]

If the Data gets refreshed at the start of a macro for Excel does the macro wait for the data to be refreshed before continuing??

 

[Jack in the UK]

Can i see the code i use ODBC via VBA every day many times a day this should not happen??

Excel ODBC is ripping from what ?? crystal (should self contain) or some bespoke system

ill look at the code if you like,,,

5 mins ODBC is not long for 5 sheets so code and links is good...

theres little secret in VBA codes so should be ok to post ... un less passwords but once signed in to ODBC should stay in an no PW reqd... again that session, untill you log off the network that is..

 

[brettvba]

Jack im not using code to transfer the data I have set it up via Microsoft query and it refreshes like a pivot table so what i have found is that it has to be run like the below
Sheets("111stk").Select
Range("a2").Select
Selection.QueryTable.Refresh BackgroundQuery:=False
Sheets("211stk").Select
Range("a2").Select
Selection.QueryTable.Refresh BackgroundQuery:=False
Sheets("511stk").Select
Range("a2").Select
Selection.QueryTable.Refresh BackgroundQuery:=False
Sheets("832stk").Select
Range("a2").Select
Selection.QueryTable.Refresh BackgroundQuery:=False
Sheets("834stk").Select
Range("a2").Select
Selection.QueryTable.Refresh BackgroundQuery:=False
Sheets("834stk").Select
Range("a2").Select
Selection.QueryTable.Refresh BackgroundQuery:=False


and it waits for each one to run but the stupid thing is crashing now is there another way of tranfering the data I thought that way was a good way because I have to provide this program for about 10 others to use and I want it so that it doesn't need heaps of extra files , My IT dept doesn't like the Idea of a macro retriving data from the as400 system so I think that the mircosoft query is the only way to go appart from using a data transfer file which is a seperate file altogether

I basically just want to refresh the data on a specific sheet then perform some other bits and pieces with the data in the same macro.