Column retrieval as an input to an existing workbook

yeah, I already did that... but it doesn't seem to work..

when you say assume that the workbooks are open, do you mean the excel application itself or I have to open it using a vb6 code?

also, is it necessary for the excel files that i'm using to be in the same folder as my project? or can I just indicate the file path in the conts itself...

sorry, i really have no idea

Yes, the way my code is written, you have to manually open both src & dest
Worbooks before you run the macro.

No: don't indicate the full file path in the consts.

Depending on where you want to store the macro (src or dest WB or another
WB),
I can adapt the macro so that it opens the WB's

Cheers,
--
AP

"NaomiKay" <[email protected]> a écrit
dans le message de
news:[email protected]...
>
> yeah, I already did that... but it doesn't seem to work..
>
> when you say assume that the workbooks are open, do you mean the excel
> application itself or I have to open it using a vb6 code?
>
> also, is it necessary for the excel files that i'm using to be in the
> same folder as my project? or can I just indicate the file path in the
> conts itself...
>
> sorry, i really have no idea
>
>
> --
> NaomiKay
> ------------------------------------------------------------------------
> NaomiKay's Profile:
http://www.excelforum.com/member.php...o&userid=32159
> View this thread: http://www.excelforum.com/showthread...hreadid=519105
>