Recent content by mep1

Hello, I am trying to update a chart range programmatically. The code I am using is given below. The error I receive states that I am unable to set the Xvalues this way. Set dateRangeStart = Worksheets("HISTORY").Range("A4") ActiveChart.SeriesCollection(1).XValues =...

Hello, I am having trouble running some macros I created in Excel. When I try to run the macros I recieve a "Object library invalid or contains references to object definitions that could not be found." I believe I have added the appropriate libraries and can see them in the object...

TomKane, I have created DSN using the Microsoft Text Driver, but when I try to add a data adaptor to my project that uses the DSN I recieve an error stating "The Connector you have created does not work with the current adaptor." Any suggestions on why I am getting this error? Mep

Hello, I am trying to analyze data stored in a tab delimited text files. I would like this data to be imported into a datagrid to be manipulated by a user. I was thinking of setting up the text files as an ODBC Data Source but am having dificulty creating a connection. Does anyone have some...

Skip, Thanks for the help. I have ~25 sheets, not rows. And each sheet has a different number of rows. I think I will have to write a macro. Eric

Skip, I have ~500 cells in each column and ~25 worksheets. I don't want to manually create the columns. Is there an easier way to have the columns loop. Eric

Hi, I am trying to print columns A, B, and C from an Excel spreadsheet. I would like to add two "columns" to the printout so that the first 25 rows are on one side of the printout and the next 25 rows are on the other side of the printout. Similar to Tools->Columns in Word. Thanks...

Skip, Thanks! Now I know how to access the charts embedded in a sheet. I am trying to name the charts as they are created, before they are moved to the new sheet. When they are moved to the new sheet the name is changed. Is there a way to prevent the name from being changed when the...

Skip, Yes, the ChartObjects are embedded in a worksheet. How do I name them so I can access them individually? mep

leighmoore and skip, After being created, the charts are moved to a seperate sheet as an object. The old code accessed the charts as a shape as shown below. Worksheets("Summary for Export").Shapes(23).IncrementLeft 265 Worksheets("Summary for...

Hi, I am trying to edit some macro code written by a co-worker involving excel graph objects. The macro scans the data and creates a chart. I have inserted the following line to rename the chart so that I can access it later. ActiveChart.Name = assays(i) & controlRange After updating the...

Hi, I am trying to select a print area but am having trouble with the syntax of my variables. Set startPrintRange = thisStartRange.Offset(-x, 0) Set endPrintRange = thisStartRange.Offset(0, 11) Range(startPrintRange, endPrintRange).Select ActiveSheet.PageSetup.PrintArea = startPrintRange &...

Closer, it must be a setting in my environment, I tried another machine and I was able to edit the stored procedures. mep

Ramani, Thanks, I tried cleaning up the project, refreshing, and a restart. No luck. I can't even add or remove a stored procedure. mep

Addition, I can open the stored procedures with the command Modify Procedures with the correct database open. But I can't do anything with any stored proecures from the project manager. mep