Re: $$Excel-Macros$$ .Refresh Background:-False

2011-05-11 Thread Sobavia
Thanks Ashish. It helped Sent from my iPhone On May 9, 2011, at 2:53 AM, ashish koul koul.ash...@gmail.com wrote: see if it helps CODE: With ActiveSheet.QueryTables.Add(Connection:=Array(Array( _

Re: $$Excel-Macros$$ .Refresh Background:-False

2011-05-09 Thread ashish koul
see if it helps CODE: With ActiveSheet.QueryTables.Add(Connection:=Array(Array( _ ODBC;DSN=PP;UID=ris;PWD=ri;DBQ=PP;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;GDE=F;FRL=F;BAM=IfAllSuccessful;MTS=F;MDI=F _ ), Array(;CSR=F;FWC=F;PFC=10;TLO=0;)), Destination:=Range(A1))