Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting Excel Data into Notepad
Dear All, Is it possible to export excel data into Notepad? Or is it possible to open a notepad file inside a macro and paste exce contents into that file? Any help will be appreciated.. Thanks De -- devender_ ----------------------------------------------------------------------- devender_g's Profile: http://www.excelforum.com/member.php...fo&userid=1937 View this thread: http://www.excelforum.com/showthread.php?threadid=34577 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting Excel Data into Notepad
Hi Dev,
One way it can be done, change the save as to suit your needs. Regards Pete Sub TEXT1() Application.DisplayAlerts = False Application.ScreenUpdating = False Sheets("TEXT").Select Sheets("TEXT").Copy ActiveWorkbook.SaveAs Filename:= _ "C:\Documents and Settings\Administrator\Desktop\MYTEXT.txt", FileFormat:= _ xlUnicodeText, CreateBackup:=False ActiveWindow.Close Application.DisplayAlerts = True Application.ScreenUpdating = True End Sub "devender_g" wrote in message ... Dear All, Is it possible to export excel data into Notepad? Or is it possible to open a notepad file inside a macro and paste excel contents into that file? Any help will be appreciated.. Thanks Dev -- devender_g ------------------------------------------------------------------------ devender_g's Profile: http://www.excelforum.com/member.php...o&userid=19379 View this thread: http://www.excelforum.com/showthread...hreadid=345778 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting Excel Data into Notepad
devender,
You can save an Excel worksheet as tab or comma separated that you can open in NotePad. Depending on the layout and requirements, you may get something useful or garbage. NickHK "devender_g" wrote in message ... Dear All, Is it possible to export excel data into Notepad? Or is it possible to open a notepad file inside a macro and paste excel contents into that file? Any help will be appreciated.. Thanks Dev -- devender_g ------------------------------------------------------------------------ devender_g's Profile: http://www.excelforum.com/member.php...o&userid=19379 View this thread: http://www.excelforum.com/showthread...hreadid=345778 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exporting to excel from NotePad | Excel Worksheet Functions | |||
Exporting Excel file into Notepad with column & row lines | Charts and Charting in Excel | |||
RE : upload data from excel to notepad | Excel Worksheet Functions | |||
How do I transfer data from Notepad to Excel? | Excel Discussion (Misc queries) | |||
Exporting to Notepad | Excel Programming |