Answer Questions

• Rabbi Joseph Gordon Check the feasibility to program with the PowerPoint's presenter's view.

  Presenter's view is a good tool in slideshow which enables the presenter to see and control more information during presentation. I would like to check the answers for the following 2 questions 1. Is it possilbe to know whether the Check box for "Show Presenter's View" is checked I could not find the value for this setting in the PowerPoint "Application" Object, e.g. the "SlideShowSettings" object. Does anybody know how to r ...Show All

• Edward Kim MS Office document and image writer print driver & port

  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

• Crend King Vba commands used to connect to sql

  Thats a bit odd... try the Open statement instead. Here's an example: Dim I, FileName For I = 1 To 3 ' Loop 3 times. FileName = "TEST" & I ' Create file name. Open FileName For Output As #I ' Open file. Print #I, "This is a test." ' Write string to file. Next I Close ' Close all 3 open files. The important lines are Open, Print and Close. Look in the help file for the open statement as there are a few ...Show All

• MiguelGandia Hyperlink to a subroutine

  Is it possible to get an hyperlink to run a subroutine I managed to get the hyperlink to go to the subroutine but it doesn't actually run it. It is possible to hyperlink to code from within MS Excel. Try this::: Open up your VBA editor and locate the "Microsoft Excel Objects" folder. Double click the SHEET object where the hyperlink is located. You should see an empty editor area with the words "Option Explicit ...Show All

• Sitanshu Copying rows inside table with vba

  I need to make a macro which let me copy the last 4 rows of a table and clears some cells inside those rows. If you look at this screenshot you see that a part of the table repeats itself. I need to make a button that does this automatic, and a second button that removes it. I allready recorded macro and then just add those by hand, but is there no faster / better way to do this Thanks in advance for replies. Hi Peter The previo ...Show All

• Alok Singh 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

• RajatTandon Problem with XP SP2

  I ran the below program in a machine with XP SP1 and Word 2000 it took only 2 or 3 seconds to insert the bookmarks into the word document. But in a machine with XP SP2 and Word 2000 it took 18 seconds in an average. I am using the similar kind of program to insert the bookmarks into a letter at the runtime. Could please anyone help me out. Private Sub Command1_Click() On Error GoTo err Dim obj As New Word.Application Dim bk As Bookmark obj ...Show All

• JugHead Compatability of VBA 6.3 and Visual Studio/Visual Basic 2005 Express

  To Whom It May Concern: I am about to study Visual Basic for Applications and I entered the article "Visual Basic for Applications 6.3 Features" ( http://msdn.microsoft.com/isv/technology/vba/features/default.aspx ), and apparently VBA 6.3 is on "parity with Visual Basic 6.0". Since I am studying the efficacy and effectiveness of Visual Basic 2005 Express, as well as beginning the exploration of Visual Basic for Applicatio ...Show All

• djMP2006 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

• Mr. Micawber Hyper link Macro

  I am new to this stuff. I want to add hyper links to a series of numbers.eg 100 101 102 103 etc There is a number folder for each hyperlink in excel. So the 100 hpyerlink will open the 100 folder and so on. I can do i Macro to do one folder. How to i get it to do hundreds without repeating myself. Thanks for you help, cheers Hi thanks very much for code, works well. Just one thing, can you ma ...Show All

• Senthamarai A Kannan Need recommendation on Office/VBA/.NET/C# solution (cross-posting from the VSTO Forum)

  ****** The reason that I am cross-posting this from the VSTO froum is to reach the widest expert base. Thanks. ****** We want to move logic currently in Word XP VBA to C# component(s). What the VBA code basically does is calling Web Services that are implemented in Java, and display the returned data in Word documents. Our requirements are: improved performance easiness to install the components on end-user's PC's ability to be shared the ...Show All

• Garg enabling controls at runtime

  i have a userform with two listboxes, and six optionbuttions. the options buttons are split into 3 pairs of two. at the outset only the first pair of option buttons is enabled. the following code tests to see if more than one selection is made in a listbox, and if it is, then enables a relevant pair of option buttons. Private Sub Listbox1_change() 'check to see if there is a multiple selection Dim i As Integer Dim Acount As Integer Acou ...Show All

• Albert.Locke Controlling a Word Mail Merge with Excel

  I'm having trouble running a mail merge in Word using Excel.  I've followed the example in the help file, and have the Workbook opening the appropriate Word Document.  My problem, is I can't control the mail merge from code embedded in the Workbook or in the Document.  The reason I'm using Excel to run the code to open Word, is because I have three different mail merges with three different "Forms" and depending on the ...Show All

• frannack compile vba excel project

  Hi.... Derik do you have any idea about this.. How to compile a VBA Project in excel or how to make VBA Project standalone fsv per our support engineer: A VBA project is integrated with office system. It can not be compiled or be made a stand alone application. -brenda (ISV Buddy Team) ...Show All

• Joe Clifford VB and Excel - Change Event

  I am new user. Any help is appreciated. I have column with drop down selection - If a certain value is chosen, I want to control the format of the next cell. The Worksheet_Change event seems to capture this event if the user selects the change from the drop-down, but not if the user types the value in the cell and presses <enter>. How can I make sure that I capture this in both cases Here's some ...Show All