paste to different xls files

[mrpink]

Hi y'all,

First off, I am a XL - VBA noob, meaning I have little experience. The only macro I ever wrote was to convert digits (or numbers) in full english, french or dutch text. (if anybody wants it, PM me) My employer (I am a college student doing a late "summer"-job) has asked me if it is possible to paste a selection to multiple distinct xls-files. These files do not have the same heading, which according to me can cause some difficulties...
Is this possible, and if so, can anybody help me? Does anybody know a site where I could download such a free macro?

thanks, your help is much appreciated

MrPink

 

[Andrew Poulsom]

This code will paste the current selection to a new workbook:

Sub Test()
    Selection.Copy
    Workbooks.Add
    ActiveSheet.Paste
End Sub

What are the names of the workbooks you want to copy the data to? And in which folder are they?