Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello everybody,
Thank you very much for helping us and teaching us so many tricks. I learn vba thanks to you ! My problem : I have got several .csv files with data. When I open one of these files in Excel, the data (that I need) is in row R and column C. Now, knowing R and C, I want to get this specific data for the other .csv files without opening them. Currently, I use this program: Dim strFileToLoad As String Dim aContent() As Variant Dim lngRowNb As Long Dim lngColumnNb As Long Dim lngFa As Long Dim lngRow As Long Dim lngColumn As Long Dim vInputData As Variant lngFa = FreeFile Open strFileToLoad For Input As #lngFa For lngRow = 1 To lngRowNb For lngColumn = 1 To lngColumnNb Input #lngFa, vInputData aContent(lngRow, lngColumn) = vInputData Next lngColumn Next lngRow Close Then, my data is in aContent(R, C). NB: * aContent(R, C) is typically a string or a number with no fix number of characters/figures. * I do not need the full aContent array just aContent(R, C). Is there another way? An easier way? A faster way? Could I use FileSystemObject or VBScript, anywhere? Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
import data from txt file to an existing excel file | Excel Discussion (Misc queries) | |||
Link from Chart File to Data File / Format Problem | Charts and Charting in Excel | |||
To get client data from a saved file back to the master file | Excel Discussion (Misc queries) | |||
How do I reference external data from a file, file name found in . | Excel Discussion (Misc queries) | |||
Get External Data, Import Text File, File name problem | Excel Programming |