Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default how to create a new text file

HJow do i create a new text file?????

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default how to create a new text file

Little vague, but

File=Save As
and select one of the text options from the file type dropdown.

Need code? Turn on the macro recorder while you do it manually.

--
Regards,
Tom Ogilvy

"rock" wrote in message
ps.com...
HJow do i create a new text file?????



  #3   Report Post  
Posted to microsoft.public.excel.programming
J P J P is offline
external usenet poster
 
Posts: 1
Default how to create a new text file



how to create a new text file dynamicaaly through VB

*** Sent via Developersdex http://www.developersdex.com ***
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default how to create a new text file

answered.

If that isn't what you want, look at this article on low level fileio:

http://tinyurl.com/dghhf


also:
http://msdn.microsoft.com/library/en...ce09072000.asp
Working with Files, Folders and Drives: More VBA Tips and Tricks by David

http://support.microsoft.com/default...b;en-us;151262
Working with Sequential Access Files

http://www.applecore99.com/gen/gen029.asp

--
Regards,
Tom Ogilvy


"J P" wrote in message
...


how to create a new text file dynamicaaly through VB

*** Sent via Developersdex http://www.developersdex.com ***



  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default how to create a new text file

hi thanx for the insight... but my problem was resolved as VB
automatically creates a new file if it previously doesn't exist.......
(using open cmd)



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Code to create dbase file from text file? Hilton Excel Discussion (Misc queries) 0 October 9th 08 10:37 AM
Create text file Rob Excel Discussion (Misc queries) 4 June 1st 06 01:03 AM
How to create a UTF-8 text file from excel VBA mah_kum_70 Excel Discussion (Misc queries) 1 April 29th 06 10:12 PM
Can I use Excel to create this text file? BigIan Excel Worksheet Functions 4 September 15th 05 03:06 PM
How to create a Text File ? RAFAAJ2000[_2_] Excel Programming 2 May 20th 05 06:51 AM


All times are GMT +1. The time now is 01:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"