Hi;
I changed the project for excel VS 2003 to VS 2005; when I try open Excel file doesn't execute dll; appear: "the message The assembly * could not be found at or could not be loaded"
I install Service pack 1 to Office 2003, Office 2003 PIA, install for office 2003 KB907417, but nothing...
Hi;
Please; when I have the fact table less than 1'000.000 records the process take time 6 min. but when the fact table pass this amount the process take time 45 min.
Analysis services 2000, enterprise edition, SP3A
Windows 2003
Before; I didn't have problem in windows 2000.
What happend...
Hi, again...
Try, with below code, but not work with conditional format, only common format...
For Each singleCell In Range("Data").Cells
InteriorColor = singleCell.Interior.Color
MsgBox Str(InteriorColor)
Next
if you will have another idea...
Bye, bye and thanks...
Hi.
I have a excel workbook that contain cells with many different conditional format, and I have a macro that scroll all cells but I can not recognize individual status cell (ColorIndex: Red or Green) and take different walk.
Thanks...
You have two options...
1.- creating the string correctly:
CString sSQL;
sSQL.Format("INSERT INTO other_info(card_id) VALUES ('%s')", m_editbox1);
recordset->Open(sSQL);
2.- use parameter pointer and your methods CreateParameters and Append...
Good luck...
I have a app when the user edits a node of tree view it should send a message to indicate that node change... I have implemented the "ON_NOTIFY_REFLECT(TVN_SELCHANGED, OnSelchanged)" How do I active this event?. I try with "SendNotifyMessage(TVN_SELCHANGED, 0, 0)" but this...
Anyone know user network assigns permission to do backup network drive... Permissions assign full control to disk to: Administrators group but isn't permit... when assign full control to everyone... work! what is the user?
thanks...
I have a big problem...
The disk crash and I have only the backup of the disk that contains data directory; but I don't have .CAB of the cubes.
What do I do???
please help!!... Thanks
Hi;
when you use sp_executesql with parameters is not equal to concatenate string. If you try the statements below verify this. The advantage is that sp_executesql more efficient because it generates execution plans that are more likely to be reused by SQL Server.
declare @list varchar(50)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.