Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
RE : upload data from excel to notepad
Hi
Can anyone tell me what are all the ways to upload data from Excel sheet to notepad Thanks in Advance. Sujatha |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
upload data from excel to notepad
1.. Open the workbook you want to save for use in another program. 2.. On the File menu, click Save As. 3.. In the File name box, type a new name for the workbook. 4.. In the Save as type list, click a file format that you know you can open in the other program. (e.g. For Notepad select any file format having *.txt ) 5.. Click Save. Using Macro try this, Sub Export2Notepad() 'saves active worksheet as text file in current directory '& opens in Notepad. Const txtfilename As String = "Book2.txt" Dim wb As Workbook On Error GoTo xit If ActiveSheet.Type = xlWorksheet Then ActiveSheet.Copy Set wb = ActiveWorkbook Application.DisplayAlerts = False wb.SaveAs Filename:= _ txtfilename, FileFormat:=xlTextMSDOS, _ CreateBackup:=False Application.DisplayAlerts = True wb.Close False Shell "Notepad " & CurDir & "\" & txtfilename, vbNormalFocus Else MsgBox "Please select Worksheet to export to Notepad.", vbCritical, "Export to Notepad" End If Exit Sub xit: MsgBox Err.Description End Sub Regards, Shailesh Shah http://in.geocities.com/shahshaileshs/ (Excel Add-ins Page) If You Can't Excel with Talent, Triumph with Effort. wrote in message ups.com... Hi Can anyone tell me what are all the ways to upload data from Excel sheet to notepad Thanks in Advance. Sujatha |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel data upload to Oracle | Excel Discussion (Misc queries) | |||
Excel data upload to Oracle | Excel Discussion (Misc queries) | |||
Data Upload from Excel to SQL Server | Excel Discussion (Misc queries) | |||
Data Upload from Excel to SQL Server | Excel Worksheet Functions | |||
Data Upload from Excel to SQL Server | Links and Linking in Excel |