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 derfloh 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: *

  1. bDreamie

    Executing an External Script in Access

    I think the Xstart script runs from Exceed. The script is written by the IT support and I need to utilise it for my reporting purposes. Do you need more info about Exceed? I heard that it's unix or sthg similar. Please help. Thanks a lot :)
  2. 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...
  3. 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...
  4. bDreamie

    Looping Through Sheets in Excel?? Help please..

    Thanks a lot for your help. I tried this out but there is an error on data type. I did the following before next i. Sheets(oSheet).Select Is sthg wrong with this line? Also I will like to vary the month and year, such that for December I need not change the macro. Can I do a...
  5. 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...
  6. 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...
  7. 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 =...
  8. 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