Importing files in Excel?

Question

Can you import more than one .ASCII file at a time in Microsoft Excel? Or only one at a time?

Thanks,

Answer 1

Of course you can!
You just need to use the following VBA code:

' //
' // Start Code
' //
Sub rocknrollmaiden()
Dim szFile As Variant

szFile = Application.GetOpenFilename _
(FileFilter:="All files (*.*), *.*", _
Title:="Open Files", MultiSelect:=True)

If IsArray(szFile) = True Then
For File_Counter = 1 To UBound(szFile)
Application.Workbooks.Open szFile(File_Counter)
Next File_Counter
End If
End Sub
' //
' // End Code
' //

Voila!
Where's my 10 points?
:)

Answer 2

Only one at a time.

Answer 3

on condition which you have get admission to open in any respect circumstances, and function somebody a minimum of click one button. or you will could write a software to do it and function homestead windows run this technique on a daily basis. In a module, positioned DoCmd.TransferSpreadsheet acImport, 8, "tablename", "C:workbook.xls", real, "sheetname!" replace your xls report call, the sheet call (go away the ! after it) and the call of the table to import it to. (you could positioned greater desirable than a million line in a module in case you have greater desirable than a million sheet, or greater desirable than a million workbook, to import.) click the final-pointing arrow icon, or press F5, to run. to date as writing a software to do it, you're on your very own - there is not any longer sufficient room right here for the code for a whole software (and that i earn my living writing issues like that).

Answer 4

only one at a time mate.