Answer Questions

• nhaas add a digital signature to a document without displays the Signatures dialog box?

  Hi, I am trying to do a web application, the idea is: 1 user upload a file (word, powerpoint etc) 2. the server side receive it and sign a signature with the user's information on it. I want to save the digital certificate for each user on the server side so that users do not need to choose which certificate they use. But it seems that the method Signatures .Add will displays the Signatures dialog box and I have to choose a digital signature manually to a document. Is there anyway to add the signature without showing the signatures dialog box (e.g. my certificate is already saved on the server, so I use a method like Singatures.addMycertificate("certificate1") ) Many Thanks Jerry ...Show All

• vkv Difference between Array() and ReDim

  This is probably basic, but I can't figure it out. I have made a property in IDL/C++ which takes a VARIANT as input [ id (310), helpstring ( "Data" )] VARIANT Data; If I assign data from a VBScript like this, it works: arrayout = Array (1.23, 2.34, 12.5) output.Data = arrayout But if I do the more common like this, It does not.This is probably basic, but I can't Dim arrayout() ReDim arrayout(2) ...Put data in... output.Data = arrayout I have read that Array() makes a VARAINT type, which makes sense why it works, but how can I get the ReDim etc. without using Array() function to work -cpede Ok I figured it out. When doing Dim and Redim the variant type is passed ...Show All

• NightCabbage exporting & appending multiple excel files to MS access

  Hi, Does anybody can help me with this one I want to do codes in VBA MS access. I have 3 different excel file (file1.xls,file2.xls,file3.xls). How can I possibly do a multiple excel selection using VBA in MS access example: a = excelfile if a= file1.xls then append to table1 '(table in access) elseif a = file2.xls then append to table1 '(table in access) elseif a = file3.xls then append to table1 '(table in access) endif. I want to remove the header of the excel file before append. Is there a technique to remove how many rows to delete in excel filebefore it wil be append to specific table in Ms access ...Show All

• RajeshPKumar Can't open regedit

  Hai.... Why if I want open regedit (run>regedit), and then show message error like that The application failed to initialize properly (0xc0000005) Please anybody help me... Jebat Thanks First do a search to see if your copy even has it. Click search, type regedit.exe. If it shows up then click run, type in REGEDIT I had this same problem til one day I used caps. So, in the run box just type REGEDIT No period, no exe. Odd, but it worked for me. I was able to find some detailed info about the Windows registry on http://support.microsoft.com/kb/256986/ . If this doesn't help you resolve the issue, please provide as much ...Show All

• Will Merydith Autocomplete entries in inputboxes

  I have some vba code that prompts the user of Excel spreadsheets for various data items needed to complete tasks on the particular spreadsheet. I have not been able to come up with a way of auto-completing the entries once enough characters are entered to make them unique based upon a range of data entries that I already have available. If anyone can help I would appreciate it. see previous answer Chas ...Show All

• Hossam Abdel Wahab Place a CR in normal Text Box via vba

  I am trying to place CRs in a normal Excel text box via vba in an initialization routine.  Here is the code I am using: Option Explicit Dim iLines As Integer Dim iCount As Integer Private Const SCG1 As String = "Line 1" Private Const SCG2 As String = "Line 2" Private Const SCG3 As String = "Line 3" later in code I have the statement: ActiveSheet.DrawingObjects("Text Box 2").Text = SCG1 & Chr(13) & SCG2 & Chr(13) & SCG3 However, the Chr(13) does not appear as a CR, but instead as a square character.  The text does wrap at the margins of the text box.  I have also tried using vbnewline instead of chr(13) with the same results.  How can I get a real CR into the normal Excel text box ...Show All

• JCJCJC VB .NET vs Access (combobox)

  Hi folks, I'm having some difficulties with the combobox control in VB .NET - I can't get it work properly. When I make a combobox in Access I can define it with a option called 'Auto extension'. If you're not familiar with Access it means that as you write letters in the combobox it searches for the closest item that the combobox is filled with. In VB I have tried methods like 'FindString' and 'FindStringExact', but this not match the behavior of the combobox in Access. (For instance the cursor jumps back to the start as you try to write inside the combobox). Anyone who can help :-) Thanks, I was not aware of that - my .NET version is 1.1. Auto complete in .NET ...Show All

• Juliano.net Copy text from textbox to clipboard?

  How to copy just the text from a textbox to the clipboard in VBA (MSO 2000 - Excel). I can copy the entire textbox but I only want the text (not the box). My brain has gone to sleep and I can't do it :( can in VB but do not want to reference VB components. Cheers. NM Emergency over.. created the text as a dataobject and used PutInClipboard. Not enough caffeine yet this morning!! I have the same emergency. Could you post the code snippet you used please. I can't find any reference to " PutInClipboard" Graham, reference to PutInClipboard is here: http://msdn.microsoft.com/archive/default.asp url=/archive/en-us/office97/html/output/F1/D ...Show All

