Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba
hi can anybody tell me how to input data with an input box asking for the
data file and then using the input statement placing the data in the first four column's of each row until the data has ended this would be a great help thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba
What is the layout of the data file? Four values then a LF, comma delimited, space or tab
delimited, or is it just....? Details needed. HTH, Bernie MS Excel MVP "ashw1984" wrote in message ... hi can anybody tell me how to input data with an input box asking for the data file and then using the input statement placing the data in the first four column's of each row until the data has ended this would be a great help thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba
the data file looks like this
10, 87, 98, 98 789, 77, 647, 748 7, 87, 87, 56 and so on "ashw1984" wrote: hi can anybody tell me how to input data with an input box asking for the data file and then using the input statement placing the data in the first four column's of each row until the data has ended this would be a great help thanks the |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba
Sub ImportDataFile()
Dim myFName As Variant Dim myWkSht As Worksheet Set myWkSht = ActiveSheet ChDir "C:\FolderName with data files" myFName = Application.GetOpenFilename(, , "Select the Data File") If myFName = False Then MsgBox "You pressed Cancel" Exit Sub Else Workbooks.OpenText Filename:=myFName, _ StartRow:=1, DataType:=xlDelimited, Comma:=True End If Range("A:D").Copy _ myWkSht.Range("A:D") ActiveWorkbook.Close False End Sub HTH, Bernie MS Excel MVP "ashw1984" wrote in message ... the data file looks like this 10, 87, 98, 98 789, 77, 647, 748 7, 87, 87, 56 and so on "ashw1984" wrote: hi can anybody tell me how to input data with an input box asking for the data file and then using the input statement placing the data in the first four column's of each row until the data has ended this would be a great help thanks the |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|