Answer Questions

• acal675177 Closeing shared files

  Hello Yesterday I stack with a problem of opening and writing some information to  file in AD domainm which was open by one user. I noticed that when someone open a file, then I can not do anything with it untill the time when he will close the file. My question is : Is it possible to close such session to the file for this user thru the vb.net or cscript code My program need to get full acceces to some files and I need to be sure that all ...Show All

• parlance Future of VBA (and VBScript)?

  We developped a number of tools in VBA or VBScript, sometimes using COM objects, and the large compatibility of VB, VBA and VBScript was certainly nice. We would no mind moving to .NET (the framework API being quite interesting), but it is not clear what is going to be the future for VBA and VBScript. Can we expect a VB.NET"A" and a VB.NET"Script" It looks as if this is an atempt but does not look promissing ...Show All

• *Liu* assigning event handler subs to a dynamically created control?possible? how?

  Hi, I want to have some controls existing in any newly created workbooks/worksheets. So I create a combobox when it is necessary with OLEObjects.Add method. But then I want to catch events happening on this control so the Private Sub ComboBox1_Change() procedure should be created for it from a program. Is it possible Strange to me, that I cannot assign an event handler even through the user interface, while it is possible ...Show All

• jayk vba error message

  Hello to everybody. I am new on VBA programming and I'm facing an error that is making me crazy. I create a code in Excel using the VB editor and save it, no further problems. When I close it down and open up the workbook, this error message comes up: "A document with the name blablabla.xls is already opened. You cannot open two documents with the same name, even if the documents are in different folders. To open the second document, either ...Show All

• Grant Fritchey Editeurs de Logiciels Français, ce message s'adresse à vous...

  Started by Christophe Lauer [MS] at 02-19-2005 4:25 AM. Topic has 0 replies. 02-19-2005, 4:25 AM Christophe Lauer [MS] Joined on 02-17-2005 Posts 1 Editeurs de Logiciels Francais, ce message s'adresse a vous... Bonjour, Vous etes Editeur de Logiciels sur plate-forme Microsoft en France, voici une liste de liens et de ressources que vous allez pouvoir utiliser. Vous souhaitez etablir ou ...Show All

• Reg2880 Newbie - Sending mail via Excel

  Hello everyone, Here's my problem : I'm trying to send a email via VBA in Excel using this code :     Set ol = CreateObject("outlook.application")     Set myItem = ol.CreateItem(olMailItem)     Set myAttachments = myItem.Attachments     myAttachments.Add "c:\SDE.xls"          With myItem        .Subject = "SDE"    ...Show All

• Luis Soto Changing Outlook email settings with VBE

  I would like to change the "Leave a copy of messages on the server " option in Outlook with Visual Basic Express. The Visual Basic Express code would change that setting for all or some of the email accounts. Ideally, it should be possible to do it on computers on a network. Does anyone know how this can be done Thanks, Antonio Hi Brenda, Thank you for your detailed reply. ...Show All

• Alaska Excel edit mode

  How can i detect "edit mode" in excel macros Thank's for idea(s) Hi, The reason I'm doing this, is to enable user to do in place editing of content, not the formula. Displaying message box or form dialog is not "the Excel way" of doing things, or let's put it this way: it would be much easier for end user to do it directly in Excel cell instead of in a some dialog, especially when there are a lot of cells. Im ...Show All

• The PocketTV Team XML view in IE

  Hi All, I am new to this forum and I am not sure if the following question has already been raised earlier. I have an xml file as follows: < xml version="1.0" encoding="UTF-8" > < xml:stylesheet href="styles.xsl" type="text/xsl" > <collection> <book> <index>1</index> <author year= "1990" > John Doe </author> <title> JavaScript &l ...Show All

• shindesam ScrollBars for Userforms

  hi, I want to enable scrollbars for the userforms created during design time. I am adding certain no of controls based on an input during runtime to the userform which was created during design time. I want to have the size of the userform fixed and if the controls are more then enable the scrollbars so that we can scroll and view the controls during runtime. Is there any way to do this regards, sk80. ...Show All

• waldi_the_dog Problem on registration with Live Communication Server

  I just set up the trial software of Live Communication Server 2005 stantard edition, following the deployment guide. I also downloaded Windows messenger 5.1 on other two PCs as clients to the LCS and created the two users in LCS. However, when the two windows messengers sent REGISTER to LCS, "401 unauthorized" message were returned. I checked the server, the two user accounts were configured and have LCS enabled. I am sure the user ...Show All

• Feras11 macro that hides rows - excel

  hi, i was wondering if there was a way to write a macro that will automatically hide a row based on a value in a cell in excel say, if the sum of a selection of cells = 0, i want to hide the row all together. is there a way to do that thanks. anthony I got it! Here's the code that makes it all work: Sub Update() Dim lngLastRow, lngRow As Long With ActiveSheet lngLastRow = Cells.SpecialCells(xlCellTypeLastCell) ...Show All

• PatrickL Access/VBA Duplication of a database object

  I have a problem with a database that I am trying to create. The Database has been created in Access 2000 file format. I have created a standard module which contains a recordset object from another database which I wish to update from the current one. As I do not want to amend the recordset directly but only after I have checked that I want the amendments to go ahead, I have copied the recordset to a temporary table within the curren ...Show All

• D.Neptune What kind of info do you want to see on the MSDN ISV Community Center site?

  If you have a minute or two to let us know what kind of ISV-specific content you'd like to see on the ISV Community Center it would really help us tailor the site to your needs as an ISV. Just a few questions to get you started... > Is the focus of the current content too broad, too narrow, or generally on target > What topics would you like to see more info on in relation to your business and/or software developme ...Show All

• Douglas04 VBA and Excel Deleting Worksheets without user interaction

  Hi I have a VBA application in Excel where I want to delete quite a large number of worksheets in a workbook, and I want to do this without user interaction. Unfortunately the modal dialog pops up each time and waits until I click OK. I have looked but can't find a way of preventing the modal dialog from appearing. Does anybody have any ideas on how to solve this Many thanks in advance This exam ...Show All