I want to copy a row from one excel file and want to paste in another excel file as a column.
The following code works fine if the target is the same excel file. but if it is a new excel file this it shows error in VB?
PasteSpecial Paste:=xlAll, Operation:=xlNone, SkipBlanks:=False _
Can any one tell me how can i copy a row from one excel file and paste in another as a column from VB?