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!

Recent content by schnabs

  1. schnabs

    Comparing values across sheets.

    Bump for help.
  2. schnabs

    Comparing values across sheets.

    Hello, I have a workbook with two sheets. I am trying to use VB to make sure the totals on each are equal, as they should be. This is my code thus far. Private Sub Compare_Click() Handles compare.Click Dim oxl As Microsoft.Office.Interop.Excel.Application Dim oxlbook As...
  3. schnabs

    Copying and Pasting Excel Ranges

    Bump anyone? I really have no idea what is going on.
  4. schnabs

    Copying and Pasting Excel Ranges

    Hello, I am using the following code to copy a range from one sheet, and paste it into another. I had thought the code works, but something is wrong, as no matter how I change it, I get the entire data range pasted regardless of what I set to copy. My code is as follows: copyrange =...
  5. schnabs

    Using VB Express to Automate Excel

    Wow that's pretty useful. Thanks River.
  6. schnabs

    Using VB Express to Automate Excel

    Well I think that is my problem, the correct functions from the Excel libraries. xlUp doesn't seem to be the right one, but I can't find out for the life of me what the correct syntax is.
  7. schnabs

    Using VB Express to Automate Excel

    Hello, I am using VB Express to automate some functions in Excel. Currently I am trying to populate several cells with text. I was able to do this quite easily using the VBA built into Excel, but I want to automate everything through VB, rather than running a macro from another sheet. The...
  8. schnabs

    Using Calendar in VB 08

    One last question. How would I use that string to be placed in my excel file in another sub? Since dateneeded is declared in the separate sub, I do not know how to refer to it from my query sub.
  9. schnabs

    Using Calendar in VB 08

    Awesome, thanks River. Only one last question. And this is kind of a newb question. How can I store the date selected as a string, then use it in my code?
  10. schnabs

    Using Calendar in VB 08

    Well here is my entire block of code. Public Sub Summary_click() Handles summary.Click Dim usercontrol1 As New UserControl1 Dim temp As String Dim oxl As Microsoft.Office.Interop.Excel.Application Dim oxlbook As Microsoft.Office.Interop.Excel.Workbook...
  11. schnabs

    Using Calendar in VB 08

    Well yes I figured as much, I guess where I'm having trouble is the code required to pull the date from the calendar. I switched to try using the datetimepicker, but still the code is holding me up a bit.
  12. schnabs

    Using Calendar in VB 08

    Hello. I have a code that runs through a DIR of Excel sheets and updates them. What I am looking to do, is before it refreshes my Excel query, I want to insert a date on the current workbook. But I want a calendar to pop up and the user to select the date. My code is as follows: Do While temp...
  13. schnabs

    Creating a ListBox to save my file

    Looks good. I implemented the code, but when I build it, my box is there, with no names in it. Any ideas?
  14. schnabs

    Creating a ListBox to save my file

    Hello, I am combining and saving an excel file. Currently, this is how I am doing it. newName = "Z:\2009 Combined Delinquencies\April\" + path oxlBook1.SaveAs(newName) What I would like to do, is create a listbox of the 12 months in the above directory, and have the user choose the month in...
  15. schnabs

    Using DIR

    Hey everyone, I am using some code to combine two workbooks in Excel into one. I am using the DIR command to run through directories of the original files. My problem is, the first Dir seems to work, but the second one doesn't. My combined file has each of the first directories file, but only...
See more

Part and Inventory Search

Back
Top