Only Title

Answer Questions

• YossiEven Excel, Forms, and Charts

  I am pretty much a beginner when it comes to VB. I need help with a project I am working on that has me ready to rip my hair out. Here is the what I need to do: When I open a workbook (excel) I want it to display a form where I can enter in the date and various data. I need that form to add that data that I entered to the worksheet in the coloumn that corrisponds with that particular information. It also needs to copy that row's for ...Show All

• Soheil Saadat Office Accelerator

  I have been asked to implement Office Accelerator for Recruiting - which is like a ton of bricks to me because I am not sure where to start. After combing through MS web sites and stuff it seems to me that the Accelerator is a framework that implements (as far as UI) a Sharepoint or Portal solution. The solution is "not an out of the box" and uses templates, guidelines, fragments... ... from exposed MS code developed in C# using XML ...Show All

• Sam_S Needing extract elements XML to a listcolumn in a Get method(HttpRequest)

  And going on .. Does anyone know how to extract the elements in na XML obtained through a Get method I've been trying to use VBA Excel to connect Web Services. What have I got 'till then It brings me just an XML in a cell. I tried many ways to put this datas in a listcolumns, no success. Any help is appreciate. See my code, Dim oHttp As New WinHttpRequest Dim wks As Worksheet Dim amzURI As String Di ...Show All

• hehemouse Data from serial port

  Hello Friends... Regarding serial port...I have serial device whilch captures data and sends that data to hyperterminal... Here I'm not using hyperterminal to capture data....Now my work is, I have to, have form where the data is coming from the serial device...I need to capture that data...and do some formats or change the way it want to store in database..MeanwhileI want to capture other the data which is coming... But I'm not able to ...Show All

• TechArtists Serial Port communication from Excel 2003

  I am trying to write a simple VBA macro that reads Text data from a Serial port and puts it into an Excel 2003 spread sheet. The solution needs to work from a standard installation of Office 2003. I cannot use add-in modules since the envrioment has been locked by the SysAdmin. Can I make calls to windows API to communicate with the port from Excel Is there some sample VBA code that shows how to do this ...Show All

• Donaghy handling volume control in C#

  Dear sir, I have one trackbar control in my application. i want to adjust the windows voulme control thru trackbar control. give the solution for this query   Hello Brenda, I found a sample code to control the system volume. You can ask our buddy to try it. using System; using System.Runtime.InteropServices; namespace PhidgetTest { public class AudioMixerHelper { publ ...Show All

• Tazzmann Problem with Microsoft CRM 3.0 Outlook Client

  Hi, I’m having a problem with my MSCRM 3.0. When I install the Outlook Desktop Client, on my computer, everytime I that I log on to the CRM application (on my web browser), the SETTINGS folder is no longer available. If I unnistall the Desktop Outlook Client, when I log on to the application trough the web browser, the SETTINGS folder shows up gain. How can I solve this problem I need them both working. Thanks, This ...Show All

• Eric Bickle - BlueRealm Open an excel file

  Hope you will help a beginner .. Here's what I want to do:  In a VBA subroutine, try to open an excel file with a particular name say, P01GAB.xls.  It may not be in the diretory, if not, wait for 10 seconds and try again.  If so, open it and go on to the next thing.  (Eventually, it will be in the directory...)  So, I take it, I need some sort of error trap on the Workbooks.Open command... Thanks much.   ...Show All

• cs96ai What does VMF Team in Microsoft mean???

  Hi, Not sure if this is in the right section but i was just wondering if anyone can tell me what does VMF stand for with regards Microsoft It came up when i was looking at jobs.ie and it said clearical activites of the VMF team in mircosoft..... I would be truely greatful if you could tell me what VMF means.... Thanks Not that this is terribly helpful, but I believe that VMF refers to Vendor Master File and seems to have s ...Show All

• miwillson paste values from multiple sheets to another sheet

  Good day, I am brand new to VBA for Excel.I have a workbook with a bunch of different sheets. I have checkbox buttons on one page that will unhide the desired sheets. What I'm having trouble with is getting the code to work that will allow me to: 1) Search specific sheets (most of them - all but 4) for the last row in columns L through O. 2) paste the values in that range to another sheet. 3) on the destination sheet I'd like the ...Show All

• keysho Installing Business Scorecard Manager 2005 on a SQL Server 2005 instance.

  I'm trying to install BSM 2005 into a Win/2003 Server running SQL Server 2005 (everything) and the Web Service won't install because it reports the following: Failed Microsoft OLE DB Provider for OLAP Service (MSOLAP) 2000 SP4 (8.00.2039) as well, the Alerts won't install because of the message: Failed Microsoft SQL Server 200 Notification Services 2.0 SP1 Engine Components I understood that this version was compatible with SQL 2005. Any idea ho ...Show All

• lvance1611a Adding minimize button to userform in design mode?

  Hey Having terrible trouble trying to get the minimize button displaying on my userform. This should be relatively simple but i can not get it no matter what i try! I got this of Google: Visual Basic forms can be made non-sizable by setting the borderstyle property to 0, 1, 3 or 4. However, that also means that the user cannot minimize the form to the taskbar. I only have the option to choose between 0 & 1. Does anyone know of any w ...Show All

• cccccc Excel, Forms, and Charts

  I am pretty much a beginner when it comes to VB. I need help with a project I am working on that has me ready to rip my hair out. Here is the what I need to do: When I open a workbook (excel) I want it to display a form where I can enter in the date and various data. I need that form to add that data that I entered to the worksheet in the coloumn that corrisponds with that particular information. It also needs to copy that row's for ...Show All

• Drakkaris SQL Server 2005 Resourse Kit exception

  Hi, When i try to view any of the webcasts by clicking "play", i get the following Visual Studio just in time debugger error: An unhandled win32 exception occured in iexplore.exe[4624]. I can also see the following error in the winnt application error log. I am running winxp with sp2. Event Type: Error Event Source: Application Hang Event Category: (101) Event ID: 1002 Date:  25/08/2005 Time:  7:08:50 ...Show All

• Jeddah Disable editing Excel cells

  Hi How to prevent users of a spreadsheet editing the content of the cells Is there anything we can do in VBA thx a lot yuelin there's two parts to protecting the contents of cells. 1. you need to set the locked property of the cells you want to protect to true (its true by default) or false if the cell can be edited. 2. you need to protect the worksheet Worksheets("Sheet1").Rang ...Show All