• Ralph1988 vlookup

  Hello can anyone help me with how to write the excel vlookup function in vba the function in excel looks like this VLOOKUP(O2,'[Consolidated list of supplier.xls]Sheet3'!$A$5:$F$218,6,FALSE) how can i get something similar working in a macro. thanks namrata What does the variable MyPath contain If you have a file C:\MyFolder\book1.xls open it's name will be book1.xls. It will not include the path. also, when i replace the code as Application.WorksheetFunction.VLookup(LookupValue, TableArray, RangeLookup, ColIndex) the error changes to "can not find the vlookup function in the worksheetfunction class" but if i write Application.VLookup(LookupValue, TableArray, RangeLookup, ColIndex) ...Show All

• Michal Konecny iexplore.exe - Application Error

  I get the following error message when I close my internet explorer. The instruction at "0x62304320" referenced memory at "0x62304320", The memory could not be "read". Click on OK to terminate that program. Any ideas what is causing this I get the exact same message. Have you found any answers What have you tried to do Tom Hello bennett1016, You are probably experiencing this error due to an ActiveX control on a web page that you are visiting. Essentialy what the message states is that the instruction at the executing address (here its at 0x62304320) tried to read from the same memory block that is currently executi ...Show All

• Gafrage Can i embed MS Access database inside Visio and query it using VBA

  Hi , Iam Deepu. Is it possible to embed an MS access database file in a Visio drawing and when i click on a shape, query and display the information related to the shape from the database in a msgbox or so My requirement is that i do not want an additional file to be carried along with the visio document. That is why i wanted to embed it in the same drawing. Welcoming all your suggestions. Thanks. Deepu Hello Deepu, I doubt very much you will be able to embed a database into a visio document, but that doesn't mean you cannot embed the data. For example you could have a module that contains all the data you want to search as an array or as a collection. Its not a database in the classic ...Show All

• Jos Verlinde Problems displaying VBA Help

  Within all of my Office products (Excel, Access) and VB6, the HELP within VBA is not displaying properly (graphics do not display and I am seeing boxes with a red X) and I am continually getting Internet Explorer Script Errors. I think that I first noticed this occuring just after I installed VB 2005 Express. Has anyone else noticed this problem And more importantly can anyone tell me how to correct this problem Thanks for the suggestion. Re registering the ocx file resolved the problem for me. Within the folder C:\windows\system32 use the CMD window to execute regsvr32 hhctrl.ocx ...Show All

• CurtisDeHaven Executing code off of a cell update

  Is it possible to execute code for the purpose of formatting any time a cell is updated For instance, if I want 8 different formats for a cell given certain conditions Is the only way to do this with a timer then just fire the code ever minute or so "56 colors, eh I assume it's 32 system colors and 24 custom colors " No, these are Excel's own colors, independent of system colors. You can change any of the 56 to any RGB you want, but you can never have more than 56 at one time. Excel 2007 is no longer constrained in this way. Here's some further information about Excel's color palette: http://www.mvps.org/dmcritchie/excel/colors.htm - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solution ...Show All

• Tryin2Bgood worksheet_change and data validation

  Hi there I have an Excel spreadsheet in which one column has data validation set. So the cells in this column have drop-down lists with the pre-set allowed values. Now I want the cell in the neighboring column to be set to some default value when the user selects an item from the drop-down list. This seemed like it would be easy, using the Worksheet_Change event handler. When a cell in the first column is changed, it initiates a function which sets the value in the neighboring column to some default value: Target.Offset(0,1).Value = "default". The problem is that it doesn't work when using the drop-down list. If the user types in the value manually, or if a cell in the first column is deleted, it DOES fil ...Show All

• robinjam Adding data to the same workbook

  I have a macro that copy the content of the current worksheet to another "target" workbook. This works fine: n1 = ActiveWorkbook.Name Selection.Copy Workbooks.Add Template:="MyTemplate.xlt" Workbooks(Workbooks.Count).Activate n2 = ActiveWorkbook.Name ActiveSheet.Paste ' return to the source workbook Workbooks(n1).Activate Now, I would like to modify this macro so that if the user execute it more times from the same workbook, the content of the current sheet must be appended at the end of the same target n2 workbook, "collecting" all the contents. The questions I can't answer are.. 1 - How can I be sure to create the new target workbook only the first time the macro executes 2- How can I append the content at the en ...Show All