...it's me...eRiCk

in VB 6 we can use App.Previnstance to check for another instance but in .NET 2003 we use something like this If UBound(Diagnostics.Process.GetProcessesByName(Diagnostics.Process.GetCurrentProcess.ProcessName)) > 0 Then msgbox "Another instance alreay running" End If see u later

well, i'm not aware that i've been more than 3 weeks now working in our client NEC Indonesia. first i gonna tell u that making an Add-On in SBO is not hard as i imagine before..they got all sample that need to be used in SDK..just installed the SDK component that u can move forward.. also u need some more experience than u to ask for why this working, why u need this, etc..so u can move more fast :D IMHO SAP SDK is not flexible enough and the error documentation is not great enough coz i some time need to search from internet for the error..most of it just take a guess by looking at the source code ;( but most of all, they put up great effort coz making it possible modifying SBO using other code like C#, VB 6, VB.NET, etc.. gonna continue my exploration ;) see u

took me some time to search for it eventhough i already found a few months ago ;( -- Read from Excel file SELECT * FROM OPENROWSET( 'Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=PATH_TO_EXCEL_FILE_HERE;IMEX=1;HDR=Yes;', 'SELECT * FROM [SHEET_NAME_HERE$]') Or SELECT * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="C:\TemplateImportBudget.xls";Extended properties=Excel 8.0;')...Expenses$ PS: when try this query, make sure no application open the excel file otherwise u'll get an error u need to enable Ad Hoc Distributed Queries configuration see this link see u

took me some time to search for it eventhough i already found a few months ago ;( first is to read from excel file..i tried this using Query Analyzer -- Read from Excel file SELECT * FROM OPENROWSET( 'Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=PATH_TO_EXCEL_FILE_HERE;IMEX=1;HDR=Yes;', 'SELECT * FROM [SHEET_NAME_HERE$]') Or SELECT * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="PATH_TO_EXCEL_FILE_HERE";Extended properties=Excel 8.0;')...SHEET_NAME_HERE$ PS: [FROM MS] IMEX=1 tells the driver to use Import mode. In this state, the registry setting ImportMixedTypes=Text will be noticed. This forces mixed data to be converted to text. For this to work reliably, you may also have to modify the registry setting, TypeGuessRows=8. The ISAM driver by default looks at the first eight rows and from that sampling determines the datatype. If this eight row sampling is all numeric, then setting IMEX=1 will not convert the default da...

monday perhaps gonna be important day for me..cause the BridgeStone project gonna be started soon :D still need to learn SBO..how to develop an add on inside it.. hopefully in two days gonna learn alot ..alot..:D

well after meeting in Medan for 4 days (fiuh, a hard day there..coz work all the time :D)..we finally got a project with Bridgestone developing an AddOn using .NET 2003 i think.. the project start on this week..on monday May 07 2007..need to learn using SDK then.. huaa learn something new again... see u all

just get back from the training for 2 days now, the training is scheduled for 1 week i think :D weel first of all SAP made a great program like B1..very interesting in way of programming side coz i never realized it can be done that way(B1 way) hard for me to understand business process before but after attend the training the understand is well in higher level now but still can't be a consultant.. just come to my thought wether i should be programmer or consultant coz SAP is worlwide vendor with worldwide program that use well in 'BIG' company i think :D but i think i'll be an SDK for B1 since it still 'touch' B1 also programming skill that i have and also perhaps in this 15th March i'll be try my exam now to get MCAD after that go on for MCSD.. much much pray :D until then