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!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export Types

Status
Not open for further replies.
knownote

knownote

Technical User
Feb 29, 2004
98
US
What is updated export types formats for Excel, Word, and text, from Office 97 to current? Here is portion of old code.


With lstResult
.ColumnCount = 4
.ColumnWidths = "0,0,0"
.RowSourceType = "Value List"
.RowSource = "-1,-1,-1,Export Type," _
& "0,0,.xls,Excel 3," _
& "0,6,.xls,Excel 4," _
& "0,5,.xls,Excel 5," _
& "0,5,.xls,Excel 7," _
& "0,8,.xls,Excel 97," _
& "0,2,.wk1,Lotus WK1," _
& "0,3,.wk3,Lotus WK3," _
& "0,7,.wk4,Lotus WK4," _
& "0,4,.wj2,Lotus WJ2 (Japanese)," _
& "1,2,.txt,Delimited Text," _
& "1,8,.html,HTML"
'& "1,3,.txt,Fixed Length Text,"
.Selected(1) = True
End With
 
Status
Not open for further replies.

Similar threads

1DMF
  • Locked
  • Question
OLE Class Types
Replies
0
Views
73
1DMF
1DMF
deek_1
  • Locked
  • Question
create and export a table to excell and automatically save
Replies
2
Views
70
deek_1
deek_1
pinkpoppy
  • Locked
  • Question
Export Subform results to Excel 3
Replies
7
Views
159
SkipVought
S
tmcrouse
  • Locked
  • Question
Export to Excel Error
Replies
0
Views
55
tmcrouse
tmcrouse
cimoli
  • Locked
  • Question
BMP in my report disappears in an RTF export
Replies
2
Views
52
MajP
MajP

Part and Inventory Search

Sponsor

Back
Top