| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column retrieval as an input to an existing workbook
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" a écrit dans le message de ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Move column to in-between existing columns | Excel Discussion (Misc queries) | |||
| copy COLUMN from 1 worksheet to another (in a different workbook) | Excel Discussion (Misc queries) | |||
Threaded Mode
