Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
now I open the file and copy it to another file line by line and
change lines need to be changed. Is there an easy way? It looks like an INI file but not really is a INI file. Thank you, |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
It depends on the format that you require and what Excel can give you.
You could open and edit in Excel then save as text. If it has an INI file structure you can use the API calls like GetPrivateProfileString: http://vbnet.mvps.org/code/file/pprofilebasic.htm Otherwise you would need to read the whole file into a string/array. Make the changes. Write the whole file to a new file. Kill the old. NickHK "muster" wrote in message oups.com... now I open the file and copy it to another file line by line and change lines need to be changed. Is there an easy way? It looks like an INI file but not really is a INI file. Thank you, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to create a hyperlink to open a file with part of the name | Excel Worksheet Functions | |||
modify how files are displyed in the "file open" window | Excel Discussion (Misc queries) | |||
Loop through, open, and modify all workbooks in file | Excel Programming | |||
Modify text file before import to Excel | Excel Programming | |||
Using a variable name as part of a file pathname to open many files | Excel Programming |