View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Iskus23
 
Posts: n/a
Default 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