Copy columns from one user selected workbook to another

Hi guys,

I am using this code to copy columns C,D, and P from a user selected workbook into position C,D,E of workbook "Checklist.xlsx" (the one from were I run the VBA code). I don't have a clue about VBA, just have been gathering info, but the code works pretty fine. The only issue is that it opens twice the workbook "wbExt" hence the system prompts me if i want to reopen the already open workbook (anoying).

Some questions:

1) Is there a way to copy the 3 columns at once? something like "Columns("C:D, P").Select".
2) Is there a way to select the workbook from were to copy the column without needing it to actually open?
3) is there a way to paste the columns starting from row 3 instead of row 1 (Range("C1").Select)?
I would really appreciate your help.

Thank you.
Regards,

Please Login or Register  to view this content.

Hi, bellfano,

welcome to ExcelForum. Accrording to our Forum Rule #3 you would need to add code-tags to your procedure.

Ciao,
Holger

Hi, Hi, bellfano,,

according to my knowledge you would need to do the copying for each range on it´s own as you have recorded.
Getting data from closed workbooks is mostly done using ADO - maybe have a look Copy a range from closed workbooks (ADO).
You can´t add a full column starting at Row 3

Please Login or Register  to view this content.

Ciao,
Holger