Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to export as Text, only the results not the formula
Hi,
I am using this macro to export to a text file but I have vlookups and other formulas that when I export only the formula gets exported, what I need i to export ONLY the results of the query. Public Sub SaveAsTXT() fileSaveName = Application.GetSaveAsFilename( _ FileFilter:="Text Files (*.txt), *.txt") If fileSaveName < False Then MsgBox "Save as " & fileSaveName End If End Sub Thank you, Muaitai |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to export as Text, only the results not the formula
Your code doesn't show how you saved the file.
If fileSaveName < False Then MsgBox "Save as " & fileSaveName activeworkbook.saveas filename:=filesavename, fileformat:=xltext End If You may want to record a macro when you save the file manually so that you get the fileformat that you really want. wrote: Hi, I am using this macro to export to a text file but I have vlookups and other formulas that when I export only the formula gets exported, what I need i to export ONLY the results of the query. Public Sub SaveAsTXT() fileSaveName = Application.GetSaveAsFilename( _ FileFilter:="Text Files (*.txt), *.txt") If fileSaveName < False Then MsgBox "Save as " & fileSaveName End If End Sub Thank you, Muaitai -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro linked to text or an object | Excel Discussion (Misc queries) | |||
Why does formula show rather than results (not in text format) | Excel Worksheet Functions | |||
Help! All results of my formula are the same! | Excel Discussion (Misc queries) | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Macro or Formula to remove Text from Cells | Excel Worksheet Functions |