Hai to all,
When u convert the Text Data to Excel data..Text Import Wizard will guide u thru the process
of converting the Text Data to Excel Data..
I DON'T WANT THE TEXT IMPORT WIZARD TO CONVERT THE TEXT DATA TO EXCEL DATA.,..Can we do
this in Programming?
* Is there any OLE functions or Excel functions with which we can convert the Text data
to Excel Data
If anybody knows the solution ..pls mail to me.. It's urgent..
advance thanks to u..
ThangarajText Import Wizard
Serving the Quantitative Finance Community
-
- PinballWizard
- Posts: 4
- Joined:
VBA-Excel Doubt
I'm not sure what you are after,but, have you played around with the PasteSpecial method of the Range object ?
How are you selecting your text, and how exactly do you want it to appear in Excel ?
B.
How are you selecting your text, and how exactly do you want it to appear in Excel ?
B.
VBA-Excel Doubt
Not quite sure what u need
BUT
I'll give you 2p worth:
If you are talking about importing data from a text file into Excel
and don't want the interactive Text Import Wizard (or the File-Open - txt file method)
THEN
I suggest you try using the QueryTable object connectted to the file with the relevant delimiting specifications.
No (little) screen flicker and an isntantaneous result.
If this is relevant eMail me I can send you sample code.
BUT
I'll give you 2p worth:
If you are talking about importing data from a text file into Excel
and don't want the interactive Text Import Wizard (or the File-Open - txt file method)
THEN
I suggest you try using the QueryTable object connectted to the file with the relevant delimiting specifications.
No (little) screen flicker and an isntantaneous result.
If this is relevant eMail me I can send you sample code.