Help importing data from a closed workbook

[Elvis The King]

Hello,

For the past several years we've been using a worksheet to do our customer
quotes. I thought I'd be really slick (I'm now finding out that I'm not near
as slick as I thought I was) if I could copy the customer information from a
saved workbook into the current workbook.

I would like to have a command button that would get an open file dialog box
or maybe run a macro where the user can select which quote to import the
customer data from. All of the quotes have a different name and they reside
in different directories. The customer data however is always in the same
cells. For example: Customer Name is always in B5, Customer Phone Number is
always in C8 etc.

I am quite the novice at VBA and have had number of failed attempts. I would
truly appreciate anybody that can offer an example of how this can be done.

Thanks in advance,

Todd

[PY & Associates]

Use getopenfilename method to display files to pick
open the picked file
import data
close the data file
if necessary, loop again for another file


"Elvis The King" wrote:

> Hello,
>
> For the past several years we've been using a worksheet to do our customer
> quotes. I thought I'd be really slick (I'm now finding out that I'm not near
> as slick as I thought I was) if I could copy the customer information from a
> saved workbook into the current workbook.
>
> I would like to have a command button that would get an open file dialog box
> or maybe run a macro where the user can select which quote to import the
> customer data from. All of the quotes have a different name and they reside
> in different directories. The customer data however is always in the same
> cells. For example: Customer Name is always in B5, Customer Phone Number is
> always in C8 etc.
>
> I am quite the novice at VBA and have had number of failed attempts. I would
> truly appreciate anybody that can offer an example of how this can be done.
>
> Thanks in advance,
>
> Todd
>
>
>
>