Thanks foe reply But there is no +ve output.I need visible=False or hide powerpoint application. There is no any option to hide or flas powerpoint application. Please he me

Hi All How can set visible properties false of PowerPoint? I am useing vb 6.0.

Dim pPT As PowerPoint.Application
Dim pPTopen As PowerPoint.Presentation
Dim PptName As String
PptName = "c:\nice.ppt"
Set pPT = New PowerPoint.Application
pPT.Visible = True
Set pPTopen = pPT.Presentations.Open(PptName)

How can i use pPT.Visible = False When i use pPT.Visible = False then i got error.Error is here

Run-time error '-2147188160(80048240)'
Application (Unknown mwmber) : Invalied request.Hiding the application window is not allowed.

Thanks in advance

Hi All How can i create database in ms access?Please help me

odbc not support .xlxs.

No i am not trying to use third party tool.Any way Can you give a one basic idia there is any more way to open excel file accept(office automation). Regard's Rdop

ok i am not going to force to help me.Just i ask a question.If you think to help me then most welcome or if not then also most welcome. I need this type of scenario.So I ask here. Thanks

Hi Forums I am try to open Excel Protected workbook.I know how to open excel through microsoft office automation.

Excel::_ApplicationPtr pApplication;
Excel::_WorkbookPtr pBook;
HRESULT hr;
_variant_t varOption( (long) DISP_E_PARAMNOTFOUND, VT_ERROR);
CoInitializeEx(NULL,COINIT_MULTITHREADED);
hr = pApplication.CreateInstance(__uuidof(Excel::Application));
if (FAILED(hr) )
{
return 0;
}
pBook = pApplication->Workbooks->Open( (_bstr_t)fileNameopen,varOption, varOption, varOption, varOption, varOption, varOption, varOption, varOption, varOption, varOption, varOption, varOption );

Through this code i am eable to open ecxel Unprotected.But i have protected excel file then excel file ask password.So Can i remove password or get password? I cann't use third party tool.Please advice me what i do? if any dll available then please give me link.

Hi All I have a problem to use command "describe tablename" in mfc vc++."Describe tablename" is working well in oracle SQl plus. Here is code

_ConnectionPtr m_pConn;
_RecordsetPtr pRecordset;

m_pConn->Open (_bstr_t ("Provider=OraOLEDB.Oracle;PLSQLRSet=1;Data Source=orcl"),_bstr_t ("system"), _bstr_t ("password"), adModeUnknown);
pCommand->ActiveConnection = m_pConn;
CString fileddetail="describe supplier";
pRecordset=m_pConn->Execute(_bstr_t(fileddetail), 0, adCmdText);

Error is here

OraOLEDB Error: -2147217900 ORA-00900: invalid SQL statement IDispatch error #3092

Connection part is working well. I know some member told me this is a DBA forum question why you post here.But one thing describe or DESC command is working well in oracle.So i think it's a question of MFC VC++. Please help me

Hi All How can i convert data from DVD to CD?Plz give me logic or link. Thanks in Advance

Hi All I am using mysql,::_RecordsetPtr pRecordset and ODBC.I create database through code It's work fine but i want to use refresh after creating database.There is any way to refresh mysql database through code.Plz help me

Thanks for reply.How to do that can you help me.That time my table have my table have column name "Image" data type "Image".Plz help me

Hi All I have a data of MSSQL Image filed.I have insert picture .bmp then i am getting data like this . 0x433A5C446F63756D656E747320616E642053657474696E67735C4D697274756E6A61795C4465736B746F705C756E7469746C65643131312E626D70 Now i want to convert this data into Image. Plz help me

yes you are right.If i am wrong then plz help me how to insert picture. Plz help me

Hi All I am using MySQL.Simply i create a table through this command.

create table Pic(picture blob);
insert pic(picture) values('C:\sample.bmp');
one row affected.
select * from pic;
Picture
BLOB

There is no picture show.How can i show picture. Plz help me

Hi All I have a problem to get rows and column in excel.i use code this for get rows and column.

long row,col;
Excel::Ranger pRange = sheet1->UsedRange;
COleSafeArray sare(pRange->GetValue());
sare.GetUBound(1,&row);
sare.GetUBound(2,&col);

it's working fine for me.But when excel sheet content start from row 2 and column 23(row 2 and column 23 taken as a example),then row and col show "1".But actual range is row=2 and col=23.How can i get the row and col actual range.Plz help me

thanks it's working for me.

See what happen.

_variant_t vtValue;
vtValue = m_pRset->Fields->GetItem("Bianry")->GetValue();
CString b=vtValue;
output is b = "??4"
when i copy the vtValues at the time of debug then i got values
safearray of UI1 = [20](54 '6',53 '5',52 '4',54 '6',52 '4',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

Any more information if you nedd then i will give you.

Plz help me some one

Thanks for responce.I hava a biray type data in _variant_t. _variant_t v1; v1=(54 '6',53 '5',52 '4',54 '6',52 '4',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); Can i convert these values in CString or not. Origal values is"65464". Plz help me

Hi All How can i convert _variant_t to CString?