If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Re: [Excel] Copy data from specific cells to another workbook

open workbooks are indexed by name, not path and name

vb Code:

strFirstFile = "Schéma récap MG.xls"

i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next

dim all variablesas required as often i have done so elsewhere in my code but only posted the relevant part

come back and mark your original post as resolved if your problem is fixed
pete

i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next

dim all variablesas required as often i have done so elsewhere in my code but only posted the relevant part

come back and mark your original post as resolved if your problem is fixed
pete