in
All Tags » VBA » line (RSS)

Browse by Tags

  • Excel VBA Trying to draw a straight line between 2 points in a series from vba

    I want to draw a line between 2 points on a chart series (line chart) that have been selected by the user with mouse clicks. If I create a macro and manually draw the line, I get the correct x/y coordinates. In vba, on a mouse up function, I get the x/y coordinates but they are something called "client...
    Posted to Excel (Forum) by microsoft on 04-13-2010

  • Change the line width of a line in Word

    I am using the next code to itentify a line on a template and change the height: I can set the height, top and left properties but not the width. What hapeens when i set the width is that the line becomes diagonal. First its a line like | but after setting the width it looks like \ How is this possible...
    Posted to Word (Forum) by microsoft on 03-17-2010

  • Command Line Arguments for VBA in Excel

    I want to do this to get the command line arguments that I used to run my excel document but it is not working. Command = "" instead of my arguments. If I can't do this is there another way to get command line arguments in excel vba? Private Sub Workbook_Open() Dim argv() As String Dim...
    Posted to Excel (Forum) by microsoft on 02-26-2010

  • Word VBA: How to get an ABSOLUTE line number?

    I'd like to get the ABSOLUTE line number (which means, count from the beginning of document, not the beginning of that page) of the first character of a selection (better yet, of any range). Any way to do this? Some related codes I know of are : [A] aRange.Information(wdFirstCharacterLineNumber)...
    Posted to Microsoft Office (Forum) by microsoft on 12-05-2009

  • change color of line on chart VBA

    How do I change the color of a line on a chart with VBA?
    Posted to Excel (Forum) by microsoft on 08-14-2009

  • Line Numbers in VBA Code?

    I have a rather large VBA subroutine I wrote. I am trying to split it up, but until then, there are a few areas that might encounter an error. I'd like to know whereabouts in the module the error occurred. Mind you, this is distributed as an MDE, so the user cannot get to the code, even during an...
    Posted to Access (Forum) by microsoft on 07-14-2009

  • VBA: line input

    i'm trying to put each line in a file into a variable but it's not parsing the file up correctly. i have... Dim LineData As String FileNumber = FreeFile Open FilePath1 For Input As FileNumber Do Until EOF(FileNumber) Line Input #FileNumber, LineData Stop Loop each time i stop it to check what...
    Posted to Microsoft Office (Forum) by microsoft on 07-11-2009

  • Problem: Using VBA to insert line numbers in text

    Hello there. I have a long text and I want to add in front of every line it's number, for instance: 001: France, which commands the small current peacekeeping force in Lebanon, known as Unifil, 002: will lead the expanded version until February, Mr. Annan said. Italy will then take over the 003:...
    Posted to Word (Forum) by microsoft on 06-10-2009

  • Problem: VBA - How do I get the line number for the current page

    Hi, I need to get the current line number for a document, like the Ln XX number that is available in the status bar. This is so that i can insert a page break if a section of text is going to be spread over two pages. How can I do this? Regards Chris
    Posted to Word (Forum) by microsoft on 06-05-2009

  • Problem: VBA Macro for lines with no text

    I want to create a macro that recognises a blank line in an MS Word document. And I want it to take account of the fact that there can be lots of white space and still be a blank line. At the moment, my macro does this: dim para as paragraphs dim rng as range dim blnBlankLine as boolean 'this should...
    Posted to Word (Forum) by microsoft on 05-30-2009
Page 1 of 2 (12 items) 1 2 Next >