Open and save files with macro, with dialog box

**kohedin** · 12-18-2012, 08:14 AM

Hi
Been lurking the board for a while now, and must say this is an awesome place to selfeducate and learn alot of tricks.

However, I have a problem that I cant find an answer to. It goes like this:

Click a button in Masterfile.xlsm -> Opens a dialog box with text "Chose file to collect data from:" -> Opens the file and copies text from a predetermined range (ie A1:C30) and paste it to another range (ie B1:D30) in the Masterfil

Also, need another button: Click the button -> Opens a dialog box with text "chose filename" -> user writes filename -> Saves the file to a predetermined path with the filename written in the dialog box

Thanks in advance!

**Naveed Raza** · 12-18-2012, 08:40 AM

Hi,

could u plz provide 2 example workbooks one is masterfile and another one the data file.

Thanks - Naveed.

**kohedin** · 12-18-2012, 01:36 PM

Here is the basic idea of what I mean..

**Naveed Raza** · 12-18-2012, 01:40 PM

k i will get back to u tmorrow

**Naveed Raza** · 12-19-2012, 07:46 AM

Hi,

please have test attached workbook and let me know is it what u looking or not.

this will ask u to select a select file to import data in master file and this macro will copy only cells J2 to L15 and this will paste in master file in G2 to I14.