User Profile

Collapse

Profile Sidebar

Collapse
platski
platski
Last Activity: Sep 10 '07, 04:47 AM
Joined: Jul 16 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • platski
    replied to Spreadsheet Maker Form
    in Visual Basic
    Here is where my file may be located:
    http://www.ozgrid.com/forum/showthread.php? p=389016#post38 9016

    I Ok. So everything was quite confusing before I put this into practice.

    Im interested in having a dynamic selection process that the user can select a contiguous set of cells and the program will deal with routing the right values to the right columns.

    I think that must be possible...
    ...
    See more | Go to post

      Leave a comment:

    • platski
      started a topic Spreadsheet Maker Form
      in Visual Basic

      Spreadsheet Maker Form

      I have learned a bit about vb recently and have been using it for my job, I still have questions and dont know how to do many things yet.
      I appreciate your time and efforts and hopefully I can figure out how to make this procedure work.

      This is all taking place in vb6 and excel 2003.

      I am making a userform that is activated once the user highlights a bit of spreadsheet and clicks a button on the command bar,...
      See more | Go to post
      Last edited by platski; Sep 7 '07, 11:00 PM. Reason: subject change
      • platski
        replied to Small Excel Program that Copies data and pastes it into new file
        in Visual Basic
        I am trying this code for passing the selected data, but its not working.

        Sub AddNew()
        Dim PassData1 As Variant
        Selection.Copy = PassData1
        Set NewBook = Workbooks.Add
        With NewBook
        .Title = "xxx"
        .SaveAs Filename:="xxx. xls"
        End With
        Range("A1").Val ue = PassData1
        End Sub
        See more | Go to post

          Leave a comment:

        • platski
          started a topic Small Excel Program that Copies data and pastes it into new file
          in Visual Basic

          Small Excel Program that Copies data and pastes it into new file

          I am making a program for Excel to help some office employees who have a very repetitive and ongoing task.

          The form I made in excel has a Date TextBox, a Textbox for the name of the person who worked on the file, a To Store TextBox, and a From TextBox.
          I also have a Browse Button and a TextBox for it.

          The idea is to highlight a bit of spreadsheet, and then pass the values in that unspecified area into the form...
          See more | Go to post
          Last edited by platski; Sep 6 '07, 12:53 AM. Reason: forgot to specify that this happens in excel
          • platski
            replied to Crosstab Behaviour required for Data Input
            in Access
            can I have some examples too? I am trying to recreate the ICP testing project and chuckbo's project as well.
            See more | Go to post

              Leave a comment:

            • platski
              started a topic Button Commands in Excel VB
              in Visual Basic

              Button Commands in Excel VB

              I am working on some forms for a button in a spreadsheet.

              two Button Commands in VB excel.

              Here are my notes as to what I think will be needed to get the job done:

              Click NY1TR
              Send Data from 'Perfect 'Analyzer' ("B2:C273") to 'Tables' ("AV1")
              Send Data from 'Analyzer' ("B2:C273") to 'Tables' ("AV2")

              Click NY1PI
              Send Data from 'Analyzer'...
              See more | Go to post
              No activity results to display
              Show More
              Working...