Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Importing from one workbook to another
I have a blank workbook with a lot of VBA Macro Code behind it. This .xls
file is created from a template with the code behind it. I need to transfer (import or merge) a spreadsheet from Camerroon to the United States. I receive the Workbook fine, but when I open it in English all the columns look like Dates. I tried to change the .xls file from Africa automatically but it would not work. It will work if I do it manually. The bank president does not trust the accountant in changing 53 columns every day. I want to import the workbook received from Camerroon to the Blank workbook I have created from the Template. I am very new to Excel (before last week never used it) and am struggeling with how to import the data to my blank Workbook. The computer used is not on a network, it is a stand along PC. Thanks again in advance. Bill |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Importing from one workbook to another
Bill,
Have you tried, DATA-- Get External Data? If so, what happens? "Bill Barber" wrote: I have a blank workbook with a lot of VBA Macro Code behind it. This .xls file is created from a template with the code behind it. I need to transfer (import or merge) a spreadsheet from Camerroon to the United States. I receive the Workbook fine, but when I open it in English all the columns look like Dates. I tried to change the .xls file from Africa automatically but it would not work. It will work if I do it manually. The bank president does not trust the accountant in changing 53 columns every day. I want to import the workbook received from Camerroon to the Blank workbook I have created from the Template. I am very new to Excel (before last week never used it) and am struggeling with how to import the data to my blank Workbook. The computer used is not on a network, it is a stand along PC. Thanks again in advance. Bill |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Importing from one workbook to another
Iskus;
Nothing. All the data came in exactly the same. The Macros behind the code never ran. If the Macros would run this would help a lot because then the operators would only be required to do one thing manually. If I can get the External Data automatically (Using Macro's) and run the Macro code at the same time that would be best. Thanks for Trying to Help Bill "Iskus23" wrote: Bill, Have you tried, DATA-- Get External Data? If so, what happens? "Bill Barber" wrote: I have a blank workbook with a lot of VBA Macro Code behind it. This .xls file is created from a template with the code behind it. I need to transfer (import or merge) a spreadsheet from Camerroon to the United States. I receive the Workbook fine, but when I open it in English all the columns look like Dates. I tried to change the .xls file from Africa automatically but it would not work. It will work if I do it manually. The bank president does not trust the accountant in changing 53 columns every day. I want to import the workbook received from Camerroon to the Blank workbook I have created from the Template. I am very new to Excel (before last week never used it) and am struggeling with how to import the data to my blank Workbook. The computer used is not on a network, it is a stand along PC. Thanks again in advance. Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
Auto updating a workbook with data from another workbook | Excel Discussion (Misc queries) | |||
Importing data from palm excel to desktop workbook | Excel Discussion (Misc queries) | |||
How to hyperlink from a workbook to sheets in another workbook? | Excel Worksheet Functions | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) |