Hi ...read test file and copy it in a cell

[Riggi]

Hi,

Can we copy a number/text from a text file which is in a specific
colomn and row in a text file and then paste it in the excel sheet. I
don't want to use the import command cuz my text file is not delimited.
There are number randomly placed in the text file which I need to copy
and paste it in the excel cells.

I want to place a button on my spreadsheet which would help the user to
locate the data file and then excel would extract data from that sheet
and paste it in the black spaces on the sheet.

Please Help !!!


Thanks,

Riggi

 

[Gary Keramidas]

i use something like this.
datapath stores the path to the file
the text file name is contained in the arr()
the first line of code imports the first line of the text file
the instr function looks for the word balance, check the instr help
then i set the correct worksheet to import the rest of the text file


Open DataPath & arr(z) For Input Access Read As #1
Line Input #1, WholeLine
If InStr(1, WholeLine, "Balance") Then
Set ws = Worksheets("Balance Raw Data")
End If