I have an issue in using another piece of vba to make changes to several other excel workbooks vba code. The other vba projects are password protected, I know the password to the vba, but I do not know how to open the other vba sources and pass the password to it. Any Ideas.
Thanks
Thanks,
I have read the post and it does not offer a solution to the issue I am facing though it did give me some ideas. My issue is moving data from com to asp. Which is most likely the same type of issue. So I will pass a string then parse it in the asp page. If anyone knows of a solution to...
I have http friendly on, the exact message I get is
Microsoft VBScript runtime error '800a000d' type mismatch
The code is
Dim oCustomSecurity
Dim strReturn
Set oCustomSecurity CreateObject("CPMCustomSecurity.Class1")
strReturn = oCustomSecurity.fnGetUserGroup("localhost")
if...
I am having an issue where I call a com object that returns an array of values. The function is a variant that returns the error code or array. I can access the isarray, lbound, ubound, and correct vartype (8200). When I attempt to access the actual values I get the error on the page. The code I...
I am having problems setting up an ODBC connection to a DB2 database on a OS/390 installation. I have been able to connect to SQL server, dbase and a text file. I am using the same Driver Manager and the DB2/UDB Driver from Merant. I am getting the following errors, ODBC layer S1000 and native...
I am trying to setup a sun box to connect to a DB2 database that resides on a OS/390 system. I need to use ODBC because of the packaged software. I have been successful in setting up on a NT box but have no Experience with Unix and ODBC. I have access to a DB2 DBA and Unix guy but no neither has...
I have a sun box that is running an application that requires an ODBC connection. I have been able to connect to SQL server, dbase, text file without major issues. But when I try to connect to the DB2 database on a OS/390 I get an error "native code 364". I have DB2 connect on the sun...
I need to monitor the CPU and memory usage on an NT 2-processor box. I need the information written to a file for future use.
Does anyone know of any good tools.
Thanks
I have fixed that issue now it seems that I have an issue with SQL server reading a table with a function based index. I cannot find any reference to this type of issue anywhere.
I am trying to save/run a new view but I am getting an error message that the object does not exist. I am getting the table to appear with all of the columns. In fact I have tried to copy the SQL statement from an existing view and am getting the same error. I can access the data in an existing...
I have gone through Microsoft on this one and after 5 hours on the phone they have concluded the cause is a corruption of the SQL files. A complete uninstall, included any reference in the Reg. Then intall corrected the problem but, if you do this make sure you have backed up everything.
I am running MSQL 7 patch 2. on NT4 patch 6 both on the same server. I am getting the following error message, "ConnectionCheckForData (PeekNamedPipe()). [SQLSTATE 01000] (Message 109) Connection broken. [SQLSTATE 08S01] (Error 4). The step failed." and also getting an alert box...
Here is a samll piece SQL Code that I think is what you are looking for.
TRUNCATE TABLE tmpTable (your table name replaces tmptable)
INSERT INTO tmpTable
SELECT insert your select code
I do not know if this is possible. But for some reason the security file gets corrupted every month or two and restarting the server is not an option. I would like to know if there is a way to restore the settings without restarting the server, possible from a dump of the security file and...
have you heard of a product called fineprint. It can be located at <A HREF="http://www.fineprint.com. " TARGET="_new">www.fineprint.com. </A>; It will allow you to print upto 8 pages on one sheet. If you adjust your page width you will not need to reduce the...
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.