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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help importing data from a closed workbook
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 |
Reply |
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 |