Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by pyth0n

  1. pyth0n

    Updating Excel charts using VBA

    Thanks - I will take a look and see. I will probably have to change a significant amount of code to do this, but if it works then it will be worth it.
  2. pyth0n

    Updating Excel charts using VBA

    The objective is to update a chart that is associated with the worksheet (workbook1). The data is copied across from a temporary workbook (workbook2) - which itself is written by VBA from Access. The requirement is that only select cells in workbook1 are required to build the chart and the...
  3. pyth0n

    Updating Excel Charts using VBA

    Sorry, as I thought that this was a general MS Office board, I thought that I would start here. Thanks for the tip.
  4. pyth0n

    Updating Excel charts using VBA

    Hi All What's the best way to update an Excel Chart using VBA? At the moment, my script does some work to find the cell where the data is, then edits the Formula for the chart, but after a certain number of iterations this gives me a problem. Like this: For i = 1 To chart_count + 1 Set...
  5. pyth0n

    Updating Excel Charts using VBA

    Hi All What's the best way to update an Excel Chart using VBA? At the moment, my script does some work to find the cell where the data is, then edits the Formula for the chart, but after a certain number of iterations this gives me a problem. Any clues would be greatly received.
  6. pyth0n

    PHP and COM question

    Thanks, it does need to be in native Excel format, but I will look at the PEAR extension. I know that PHP supports COM, but nowhere in the manual does it state if it will run under CGI, it also doesn't state that it runs under CLI, but I know it does because I can do this. What I can't do is...
  7. pyth0n

    PHP and COM question

    This is a bit of a newbie question really. I am trying to use COM to write an Excel spreadsheet from an MSSQL database - limited here by my employers choice of technology. What I want to do is set up a web script that will gather data from the user: dates, preferences etc, then query the...
    • pyth0n
    • Thread
    • Replies: 3
    • Forum: PHP
  8. pyth0n

    Long VBA generated queries

    Lespaul No I haven't tried to use an alias to shorten the SQL, so I will give that a go. Will let you know how I get on. Thanks
  9. pyth0n

    Long VBA generated queries

    I have only posted the small amount of code that causes the problem. All variables are declared to their proper types and the module uses Option Explicit. If you need, I can post the entire code for that sub.
  10. pyth0n

    Long VBA generated queries

    Hi I have a section of VBA code that generates my SQL query, but when I try to use the query it errors. I have seen found that the query is being split into 1024 character blocks by Access and therefore not providing correct syntax for the query to work. Is there anything that I can do to...
  11. pyth0n

    Transfering from Access to MS SQL 2000

    We are moving from MS Access to MS SQL Server 2000. Some of our Access applications use crosstab queries with the following SQL: TRANSFORM Count([CHTest3].FacingsX) AS CountOfFacingsX SELECT [CHTest3].[LM ID Number] FROM [CHTest3] GROUP BY [CHTest3].[LM ID Number] PIVOT [CHTest3].Product; What...
  12. pyth0n

    Scroller not visible in FF or NN, but works in IE?

    Looks as though you are right, I found an article on andrewu.co.uk about ASP.NET and browser sniffing that seems to explain this. Not quite sure as to how to create a work-around but something will crop up. Thanks for your help - greatly appreciated. Clive
  13. pyth0n

    Scroller not visible in FF or NN, but works in IE?

    Thanks for the tips, I tried them, nothing seems to work. What I did find yesterday however, is that when I put in an ASP.NET label on a page, when displayed in IE, the label shows fine and checking the code it displays all the styles as attributes in the span tag as below: <span...
  14. pyth0n

    How to open a word document, write data to it, and save it using Javas

    Javascript doesn't allow reading or writing of files on either server or client machines( abridged quote from page6 'visual quickstart guide: Javascript for the world wide web by T Negrino and D Smith, peachpit press), so I would be surprised if you can do this in Javascript. This is mainly due...
  15. pyth0n

    Scroller not visible in FF or NN, but works in IE?

    I am working on a site where I am using a javascript text scroller that I have borrowed for news items. The site is being written in ASP.NET, linking various user controls to build the page. Testing the site locally, I find that the page displays correctly in IE6, but when tested in NN7.1 or...
See more

Part and Inventory Search

Back
Top