Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: bunglemutt
- Order by date
-
Export Excel Spread Sheet as a text file using Access VBA
...figured it out! Dim FSO As Scripting.FileSystemObject Dim TS As Scripting.TextStream Dim DObject As MSForms.DataObject Dim SelectedRange As Range ' Set DObject = New MSForms.DataObject ' ActiveWindow.RangeSelection.Copy DObject.GetFromClipboard...- bunglemutt
- Post #8
- Forum: Microsoft: Access Modules (VBA Coding)
-
Export Excel Spread Sheet as a text file using Access VBA
Combo - Thanks for the code snippet - happened to be almost the perfect solution to a current challenge! Was wondering though if it could be modified to process only the selected area of the worksheet in question as opposed to the "UsedRange"? -bunglemutt- bunglemutt
- Post #7
- Forum: Microsoft: Access Modules (VBA Coding)
