Search results for query: *

Hi, I've created in VBA a USerform named (form1) in which I've one textbox1 and one clickbutton. After complete textbox1 and push clickbutton I would like to run this query based on fact that the variable in textbox1 is passed to SQL string , currently it doesn't work. RS.Open "SELECT * FROM...

ok, thanks now it works! great!

Hi, I'm newbie about VBA Excel 2007 , i've found this example on J.Walkenbach book but when I insert the text in inputbox the the value in cell is not update , it remain blank, what could it be the problem? Sub getdata() Dim nextrow As Long Dim entry1 As String, entry2 As String Do nextrow =...

Hi, based on a long list of p/n and relevant value in US$ (in descending order) I would like to find lonely the few items which sum rappresent 80% of total value. Do you know if it's possible with formula array?? Thanks Marco

Hi, I'm a end user and I would like to install sap ides 4.6c on my virtual pc but i've poor knowledge of windows 2000 server & sap installation. Where I can find detailed information about this..?? thanks

Hi, sometimes I need to update a price list in SAP r/3 and this operation required a lot of time due the quantity of items to update for example 300p/n, similar problem during schedule agrement modification. - Do you know a transaction able to do a massive modification of ifo record and a...

I've tested formulahidden after command click button event as follow but the formula remain visible, what it's wrong? I've excel 2007. Range("g3").FormulaHidden = True Thanks Bye Marco

Thanks a lot!

HI!, please help me to understand what is wrong about this code. Inside destination cell f1 an error message appear. Range("f1") = [Sum((A2:A10="Fax")*(B2:B10="Brown")*(C2:C10))] I suppose the errore it's linked to curly braces but i'm not sure. Thanks Marco

Ok thanks! very nice! The last question about date verification in case of mistake when manually insert this date. How can VBA/Excel check if the format "mm/dd/yyyy" is respected? Could you suggest a method to implement this?

i'm new about VBA for Excel so i kindly ask your support, i've created a form with a field text and a button. I manually write a date in the text field and i push the botton in order to transfer this date to excel worksheet but it doesn't happen, the cell is activated but this strange date...