User Profile

Collapse

Profile Sidebar

Collapse
sitko
sitko
Last Activity: Nov 18 '08, 05:32 PM
Joined: Sep 6 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • sitko
    started a topic VBA - Excel Charting help

    VBA - Excel Charting help

    Hi,

    I'm trying to create a chart in VBA in an excel sheet. When I manually create it, it creates it just find, but for some reason, when I try to automate its creation, it doesn't include both values in the Datalabels, here is the code I use:
    Code:
    ' (NumBottles is passed in)
    
        Dim wb As Excel.Workbook
        Dim posSheet As Worksheet
        Dim NodeNum As Integer
        Dim ChartTitle As String
    ...
    See more | Go to post

  • sitko
    replied to VBA - Issues with Dir() and MkDir
    so, I guess the problem lies elsewhere...

    Thanks,
    Sitko.
    See more | Go to post

    Leave a comment:


  • sitko
    started a topic VBA - Issues with Dir() and MkDir

    VBA - Issues with Dir() and MkDir

    Hi,

    I inherited some code from a client, and have been having issues with it.

    The first line was:
    Code:
    If Dir$(opath & "Requests\" & dirStr, vbDirectory) = "" Then
    I did a search in VBA help, and couldn't find 'Dir$' but did find 'Dir' I figured this was an instance where VBA had slightly less functionality than VB6/.net has...

    Dir$ returns a string,...
    See more | Go to post

  • sitko
    replied to Unix-C-Running-thereof
    in C
    I'm not sure how I did it, but I got it to work...

    I added "/bin/sh ./"<shell script> and that seemed to do the trick.

    Thanks.
    See more | Go to post

    Leave a comment:


  • thats what I thought as well. In Windows (vb.net) it caused a Linking error...but in Unix, all I got was the segFault.

    Thanks....
    See more | Go to post

    Leave a comment:


  • sitko
    started a topic Problem with a Shell Script

    Problem with a Shell Script

    Hi,

    Its been a long time since I've worked with Shell scripts. I got a script from a co-worker and need it make it do some stuff, and for the life of me, I can get it to work.

    Code:
    # Creates the date
    DIR_EXT=`date '+%Y%m%d_%H%M%S'`
    
    # I want this next line to take the date created above and add a "_" and the value in the $JOB_NAME, and make this one directory.
    UNIQUE_DIR=$DIR_EXT_$JOB_NAME
    ...
    See more | Go to post

  • All,

    I found the problem.

    It wasn't anything to do with my arrays, although there was one error in there....see if you can find it, and if not, I'll post it later, think of it as a puzzle.

    The problem was that I had commented and uncommented out some error checking printf's lower in the code (not presented), and when I was un-commenting them, I by accident un-commented out a bit of code that shouldn't...
    See more | Go to post

    Leave a comment:


  • No, I used
    Code:
    "char gstrCasePart[19][40] = {{"Outside, Long Sides"},{"Outside, Bottom"}, {"Outside, Short Flaps"},{"Outside, Long Flaps"}, {"Inside, Ends"}, 
    {"Inside, Side Flaps"},{"Inside, Angled Flaps +X+Y, -X-Y"},
    {"Inside, Angled Flaps +X-Y, -X+Y"},{"Cover"},{""} //,{""},{""},{""},{""},{""},{""}
    ...
    See more | Go to post

    Leave a comment:


  • After reading through more of the SegFault posts, I see a common theme, check your arrays....I've done that, to head you off at the pass.

    If I set the arrays to values Greater than the number of elements I'd ever need, should that cover those situations?

    I also initialize both arrays with values, 0 for the intArrray, and either the name of the part "Cover", etc, or "" null for the strArray.
    ...
    See more | Go to post

    Leave a comment:


  • sitko
    started a topic SegFault in little arrays, I can't find the bad call...
    in C

    SegFault in little arrays, I can't find the bad call...

    Sometimes it just takes another's unbiased eyes to see a problem in code:
    The arrays are set up as: "int gintCasePart[30];" and "gstrCasePa rt[19,40];"
    Here are two code snipets I added to the previously working code (hint: it works on Windows, but not Linux):

    Code:
    ...
        gintCasePart[0] = 1;
    	gintCasePart[1] = 2;
    	gintCasePart[2] = 3;
    	gintCasePart[3] = 4;
    	gintCasePart[4]
    ...
    See more | Go to post

  • sitko
    started a topic Unix-C-Running-thereof
    in C

    Unix-C-Running-thereof

    Hi,

    I know this is a stupid question, but is there any special trick to running a C program on a Unix machine, after I've made (make)d it already? I've not touched this code for several months, and now I need to run it from a shell script, and for the life of me, I can't figure out if there was anything else I need to include with the call to the C program. I have:

    Code:
    #! /bin/sh
    C_Program input.txt
    ...
    See more | Go to post

  • I'll try it, but I do know that I need the files to be text instead of binary, but I'm sure thats just a binary copy, instead of making binaries...

    :)...
    See more | Go to post

    Leave a comment:


  • OK, I attempted to make make a range variable and set it = to range(target), but that didn't work...so I tried "If Target.Column <> 3 Then Exit Sub" and that worked.

    But, apparently something I've recently done, has broken the VBA, in such a way that I can't find...I'm thinking I'll need to go back and re-do all my changes one at a time.

    Thanks,
    Sitko....
    See more | Go to post
    Last edited by sitko; Feb 11 '08, 05:13 PM. Reason: decided I'd rather not ask everything I asked...

    Leave a comment:


  • Hi,

    I'm having a weird error, that wasn't a problem with the code at the beginning. I do some checks before I go into the moving of rows from one sheet to another, here is the code:
    Code:
      'above this, I just dim the variables
       If Target.Cells.Count > 1 Then Exit Sub
        If IsEmpty(Target) Then Exit Sub
        If Not Intersect(Target, Range("C1:C60000")) Is Nothing Then Exit Sub
    ...
    See more | Go to post

    Leave a comment:


  • I see. Took me a while to see that "open" and "close" were the names of the sheets, yes, my coffee hasn't kicked in this morning yet.

    I'll definitely try this (in the next phase) my boss told me to move on from this issue for now, since the users were manaually cutting and pasting the code prior, so they are 'used' to this problem...I hate writing buggy code...

    Thanks again for your help,
    ...
    See more | Go to post

    Leave a comment:


  • Thanks again, that worked like a charm.

    I had to copy the parts over in reverse order, to get them in the right order. Heres my final code: I gave the variables more meaning full names:
    Code:
                init_Row = Target.Row
                If Cells(init_Row, 79).Value = -1 Then
                      Do
                          init_Row = init_Row - 1
                          If Cells(init_Row, 79).Value <>
    ...
    See more | Go to post

    Leave a comment:


  • And your putting this in the Worksheet_Chang e Event? Since you reference 'target.row'? This looks very elegant, thanks...I'll report back if it works. The one question I still have, but this can be figured out by trying it...is will the parents(with kids) formula be updated before this code activates? I'll also post that answer as well...

    Thank you very much.
    Sitko....
    See more | Go to post
    Last edited by sitko; Feb 7 '08, 07:33 PM. Reason: wanted to remove unnecessary text from quote

    Leave a comment:


  • VBA: Excel - automatically copying rows from one sheet to another based on user input

    Hi,

    I have an Order tracking spreadsheet that I need help with.

    I have a 2 worksheets "Open", and "Closed".

    I have entries on the "Open" sheet which may or may not be grouped together. I've called the rows :Parents and Children. There are basically 3 types of rows. Parents with Children, Parents without Children, and Children. I have a reference cell for each row, where I...
    See more | Go to post

  • sitko
    replied to IIS as a file storer?
    in IIS
    I did search the forums but, couldn't find any topics that sounded revelant...

    And, I'm not 100% that you took my meaning. I was asking if you could store and access a file AT a IIS location. And yes, I'm sure this is a basic question.

    Thanks,
    Sitko....
    See more | Go to post

    Leave a comment:


  • sitko
    replied to IIS as a file storer?
    in IIS
    Thanks for your response...we'v e decided to do this a different way. The mention of the VBS was just a potential way we would store the file there...the main thrust of the question was if an IIS could be accessed by other means and used as a storage location.

    Thanks,
    Sitko....
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...