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 Rhinorhino 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: bDreamie
  • Content: Threads
  • Order by date
  1. bDreamie

    Executing an External Script in Access

    I'm trying to run a script written out of Access with the activation of a button on the main form. The script is already written to generate a output file from the system, the output file which I want to import into Acesss. The import specifications in Acess are already done by way of a macro...
  2. bDreamie

    Calender Control in Access. Please help =)

    Hi, I'm currently having a problem with the calandar control in Access. I have it on the form, and wanted a text box (in the form and also in a tbl_date table) to lookup the value of the date selected in the calendar control, which should be defaulted to the current date. I know I have to write...
  3. bDreamie

    Looping Through Sheets in Excel?? Help please..

    Hi all, I have a problem with VB in Excel. I'm trying to loop through sheets to pick up information and consolidate into another main sheet. My sheets names are by dates for the month, eg T01-Nov-01, T02-Nov-01, T05-Nov-01 etc. Dates are only for working days in the month (from 01-31 of the...
  4. bDreamie

    Comparing Data by VB in Excel

    Hi all, I have 2 similar sets of data on a same spreadsheet, one of which has less records than the other. The reference ID of the records are unique, some can be foudn on both sets of data, some only on either one set. Can I write a macro to do a line by line comparison of the ID and thereby...
  5. bDreamie

    Specifying File name with Arrays, pls help

    Hi all, I'm trying to repeat a process for different files and didn't want to repeat the codes. Therefore I'm trying to build sthg like this: SheetName = Array("math", "english") For i = 0 To UBound(SheetName) Select Case SheetName(i) Case Is =...
  6. bDreamie

    VB: How to copy range of cells with condition??

    Hi all, I'm having problem writing a VB macro for excel. Currently I have: x = 5 Do While Cells(x, 5) = "New Trade" Cells(x, 1).Select Selection.Copy Cells(x, 12).Select ActiveCell.PasteSpecial...

Part and Inventory Search

Back
Top