Sub aaa()Set a = Range("A2:A11")temp_data = aEnd Subtemp_data will have an array of 1 to 10

SIM:errormessage = display message on screen other stream output? text file, printer

SIMerrormessage "hello world"

DOS batchecho hello world

<t>i got a table of data in temp_datathe size is 45000 + rows, 12 columnsi want to do a sorting in this temp_data(45000,12) via vbait will be a very time consuming task to use a bubble sortI know I can use the following method1. load table into excel worksheet2. sort3. read it back into temp_data()t...

<t>Dear all,How can load a table of data into a range and apply excel's sorting function?I know I can write a bubble sort to do it but I don't want to use bubble sort in this case.I don't want to open a new worksheet, load all data, sort, and read all data, time consuming... e.g.dim temp_data(3,2) a...

<t>Dear all,I'm using outlook 97 and I received a email send by outlook express 6 with 5Mb attachment filewhen he send the email , he use outlook express function: "split large email when the size > 1024k" now i receive 7 emails with attachmentATT00000.att; number=1; total=7toATT00006.att; number=7;...

Thank you.The function can get 1 cell's value, not an arrayI think I should stick with open the workbook and read data...

<t>Dear all,When I write macros in excel vba, i need to open a excel file to read the index and do something...the codeWorkbooks.Open "c:\Conversion.xls"temp_data1 = Workbooks("Conversion.xls").Sheets("Data").UsedRangeworkbooks("Conversion.xls").close savechanges:=falseIs it possible to read all dat...

Dear all,How can i get the result from excel autofilter?for example: Cells.AutoFilter Field:=2, Criteria1:="aaa" Cells.AutoFilter Field:=3, Criteria1:="bbb"it return 10 rowshow can i get these 10 rows into variant?

excellent! I can remove all those "for loop" now.thank you rblaser

<t>Dear all,If i want to format a string "123" into "0000000123"I will use '--------------------newStr = format("123", "0000000000")'--------------------but what if the length of string will change over time?example:myZero = textbox1.textfor i = 1 to len(myzero)aaa=aaa & "0"next inewStr = format...

the date is come from a text file.it work now, DateSerial work well Thanks germoz

<t>actually i try this already...if the system time format set as yyyy/M/dSub Germoz()a = "06-12-2004"MsgBox (Format(DateSerial(Year(a), Month(a), Day(a)), "dd-mmm-yyyy"))End Subwill return 12-Jun-2004 '<-- wrongif the system time format set as dd-mm-yyyySub Germoz()a = "06-12-2004"MsgBox (Format(Da...

Compare with C & VBA,If u want to pump a huge amount of data in/out VBA in 1 shot... it will die easily.C can handle this problem better.