Recent content by pyth0n

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.

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...

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

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...

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.

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...

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...

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

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.

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...

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...

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

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...

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...

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...