I do a vlookup from a file 'A' to a file 'B' which had
some 6000 lines. I just do a vlookup on one cell and then
copy paste the remmaining cell values for speeding up.

the problem is when i am using the file for the vlookup
and in the end i close it then the file is not getting
closed. its very strange though. if i comment the vlookup
thing then at the end of the macro i can close it very
smoothly.

what is the reason. I am struggling for it for so long!

thanks in advance

Hi

it might have to do with calculating the workbook .. you might like to turn
automatic calculation off in your code at the start of the procedure

Application.Calculation = xlManual

and then turn it back on at the end and see if this makes a difference

Application.Calculation = xlAutomatic

Cheers
JulieD

wrote in message
...
I do a vlookup from a file 'A' to a file 'B' which had
some 6000 lines. I just do a vlookup on one cell and then
copy paste the remmaining cell values for speeding up.

the problem is when i am using the file for the vlookup
and in the end i close it then the file is not getting
closed. its very strange though. if i comment the vlookup
thing then at the end of the macro i can close it very
smoothly.

what is the reason. I am struggling for it for so long!

thanks in advance

Hey
thanks julie
the problem still persisits. its only when i complete the
macro and in the end if i try and close the workbook "B"
its takes time. (the macro is written for workbook "a".
this is a very strange thing.

i am not writing anythin gin workbooks"B" ... if ideally i
open it and then close it ; it closes imm and smoothly,

whereas if i do a vlookup using that workbook then it
simply hangs!!!!!!

what could be the problem...i am scratching my head since
morning!
-----Original Message-----
Hi

it might have to do with calculating the workbook .. you
might like to turn
automatic calculation off in your code at the start of
the procedure

Application.Calculation = xlManual

and then turn it back on at the end and see if this makes
a difference

Application.Calculation = xlAutomatic

Cheers
JulieD

wrote in message
...
I do a vlookup from a file 'A' to a file 'B' which had
some 6000 lines. I just do a vlookup on one cell and
then
copy paste the remmaining cell values for speeding up.

the problem is when i am using the file for the vlookup
and in the end i close it then the file is not getting
closed. its very strange though. if i comment the
vlookup
thing then at the end of the macro i can close it very
smoothly.

what is the reason. I am struggling for it for so long!

thanks in advance


.

I may be on the wrong track here, but i've had problems in workbooks where i
have a lot of VLOOKUP statements as VLOOKUP is volatile and keeps wanting to
recalculate all the time ..

so maybe after running the code, you turn calculation to manual (tools /
options / calculation - manual) and then try & close the workbook.

Cheers
JulieD




line in the code but remove the o
wrote in message
...
Hey
thanks julie
the problem still persisits. its only when i complete the
macro and in the end if i try and close the workbook "B"
its takes time. (the macro is written for workbook "a".
this is a very strange thing.

i am not writing anythin gin workbooks"B" ... if ideally i
open it and then close it ; it closes imm and smoothly,

whereas if i do a vlookup using that workbook then it
simply hangs!!!!!!

what could be the problem...i am scratching my head since
morning!
-----Original Message-----
Hi

it might have to do with calculating the workbook .. you
might like to turn
automatic calculation off in your code at the start of
the procedure

Application.Calculation = xlManual

and then turn it back on at the end and see if this makes
a difference

Application.Calculation = xlAutomatic

Cheers
JulieD

wrote in message
...
I do a vlookup from a file 'A' to a file 'B' which had
some 6000 lines. I just do a vlookup on one cell and
then
copy paste the remmaining cell values for speeding up.

the problem is when i am using the file for the vlookup
and in the end i close it then the file is not getting
closed. its very strange though. if i comment the
vlookup
thing then at the end of the macro i can close it very
smoothly.

what is the reason. I am struggling for it for so long!

thanks in advance


.

ni it jsut doesnt work..

i have given up..,.:-(((((
-----Original Message-----
I may be on the wrong track here, but i've had problems
in workbooks where i
have a lot of VLOOKUP statements as VLOOKUP is volatile
and keeps wanting to
recalculate all the time ..

so maybe after running the code, you turn calculation to
manual (tools /
options / calculation - manual) and then try & close the
workbook.

Cheers
JulieD




line in the code but remove the o
wrote in message
...
Hey
thanks julie
the problem still persisits. its only when i complete
the
macro and in the end if i try and close the workbook "B"
its takes time. (the macro is written for workbook "a".
this is a very strange thing.

i am not writing anythin gin workbooks"B" ... if
ideally i
open it and then close it ; it closes imm and smoothly,

whereas if i do a vlookup using that workbook then it
simply hangs!!!!!!

what could be the problem...i am scratching my head
since
morning!
-----Original Message-----
Hi

it might have to do with calculating the workbook .. you
might like to turn
automatic calculation off in your code at the start of
the procedure

Application.Calculation = xlManual

and then turn it back on at the end and see if this
makes
a difference

Application.Calculation = xlAutomatic

Cheers
JulieD

wrote in message
.. .
I do a vlookup from a file 'A' to a file 'B' which had
some 6000 lines. I just do a vlookup on one cell and
then
copy paste the remmaining cell values for speeding up.

the problem is when i am using the file for the
vlookup
and in the end i close it then the file is not getting
closed. its very strange though. if i comment the
vlookup
thing then at the end of the macro i can close it very
smoothly.

what is the reason. I am struggling for it for so
long!

thanks in advance


.



.