3 problems

23 Mar 2006 2:08 PM

Dogbert

i am using VB6

1. I have a long job to run, I want show the current status using text on a
dialog/popup/windows
which control(s) should i use?

2.how to convert unicode to ascii using VB6?

3. I use excel driver to retrieve the data (not allowed to use excel object
libaray), the worksheet name seems cannot contain any space(ie. "worksheetname"
but not "worksheet name") . Is this can be solved ?

    cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties='Excel
8.0;HDR=Yes;IMEX=1';Data Source=........"

    cn.CursorLocation = adUseClient

sSQL = "select * from ['worksheetname$'A1:B10]"

    rs.Open sSQL, cn

THANKS ALL~~~

23 Mar 2006 5:14 PM

Mike D Sutton

> 1. I have a long job to run, I want show the current status using text on
> a dialog/popup/windows
> which control(s) should i use?

A progressbar would make the most sense in this situation I would have
thought.

> 2.how to convert unicode to ascii using VB6?

Have a look at the StrConv() function, using the vbFromUnicode flag.

> 3. I use excel driver to retrieve the data (not allowed to use excel
> object libaray), the worksheet name seems cannot contain any space(ie.
> "worksheetname" but not "worksheet name") . Is this can be solved ?

Perhaps follow this one up on an Excel group?
Hope this helps,

Mike

- Microsoft Visual Basic MVP -
E-Mail: ED***@mvps.org
WWW: Http://EDais.mvps.org/

25 Mar 2006 4:35 PM

Dogbert

> 1. I have a long job to run, I want show the current status using text on
>> a dialog/popup/windows
>> which control(s) should i use?
>
> A progressbar would make the most sense in this situation I would have
> thought.
>

Progress bar seems not a text specific control.....
Actually i want an effect like a changing text message on something like
msgbox.....

>> 2.how to convert unicode to ascii using VB6?
>
> Have a look at the StrConv() function, using the vbFromUnicode flag.

Seems have problems on some platform if don't use localeID
i try it later

>
>> 3. I use excel driver to retrieve the data (not allowed to use excel object
>> libaray), the worksheet name seems cannot contain any space(ie.
>> "worksheetname" but not "worksheet name") . Is this can be solved ?
>
> Perhaps follow this one up on an Excel group?

   just found the solution, is "select * from [work sheet name$A1:B20]"
   not "select * from ['work sheet name$'A1:B20]",
   misleaded by m$ table name string return......

> Hope this helps,
>
> Mike
>

THANKS~~~~

Show quoteHide quote

>
> - Microsoft Visual Basic MVP -
> E-Mail: ED***@mvps.org
> WWW: Http://EDais.mvps.org/
>