Recent content by JBG

It appears I was having some corruption issue with Excel. I have 2 desktops, and I just tried my orignal code on the other machine and it works fine on the second machine. My first machine gives the dreaded "memory could not be read" when I close Excel. Thanks experts....I appreciate...

Ben, that is exactly what I do too.....:)

OKee doke, yes, I will be clearer. Here is sample code that I want to copy 3 columns, B, C and D in their entirety (including formatting and formulae) to the next 3 columns E, F and G. WHen the copy is done, I want 6 columns, the first 3 and and last 3 are exact copies of one another, the only...

Hi experts, Here is a code snippet that i am using from within an Access 2000 module to copy the end-30 columns of a spreadsheet into the next 30 empty cols: objExcelSheet.Range _ (strExistingBegColHeader & "1" & _ ":" & strExistingBegColHeader &...

Props to you Skip. Worked like a charm, and of course, now that my project lead and I did it, it is sooooo easy. A cyber high-5 to you from me and Tim, the project lead. Thanks a jillion, Jeff

Two things. One. Thanks for letting me beat this thing into the ground with you. Two. I will try in in just a few minutes. Three ( I lied above)... Thanks! JEff

OK Skip,here are the questions. The spreadsheet I have is about 50 columns wide with 10 rows of data in it already....about 28 of the columns use formulae to derive their data from other columns, whilst the other columns are just data. The fix for my issues is...

Hi Skip, I think I get the beauty of your method.... Once I define the cells with a name that will take into acct. however many rows are entered, I take that defined name and use it as the series value.... OK, I am going to try it Monday at work. I may have a question or 2 along the way...

I tried it, but it still didnt work. Here is what the "values" looks like after the code runs: ={0.95317161758983,0.995208674820325,0.983090984628168,0.975676242398826,0.975963756868996,0.975963756868996,0.975963756868996} Ouch.

Hi experts, This is part 2 of my dilemma (and I apologize for the long post). I had previously posted that the solution(s) I was given worked, but they did not. I am trying to update the 5 series in an existing chart in an XL spreadsheet. Internally (when I look in the excel's VB editor), the...

very cool. I am going to have my project lead (and an excel guy) look at your response.... Jeff

Thanks skip. Here is how I am doing the code, First I return the total number of rows from the spreadsheet, say that number is 10 (intNumberOfRows). Knowing that i am going to write to that spreadheet a new row, meaning that I will now have 11 rows, I use this: objSeries.Values =...

It worked. Thank you VERY much for the reply... Jeff

I will give it a go as soon as I get work. Much obliged... Jeff

Hi experts, I am trying to update the 5 series in an existing chart in an XL spreadsheet. Internally (when I look in the excel's VB editor), the chart is referred to as "Chart2" Here is the snippet of code that continues to return this error: "1004 - Unable to set the values...