Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help importing data from a closed workbook
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Get Data From Closed Workbook | Excel Worksheet Functions | |||
add data to a closed workbook | Excel Programming | |||
PUT data in closed workbook | Excel Programming | |||
getting data from closed workbook | Excel Programming | |||
getting data from closed workbook | Excel Programming |