Answer Questions

• _Damir_ MS-Excel 2000 Macro to Get OUT parameter from PL\SQL block

  Hi I am using MS-Excel 2000, to load database details returned from an Oracle 9i PL\SQL block on Excel sheet. Originally the PL\SQL block was used by Oracle Form. Now it is ported to Micorosft Office Excel platform  I have to emulate this similar Oracle PL\SQL block in VBA using ADODB and ODBC driver at my place. DECALRE    temp NUMBER;    A NUMBER;    B VARCHAR2; BEGIN    temp := F1(SYS ...Show All

• Frank Hoefts Current open MS Project saved as XML element

  Hello, I am currently trying to develop a way to save the current Project into an XML DOM object element . This is then sent over a SOAP object to a Webservice I have running. I have an implementation that uses the SaveAs function to save into an XML and passing that directly into the SOAP, but I've run into performance issues and would like to send the file directly (binary) and have the Webservice deal with it then. Heres what I have ...Show All

• Conrad Rowlands Macro in Excel that will look at current worksheet column and select a specific string and...

  I need to create a macro or VBA project in Excel 2003 that will look at the current worksheet column and select a specific alphanumeric or numeric text string that matches this format (V#####, or #####, or V########) than cut and paste just that string to a different empty column to the right on the same row and do this for all rows in the worksheet. Example of current data: The highlighted strings would be cut and placed into a separate colu ...Show All

• g_hall work localy with database

  hello, i have a database on the network and when i run a function with many queries it works really slow. is there a way to copy the database to the local computer, make the queries and continue working on the database on the network other users also work on the network database so it's important that the file stays linked to that DB. please help... refael is there any tutorial on how exactly can i link convert to SQL Serve ...Show All

• GweiloMacau Sql Server 2005 Resource Kit

  Hi all,   how do I view the slides that accompany the webcasts on the DVD. I can hear the audio stream fine but just get 'page not found errors' for the graphics. Hi, If you could provide some additional details about the system that you're running, we'll try to track down what might be causing this issue for you. Thanks, Brenda (ISV Buddy Team) I just found out that all of the Webcasts ...Show All

• MatthewE Report single record in Access 2002

  I'm trying to figure out how to print a single record from a Form in Access 2002. Basically, I would like to be able to click a button on the Form, and it will print out/preview a formatted report for that current record only. I already know how to create the Report, but I just don't know how to link it to the Current Record. Any help would be appreciated. Thanks. I just wrote about this in another post.. ...Show All

• SteveJS Excel edit mode

  How can i detect "edit mode" in excel macros Thank's for idea(s) Hi, The support engineer needs some additional information before he can research this for you. *** After reviewing the post, I understand that you want to write VBA code to detect if an Excel cell is in "edit mode".   We cannot find related property in Excel object model. The Excel object model reference is in the following li ...Show All

• Jonas Røineslien pasting in excel

  I get this error when i paste into excel after typing in some text and selecting some cells to copy and right click to paste in. any ideas System.Runtime.InteropServices.COMException (0x800A03EC): Paste method of Worksheet class failed at Microsoft.VisualBasic.CompilerServices.LateBinding.InternalLateCall(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack, Boolean IgnoreReturn) ...Show All

• Heydar S.O.S Sending Escape Sequence to printer in VB 6

  Dear All, I am having trouble trying to send the escape sequence commands to the card printer in my VB 6 program. Could anyone lend me a helping hand on this. Help is very much appreciated. JT Hi JT, Here's the response from our support engineer: According to your description, I guess you are trying to send the printing command to your printer directly through LPT port in VB6 program; however, this is not the rec ...Show All

• Vitek Karas After refresh, trigger script, then close spreadsheet...how?

  Hi everyone, I have a spreadsheet, after the external data is refreshed then I want this VB script to be triggered that exports the data to another database, then I need to close the spreadsheet. here is the code I have. It works but I would like it to happen after the data is refreshed. Any help would be greatly appreciated....... Public Sub Filltable() Dim db As Database, rs As String, r As Long Dim tdfNew As TableDef Dim wr ...Show All

• gm001 Excel DDE Server

  Hello, I have an excel spreadsheet that does some computations. I would like to keep this running on a server 24 hours a day. I would like this spreadsheet to act like a DDE server and be able to process custom DDE commands -- these DDE commands will be requests for the results of the computations being performed. The applications the will be sending these requests will be running on different machines. How do I go about setting up s ...Show All

• Gus Perez Hding your vba code

  I have also asked this question at http://www.ozgrid.com/forum/showthread.php t=52001 I have created an addin and it will be sent to other people (number unknown). WIll the people who have the addin be able to view my vba code behind it [the addin] Is there any security measures I should take to be on the safe side Thank You Hi, You can password protect your code very easily. In the Project Ex ...Show All

• psygone13 Access 97 does not close after running code

  I have a number of access databases that do not close after I have run code attached to buttons on forms. All the databases read text files and open recordsets to write the data into my tables. I have ensured that I close each recordset and database object, and I set them to equal to nothing at the end of the code. I have tried using the repair option on the database, but I still get the problem. The only way I can close the Access window is ...Show All

• Derek Moffett what SRTP crypto algorithm used?

  When audio/video conferencing between Office Communicator clients, what crypto algorithm is used for the SRTP I logged the SIP INVTE messages in the LCS and took a look at the SDP. I was hoping to see an "a=crypto..." line, but I see only a d-line in the with a key("d=Base64:..."). I believe that a d-line means that the SRTP crypto algorithm is defined elsewhere. Can anyone tell me what that algorithm is AES DES ...Show All

• Samy Khalil Abushanab VBA WORKSHEET

  COMPILE ERROR END IF WITHOUT BLOCK IF Sub EnterDates() Columns().Clear Dim EilDownloadSheet As Worksheet Set EilDownloadSheet = Workbook.Worksheets("Name of worksheet") Dim startDate As String, stopDate As String, startCel As Integer, stopcel As Integer, dateRange As Range On Error Resume Next Do startDate = InputBox("Please enter start Date: format (dd/mm/yy)", "Start Date") If startDate = &q ...Show All