Import data from files with different names to EXCEL D'base.

I have partly set-up an EXCEL Database which will have a macro to Import data from files with different names.

These files have all been set-up with the same layouts and contain 5 worksheets ... 4 require various inputs by the 'End Users' and 1 has been set-up so that it has 1 row of information, which is populated by the Inputs from the other 4 worksheets i.e. by Cell Referencing. This row of data has been given a 'Named Range' ("Database_Line") in preparation for the Import into the Database (called "CR Database").

My problem is that the 'End Users' will be giving all sorts of different names to the files to be Imported from.

What I want to happen within an Import Macro, which will operate from a 'Button' in "CR Database", is that a Dialogue Box will open so that the Database Operator can Browse/Navigate to the required file, Select it, then the macro will continue to Import the one 'Named Range' ("Database_Line") of information into "CR Database".

I have most coding sorted, but I just can't work-out how to get a Dialogue Box to open, for Browsing/Navigation, and then for the macro to continue operating once the required file has been selected. Help!!!!! .

Most of my Coding is done by using the 'Record Macro' option within EXCEL, but I can edit/add some coding that 'Record Macro' won't do, so I do have some limits in understanding coding ...... but, for an "oldy", I'm learning .

Help is desperately needed on this, so if you want any further details let me know. I'm using EXCEL 2000.

Thunderfoot,

Something along the lines of

Sub TryNow()
Dim myBk As Workbook
Set myBk = Workbooks.Open(Application.GetOpenFilename _
(, , "Select the file"))
Range("Database_Line").Copy _
ThisWorkbook.Worksheets(1).Range("A65536").End(xlUp)(2)
myBk.Close False
End Sub

HTH,
Bernie
MS Excel MVP


"thunderfoot" <[email protected]>
wrote in message
news:[email protected]...
>
> I have partly set-up an EXCEL Database which will have a macro to Import
> data from files with _*different_names*_.
>
> These files have all been set-up with the same layouts and contain 5
> worksheets ... 4 require various inputs by the 'End Users' and 1 has
> been set-up so that it has 1 row of information, which is populated by
> the Inputs from the other 4 worksheets i.e. by Cell Referencing. This
> row of data has been given a 'Named Range' ("Database_Line") in
> preparation for the Import into the Database (called "CR Database").
>
> My problem is that the 'End Users' will be giving all sorts of
> different names to the files to be Imported from.
>
> What I want to happen within an Import Macro, which will operate from a
> 'Button' in "CR Database", is that a Dialogue Box will open so that the
> Database Operator can Browse/Navigate to the required file, Select it,
> then the macro will continue to Import the one 'Named Range'
> ("Database_Line") of information into "CR Database".
>
> *I have most coding sorted, but I just can't work-out how to get a
> Dialogue Box to open, for Browsing/Navigation, and then for the macro
> to continue operating once the required file has been selected.
> Help!!!!!* .
>
> Most of my Coding is done by using the 'Record Macro' option within
> EXCEL, but I can edit/add some coding that 'Record Macro' won't do, so
> I do have some limits in understanding coding ...... but, for an
> "oldy", I'm learning .
>
> Help is desperately needed on this, so if you want any further details
> let me know. I'm using EXCEL 2000.
>
>
> --
> thunderfoot
> ------------------------------------------------------------------------
> thunderfoot's Profile:
http://www.excelforum.com/member.php...o&userid=17341
> View this thread: http://www.excelforum.com/showthread...hreadid=377677
>

Bernie,

Thanks. This bit of coding is nearly what I want. I can work on it to get it to do exactly what I want.

You sorted my major problem, which was how to get "Select the File" dialogue box to open then get the macro to continue once the file was selected.