Posts by A9192Shark

  • Changing the text in a shape textbox

    Hello,


    I have a text box drawn on a chart and wish to change the text using code.


    I recorded the code below
    [Code[ ActiveChart.Shapes("Text Box 1").Select
    Selection.Characters.Text = "fgasdf"
    [/code]


    First try was to delete the Select and selection keywors. That failed as the characters are not a property of the shape.


    A few other things tried but I can not find the property of the shape/textbox that I need to change.


    Any ideas?


    Thanks,


    Alan.

  • combine a stacked and a normal histogram

    Re: combine a stacked and a normal histogram


    Solution!


    Plot the first series on the primary x-axis and the others on the secondary x-axis. Use a dummy series on the primary axis to force series 1 to plot on the left of each y axis point.


    Play around with the gap width of the series plotted on each axis and it looks ok!


    Thanks for anyone who started to think about it.


    A.

  • combine a stacked and a normal histogram

    Hello,


    I have three series that I would like to plot on the same chart.


    I would like to plot series 1 as a single column for each value.


    I would then like to plot series 2 with series 3 stacked on top alongside series 1.


    Is this possible?


    Thanks,


    Alan.

  • Interactive worksheet in powerpoint

    Hello,


    I know that I can place a text box in a powerpoint presentation and the user can enter data. I could link this object to an embeded worksheet. However there are 20 or more input cells.


    I could open Excel from powerpoint, but then I have to format the sheet to look like the presentation (I use the same model for many clients).


    I really would like to be able to have an interactive worksheet that the presenter can change a number and the graph etc would change. I am happy to write VBA to refresh/recalc the object, although would prefer the full functionality of the Excel worksheet in the presentation.


    Is this possible?


    Thanks,


    Alan.

  • Pasting data - some appears in date format?

    Re: Pasting data - some appears in date format?


    Norie,


    When I firt loaded the page in teh query designer it too a while but worked. Then when I clicked refresh on the query it simply hung for ages.


    When I have loaded the pages in IE it also struggled and I had some silly adverts . I do not know if these caused a problem for Excel.


    No need to worry abot it though, I have never had this problem with queries I have wanted to do.


    Cheers,


    Alan.

  • Pasting data - some appears in date format?

    Re: Pasting data - some appears in date format?


    Doug,


    I would love a golf lesson. I hardly get toplay anymore. The only problem is that your website does not say where in Australia you are (and that is only clear from the first paragraph on the About page) so booking my ticket from the UK could be a problem. The other one is my wife might not agree... :)


    A.

  • Pasting data - some appears in date format?

    Re: Pasting data - some appears in date format?


    Dougk,


    Open a new workbook.
    Select all cells and format them as text


    Open Word
    Highlight the table and copy it from the web.
    Paste it into word


    Highlight the data in word
    Copy


    Pastevalues into Excel


    A real pain but it works.


    I suggest that you then insert a couple of columns and split the scores into three columns using the Text to columns on the Data menu.


    Good luck,


    Alan.

  • Interactive calculation code

    Re: Interactive calculation code


    I think we need to take a step back.


    I have worked out that the headings are in Portugese and what most of them mean.


    The reason the file was so large is that you have formatting on so many cells on the Banco sheet.


    We need to sort the orders on the due date and process them in that order. We then need to allocate each order to a machine. You calculate the due date but I can not follow how you have done it.


    I presume that the Data entrega (Delivery date) is the date you receive something.


    You are presumably given a due date (although you appear to calculate it).


    You want to schedule all of your items such that they get anfactured by the due date, highlighting any that are overdue.


    Am I right so far?


    A.

  • Pasting data - some appears in date format?

    Re: Pasting data - some appears in date format?


    OK, what has happened is Excel has still treated it as a date and then shown you the serial number!


    We can keep trying to do this but it will be a recurring problem.


    Can you give me the URL that you are using to get the data?


    What do you want to do with the data?


    A.

  • Interactive calculation code

    Re: Interactive calculation code


    I see a few possible solutions, that will depend on the actual data. One uses formulae and teh other VBA.


    Can you post (as Dave suggested) a small file showing a sample of your initial data and perhaps the results assuming only 5 machines?


    Also, to ensure that all machines get similar usage it is common to not allocate the first machine that is available (meaning that the lower the machine number the more likely it is to be used) but the next machine that is available (meaning that all machines will have similar usage). Is this of concern?


    A.

  • Pasting data - some appears in date format?

    Re: Pasting data - some appears in date format?


    The problem is that Excel is being 'clever' and recognising the dates.


    Try formatting the destination cells as text first and then pasting values.


    HTH,


    Alan.
    Are the Aussie Football results with ground, attendance, date?
    A.

  • Standard Access Procedure With VBA

    Re: Standard Access Procedure With VBA


    Are you trying to open a form with a filter or save a form with the filter?


    Your original post appears to say that you want to close form A and open form B using the filter from form A.


    If this is so three things spring to mind in order of (personal) preference
    1. Do you need two separate forms or could they be placed as sub forms on a single form. When you click on a record in form A the records in Form B are automatically filtered.


    2. If you open the form using DoCmd.OpenForm then you can specify the records to view using the filter or where parameters.


    3. You can use the Openargs property to filter a form as it opens using an event procedure.


    As an aside, if you are actually opening and closing the same forms all of the time it may be quicker to hide and show the forms. This has some drawbacks, but it is often quicker.


    HTH,


    Alan.

  • Array Function to Compute Spherical Units to Cartesian

    Re: Array Function to Compute Spherical Units to Cartesian


    Sounds like homework.


    You will need a spreadsheet that has a set of sperical co-ordinates, say 10 to start with. The question does not state where the answers should be put so you will need to state your assumption about that (new sheet? same sheet a few columns over? same sheet but below the data?)


    Perhaps you could post that with three areas identified.
    1. The source data
    2. The area to put the results
    3. The expected answers calculated using normal excel functions


    How much VBA do you know?


    Your subject says Array formula, but the question makes no mention of an array formula. Does it need to be entered as an array formula?


    A.