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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: JBG
  • Order by date
  1. JBG

    VBA in Access to Copy XL columns

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

    VBA in Access to Copy XL columns

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

    VBA in Access to Copy XL columns

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

    VBA in Access to Copy XL columns

    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 &...
  5. JBG

    (part2) Need help with dynamic XL Chart range

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

    (part2) Need help with dynamic XL Chart range

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

    (part2) Need help with dynamic XL Chart range

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

    (part2) Need help with dynamic XL Chart range

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

    (part2) Need help with dynamic XL Chart range

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

    (part2) Need help with dynamic XL Chart range

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

    Changing Series in XL Chart dynamically

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

    Changing Series in XL Chart dynamically

    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 =...
  13. JBG

    Changing Series in XL Chart dynamically

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

    Changing Series in XL Chart dynamically

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

    Changing Series in XL Chart dynamically

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

    Need to code Winzip "Split" option...

    I am using this code: http://www.codeguru.com/vb/articles/1854.shtml to progammatically zip files (the code works perfect). However, several of the files I will need to zip need to be split into the smallest chunks possible. Winzip 8.1 has an option called "Split" where the user...
  17. JBG

    Need to code Winzip "Split" option...

    Forgot to add that I am unable to post my question at: http://www.codeguru.com/vb/articles/1854.shtml I get an error everytime I try... JBG
  18. JBG

    Need to code Winzip "Split" option...

    I am using this code: http://www.codeguru.com/vb/articles/1854.shtml to progammatically zip files (the code works perfect). However, several of the files I will need to zip need to be split into the smallest chunks possible. Winzip 8.1 has an option called "Split" where the user...
  19. JBG

    ADP/cannot update cont. form - why?

    I got the answer, though it seems weird. If I copy table, which I had done and had the problem, I cannot create an autoform that can be edited. But if I create the table from scratch, it works fine. Hmmmmmm... Jeff
  20. JBG

    ADP/cannot update cont. form - why?

    I am creating my first ADP application. All is well, and I am referencing "Professional SQL programming with Access 2000" (xlnt WROX book). But now I need to create a continuious from based on a table. In fact, just for testing, I simply want to create a test table with 3 fields...

Part and Inventory Search

Back
Top