Pasting in Data from File Path

[nirvehex]

Hi, question on pasting in data from an excel file into another excel file - and I'm not even sure this possible, but wanted to see if it is.

I basically want to have a macro that pops open a File Open Box that allows you to select an excel file. Once you select that file, the macro references the data in that file on Sheet1 and copies cells A1 over to the end and down to the end and pastes it to the WOs tab in cell A2.

Is this possible to do?

Thanks!

 

[nirvehex]

That worked! I do get an annoying pop up box that says "There is a large amount of information on the clipboard. Do you want to be able to paste this information into another program later?" Yes No Cancel

Anyway to avoid this popping up or just close it automatically with the VBA?

Thanks for helping with the weird tweaks! Sorry for the hassle.

 

[nirvehex]

Nevermind - figured it out.

Application.DisplayAlerts=False

Thanks again Fluff!

 

[Fluff]

A better way would be to add this line to the end of the code

Application.CutCopyMode = False