ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   SOS-How to pass array parameter to Workbooks.OpenText(...) in VC++ (https://www.excelbanter.com/excel-programming/341199-sos-how-pass-array-parameter-workbooks-opentext-vc.html)

Lily

SOS-How to pass array parameter to Workbooks.OpenText(...) in VC++
 
Hi,

I am using Excel Automation from VC++ MFC code, I need to read .txt file and
display it in Excel, I have some data like 1234E2, I wish to to display it as
1234E2, but currently it is displayed as 123400. I need to disable this
scientific convertion. I studied the OpenText(...) function, and find that we
can specify the FieldInfo to do correct read, this parameter is two
dimensional array, I tried all means whatever I can, still can not correctly
pass it in for FieldInfo. anybody can help?

thks a lot in advance.

Lily,



Dave Peterson

SOS-How to pass array parameter to Workbooks.OpenText(...) in VC++
 
You didn't like yesterday's suggestion?

Lily wrote:

Hi,

I am using Excel Automation from VC++ MFC code, I need to read .txt file and
display it in Excel, I have some data like 1234E2, I wish to to display it as
1234E2, but currently it is displayed as 123400. I need to disable this
scientific convertion. I studied the OpenText(...) function, and find that we
can specify the FieldInfo to do correct read, this parameter is two
dimensional array, I tried all means whatever I can, still can not correctly
pass it in for FieldInfo. anybody can help?

thks a lot in advance.

Lily,


--

Dave Peterson


All times are GMT +1. The time now is 01:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com