problem with import files by excel macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Raven - 20 Jan 2006 08:22 GMT

Hello,

I need to write/record a macro that takes multiple files(UNIX files)on
the local computer and then copy all their content back to a sheet of
the excel and then manipulate the data to generate a report. I
particularly need help with macros that can import multiple files. I
have come across an excel application whose button can prompt a windows
and import ONE file to do similiar thing. However, what I want to do is
more sophisticated. Do you have any idea?? do you have any resources
from the web?? Thx!!

Reply to this Message

NickHK - 20 Jan 2006 08:38 GMT

Raven,
here what I use for Excel files. You need to edit for you text files then
"Open" and process each, or import in to Excel:
<Code>
Response = Excel.Application.GetOpenFilename("HK Spec Files (*.xls), *.xls",
, "Select the Spec Sheets to cost.", , True)

On Error Resume Next
'As we have set MultiSelect=True, this will error if 1 (or more) files were
selected.
If Response <> False Then
'Return to normal error handling
On Error GoTo 0

'As we have set MultiSelect=True, an array of filenames will be returned
even if only 1 file was selected, with LBound=1

FilesSelectedCount = UBound(Response)
'Loop through all selected files
For FileCurrent = 1 To FilesSelectedCount

'Open the required Costs WB
Set WBCosts = Workbooks.Open(Response(FileCurrent), , , ,)
...............Process
Loop
</Code>

> Hello,
>
[quoted text clipped - 6 lines]
> more sophisticated. Do you have any idea?? do you have any resources
> from the web?? Thx!!

Reply to this Message