Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Consolidate User Input
Hello,
I'm at an early stage of designing a spreadsheet that will be used by staff to enter their expenses. My aim is that a user enters information into the file, sends to an administrator who consolidates the company picture. I can get the user input to appear in the same cells in each file but need a method centrally to read or open the file, store specific detail into another spreadsheet file from which we can work on, all this needs to happen with little intervention from the administrator. There will be about 100 files per week and the consolidation needs to be on those with a certain weekending date. I've seen something in Lotus that looked in a closed file and read the contents of the cell but can't get the same to happen in Excel. Any help greatly appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Consolidate User Input
There is no File, Combine command in Excel like in old 1-2-3. Old 1-2-3
needed this because only one file could be opened at a time. But there is no such limitation in Excel. So, open each workbook and copy from it, pasting into the consolidation workbook. -- Jim Rech Excel MVP |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Consolidate User Input
Thanks for the clarity between 1-2-3 and Excel, I could have spent ages
looking. Are there other ways of getting data in say a known range name from one file into another without opening the data file? Thanks, Robert "Jim Rech" wrote in message ... There is no File, Combine command in Excel like in old 1-2-3. Old 1-2-3 needed this because only one file could be opened at a time. But there is no such limitation in Excel. So, open each workbook and copy from it, pasting into the consolidation workbook. -- Jim Rech Excel MVP |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Consolidate User Input
It's possible to read data from a closed Excel file using ADO and no doubt
other database techniques. I've never used ADO except to play around with it years ago. It may be overkill depending on your needs but you can find a lot of articles on it if you search the MSKB on "ADO", for example: http://support.microsoft.com/default...73&Product=xlw For my needs, open, copy, paste, close, works super<g. -- Jim Rech Excel MVP |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Consolidate User Input
Thanks very much Jim, I'll try ADO as I feel that a 100 files per week needs
to be automated. Regards, Robert "Jim Rech" wrote in message ... It's possible to read data from a closed Excel file using ADO and no doubt other database techniques. I've never used ADO except to play around with it years ago. It may be overkill depending on your needs but you can find a lot of articles on it if you search the MSKB on "ADO", for example: http://support.microsoft.com/default...73&Product=xlw For my needs, open, copy, paste, close, works super<g. -- Jim Rech Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prompt user for input and utilize that input | Excel Worksheet Functions | |||
Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
CODE to select range based on User Input or Value of Input Field | Excel Programming | |||
Get User Input | Excel Programming | |||
Get User Input | Excel Programming |