Search results for query: *

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 :)

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...

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...

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...

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...

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...

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 =...

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...