Answer Questions

• arfried What version of Team System do EmpowerISV members get?

  Current MSDN Universal subscribers get a free upgrade to their choice of one of the Team editions of Visual Studio 2005 when its released.  What about current EmpowerISV members   And what will future members get   I'm planning on joining the program, but I want to be sure I know what my team will be  getting long-term, especially as it relates to Visual Studio Team System. Hi Marty, I know ...Show All

• Pravi4u Lack of mouse scroll wheel support in VBA

  Folks The mouse scroll wheel does not work in VBA.   This has always puzzled me as to why this support does not exist since Office 2000. This problem was originally caused by a MS Mouse driver change that I'm told was communicated long in advance to other MS folks. This problem has existed for several versions of Office.  As far as I'm concerned this should've been fixed in the Office SPs. And yes, I'm quite aware of the workaro ...Show All

• van Kooten VB in Excel Macros versus VB Express

  In working with Excel in Office 2003 I see that macros have the title "Microsoft Visual Basic" Which version of Visual Basic is this Also, is this Visual Basic a fully featured one more so than the Visual Basic Express 2005 edition that is available for download free I am asking because I am finding that the transfer from VBE 2005 to Visual Basic in Excel is not that straightforward. ...Show All

• colecovizion Assign Minimum and maximum values for a MSGraph

    Hi all, I want to assign values for minimum and maximum for all MScharts. For that am using the followind code in a loop. oGraph.Axes(xlValue).MinimumScale = 5000 oGraph.Axes(xlValue).MaximumScale = 15000 Here what is the problem is the values are assiged while execution the above instructions and again reassinged the old values for maximum and minimum. Please let me know this is happening Regards, Abhiram ...Show All

• Alkiris Add code in control image in time of execution

  (First of all they forgive me my English) Good, to all I am grateful for his help I have a routine that adds in a sheet a few Images control If he finds the word Graphis what I want is, that when the user of clic in an image executes Function ImageLoad does there exist any way of including this routine when the control is created or that, on having clicked in an image, obtains the name I have been trying ...Show All

• cartmann Collections of control - evaluating the name of a control that has been "pressed"

  Hi, I have created a form in Excel, upon which is a multipage control, with a set of combo boxes placed on. One combobox is populated by a pre-defined list of text, which upon user selection runs a macro that defines the population of a second combo box.......like a choice - sub-choice set up. The user is able to add and delete pages to their requirements, which also add and deletes the combo boxes on each page, however the user will always be p ...Show All

• Timdog68 User Input on Range Selection

  I am real newbie. I need a script to select a column based on user input. This fails: Dim SCol As String SCol = InputBox("What column are the Scores in ") Rem Columns("D:D").Select Columns ("" & Scol : & Scol "").Select There are various ways, a few here: Dim SCol As String SCol = InputBox("What column are the Scores ...Show All

• Venkataraman Application.FileSearch in Excel 2007

  There is an issue which I am facing after I installed Office 2007. I had written a small VBA which would search for a file and if found will rename the file. I used Application.FileSearch then. Now I am tying to do it again but unfortunately there is an error prompted stating that 'the object does not exist' Set fSearch = Application.FileSearch defPath = "H:\SourceSafe_1_Feb-28_Feb_2006\SecondSet" Set rg = Range("MyFiles&quo ...Show All

• Kobe VBA source code

  Hi all. I need to do my final year project in Excel using VBA. The project is in such a way that i can generate curves using Excel. I have been searching for the samples source code for cosine, sine and FFT source code, but to no avail. Could anyne please advise me on this I am a newbie to VBA, so i'm rather lost now.. Thanks in advance. The problem is not with the "=COS(", but with the"pi*A2". Try: =COS(PI()* ...Show All

• rgoodyear Using user form to create list of files to be open

  Hello, Need your help on a problem I have - it's probably easy, but I don't have much experience with VBA yet and can't get around it. I'm trying to create more user friendly of excel report that uses three different text files as the source of data (file names and location changes - it depends on the user who's running the report). I wanted to use a form to allow users to choose the location of the files before they run the macro. So the who ...Show All

• Grace Cheng How to protect VBA code inside Excel?

  How to protect VBA code inside Excel I looking about it, how to stop view in .xls file VBA code without standart password protection ( demo )... This man done, but only added demo, look here, and if somebody know how done this, please write here... Thank's Forget about it! There is absolutely no reasonnable way to protect the code for real in any .xls 0r .xla file! They can all be cracked, even the one ...Show All

• fristi VB Control Air card sent file to GPRS

  Programming VB control Air card I 'm want sent file picture by Air card with Air card GPRS Module Per our support engineer: I am not sure about what "Air card" you refer to. Usually if it is a third party product and you want to program against it, the third-party product should provide some interface or API for outside program to call. Does it have the method exposed for you to send file or picture You need to ask t ...Show All

• cellist Openening an Excel file from within Project

  Does anyone know how to open and read/write to an Excel file from using Microsoft Project Visual Basic Thanks,   I have a question that relates to this topic.   I currently have a process that creates and inserts into a .xls excel file.   everything works fine, except I don't know how to force a cell format type = text.   everything is of type=general and it wants to do formatting on my data. ex. ...Show All

• shyma MS Office document and image writer print driver

  Besides removing this feature from Office during setup, is there a process to remove this virtual printer from 300 users with roaming profiles on an active directory network We are having an issue with this printer assuming the "default printer" selection for our users. As a work around we have changed their default printer, but after they reboot or log off / on it has defaulted back to the MS Ofc doc and image writer printer. ...Show All

• Studix Accessing a subform control in MS Access

  Hi All, I have a option button in a subform. I am trying to access this option button value from the main form with the following statement: Forms!frmSubForm!OptA.value But this gives an error. Could you please tell me how to access the subform control's value Thanks & Regards, Ashwin. http://support.microsoft.com/ kbid=294212 ...Show All