Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hi ...read test file and copy it in a cell
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hi ...read test file and copy it in a cell
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 -- Gary "Riggi" wrote in message ups.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save copy of file to open as read only | Excel Discussion (Misc queries) | |||
test do not read | Excel Programming | |||
Autoname a save as file from a cell in a read only file | Excel Discussion (Misc queries) | |||
Read through Range and copy Cell data to Array | Excel Programming | |||
hpw do I logic test a cell then copy the row to diff. SS | Excel Worksheet Functions |