Search:

Type: Posts; User: JohnJacobson; Keyword(s):

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Resetting Excel chart's title or axis-label alignment back to centered

    Aloha folks,

    Is it possible to re-set the alignment of an Excel chart's title or axis label back to centered? These items are centered initially -- but once one manually resizes or moves such an...
  2. can I create a jpg or gif from an Excel chart using VBA?

    Aloha all,
    I'm looking for a way to automate a process that is manual and tedious. The process: I select a range of cells surrounding an embedded chart in an Excel spreadsheet, copy, switch to a...
  3. Beautiful, thank you. JohnJ

    Beautiful, thank you.
    JohnJ
  4. Excel 2010 VBA: Cleaning text to convert to a number

    Aloha,
    I have a VBA problem and I hope there's an easy solution. I have a macro I use to clean and format raw data input by real estate agents. One particular field is supposed to be a percentage,...
  5. Replies
    4
    Views
    552

    Righteous awesome Hans! I'm not worthy! Thank...

    Righteous awesome Hans! I'm not worthy! Thank you, exactly what I was looking for and much more. I hope someone is paying you well.

    Mahalo,
    John Jacobson
  6. Replies
    4
    Views
    552

    Thanks Hans, The web query doesn't get me what...

    Thanks Hans,

    The web query doesn't get me what I'm after -- I get the same results as if I selected and copied off of the web page. I'll give you more information in hopes that will help.
    ...
  7. Replies
    4
    Views
    552

    Aloha, I am trying to parse data into an Excel...

    Aloha,
    I am trying to parse data into an Excel spreadsheet from a textfile that has been captured off of a web page. To creat the textfile, I right-click the page and choose 'View Source', and save...
  8. While in design mode, you can double-click the...

    While in design mode, you can double-click the first combo box to create or edit its On Change event procedure. You can write code here to select an item in the second combo box.

    I think a...
  9. Aloha folks, I'm having trouble with two activex...

    Aloha folks,
    I'm having trouble with two activex control combo boxes on a spreadsheet, and I'm stuck on two issues. Please, any suggestions are most appreciated.

    Ideally, the user selects an...
  10. Re: setting gradient stops in a chart (2007)

    YESSS! Thank you Rory.

    So what is the secret to finding the path to such an item as a 'GradientStop'? I flopped around for three hours in the Excel Object Model Reference unsuccessfully. I...
  11. setting gradient stops in a chart (2007)

    Aloha folks,

    I'm trying to make the shading of the plot area change based on the data being plotted. I have the plot area set to a gradient fill with 4 stops. I want to change the positions of...
  12. Re: Can I supress the Compatibility Checker? (Excel 2007)

    Thanks Jerry.

    I did use it in my code, and learned something else, which now makes perfect sense:

    A new workbook created in Excel 2007 has to be saved as an Excel 2003 file before one can...
  13. Can I supress the Compatibility Checker? (Excel 2007)

    Hans, I read your response to Post # 712457 and I'm floored. There's no way to suppress the Compatibility Checker!?

    I'm crafting a simple macro to create several Excel 2003 files from one...
  14. Re: resetting TextToColumns delimiters (Excel 2003, 2007)

    Thanks Hans, good info.
  15. resetting TextToColumns delimiters (Excel 2003, 2007)

    Aloha,

    When I use Excel's Text To Columns parsing function, whether manually or via code with TextToColumns, the delimiters I choose have an effect on any subsequent opening of textfiles and...
  16. Replies
    5
    Views
    604

    Re: Excel Data Manipulation (Excel 2003)

    Aloha,

    This looked really similar to a macro I already have so I modified it for you.Try the following code:

    Sub GroupAccts()
    ' Lists all ACCCOUNTs grouped by PRODUCT and REPORTING LINE.
    '...
  17. Re: Making macro toolbars available in 2007 (Excel 2007)

    Thanks Hans and Rudi!
    These last 2 links are more than enough to keep me busy for now. What a grand adventure! I'm sure my needs will change as I become more familiar with the new locations of...
  18. Re: Making macro toolbars available in 2007 (Excel 2007)

    Thanks Hans,
    I started down that road, but I have at least 20 macros that I would add right away, which makes for a rather cluttered Quick Access toolbar. Additionally I had a couple of custom...
  19. Making macro toolbars available in 2007 (Excel 2007)

    Eeek!
    Just converted to Office 2007 and my custom toolbars and custom menu items (which I had come to rely on for speed and efficiency in Excel 2003) don't work, and don't appear to be editable! Is...
  20. Replies
    2
    Views
    890

    Re: pivotcache fun (Excel 2003)

    Well that stinks. Thanks for the feedback Rory.
    Aloha,
    John Jacobson
  21. Replies
    2
    Views
    890

    pivotcache fun (Excel 2003)

    Aloha all,
    I have this Excel pivot table that gets its data from an OLAP cube built by SQL Server 2005's Analysis Services. I am considering writing some code to grab and summarize the cube data...
  22. Replies
    6
    Views
    533

    Re: Manipulate Text (Excel 2003)

    The custom function and worksheet formula provided by Jerry only work when there is no other dash preceding the phone number. If this case is a possibility, you can use the SEARCH() worksheet...
  23. Re: Can a user suspend and resume macro execution? (2003 SP2)

    Thanks Hans,
    For the prompt feedback.
    John Jacobson
  24. Can a user suspend and resume macro execution? (2003 SP2)

    Aloha,
    I have a data cleaning routine that requires some manual work at two points midway in the procedure. Is it possible to suspend execution of a macro so that the user can do some manual...
  25. Re: change the range of a chart series' Values or XVal (2003 SP2)

    Thank you Hans, string manipulation it is then. Thank God my data in this case is in rows, not columns.
    Aloha,
    JohnJ
Results 1 to 25 of 63
Page 1 of 3 1 2 3