copy excel data to Notepad

[gmoorthy]

I have about 10 columns and 300 rows which has formulas . I want to get the output of the formulas only into Notepad. Doing a cut paste is causing error to he fact that sometimes i miss data. Is there a easy way to do it . I am not conversant with macro

 

[SkipVought]

Hi,

You want the FORMULAS? Or you want the DATA?

Why not just SaveAs a text file of some sort?

All Notepad is is a text editor. Just open the text file in Notepad.

 

[combo]

You can generate a string and write it to text file.
Generate strString looping through the range, add columns and rows separators according to your needs. Use Formula or FormulaLocal property to get formula text from a given cell.
To write strString string to strPathAndFileName file:
[pre]Dim intFileNum As Integer
intFileNum = FreeFile
' change Output to Append if you want to add string to existing file
Open strPathAndFileName For Output As intFileNum
Print intFileNum, strString
Close intFileNum[/pre]

combo

 

[combo]

Sorry, I've noticed that this is not vba forum. So, no vba solution:
- insert macro sheet to your workbook,
- copy the range you plan to save as formulas and paste to macro sheet,
- copy data from macro sheet and paste to notepad.
Alternatively you can save macro sheet (after step 2) in one of available text formats (incl. csv).

combo