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!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by A1Defiant

  1. A1Defiant

    Is it possible to combine java and VB

    Something else... my mate VB programmer and I'm java. We also wrote separate programs in our respective languages and we got the 2 talking by using Sockets. Which is another way. It doesn't matter how you talk via sockets as only strings are transmitted (Don't try to transmit data as type as...
  2. A1Defiant

    Is it possible to combine java and VB

    You maybe right about the .Net with the published version not being able to support java although you maybe able to find java plugins somewhere on the internet. Originally .Net only shipped with VB, C++, C# and JScript but they were about 17 other planned languages including APL and COBOL. As...
  3. A1Defiant

    Excel Range Parameters for Function

    No sorry, this still isn't sorted. CellContent "A1","Hello New Value" would call the function Sub CellContent(strCellAddress as String,strCellValue as String) Which is ok but supose I don't know what the cellContent values are going to be until they're added into the...
  4. A1Defiant

    Is it possible to combine java and VB

    Several ways you can do this: First is by having an intermediate code. COBRA or some sort of SOAP/XML code. These involve passing objects to each other to communicate between the 2 languages. 2nd is employing .NET, This is built with a CLR (common Language runtime) that is designed so that you...
  5. A1Defiant

    Excel Range Parameters for Function

    Cheers RV & All With your help I think this should work though; '''''''''''''''''''''''''''''''''''''''''' sub ChangeValue(instrCellAddress as String) Dim strCellAddress as String strCellAddress = instrCellAddress objWorkSheet.Range(strCellAddress) = "Hello New Value" End Sub...
  6. A1Defiant

    Excel Range Parameters for Function

    Cheers K2w for your feedback. Unfortunately no. I would like to do this objWorkSheet.Cells(1,2) = "Hello New Value" but without 1,2 in there any value I want. so objWorkSheet.Cells(A1) or objWorkSheet.Cells(F5) except I've got a hundred different cells all in different Cols and Rows...
  7. A1Defiant

    Disconnect your modem

    Nope unfortunately non of these helped solve this one. I'm on broadband now so don't have to worry about this.
  8. A1Defiant

    Excel Range Parameters for Function

    I realise that this is probably easy but you now beginners. Guessing myself it maybe something like the following: Sub PullD(MyPos As Range) Range("MyPos").Value = "Hell" End Sub This would then change the value to what ever cell I place into the formula to...
  9. A1Defiant

    Excel Range Parameters for Function

    All I need is to create a VB Sub command and have the parameter which will be "A1" or "Z3" or what ever cell reference is then put that reference into the Function so I can change the value of it. So excel reads =MyFunction(A1) And VB Sub MyFunction(CurrentPos)...
  10. A1Defiant

    Disconnect your modem

    Cheers, Didn't work but what I want more control over when my modem dials to the internet and when it disconnects. If I had only one program using the internet it wouldn't be a problem. I've got 4 seperate programs using the internet for various things and would like a easy way to disconnect...
  11. A1Defiant

    Disconnect your modem

    Ok not usually what you want to do but does anyone know a MSDOS command that will make the modem disconnect? So I can write a *.bat file and disconnect the modem. P.S. Other restriction is no other programs allowed such as net-time etc.
  12. A1Defiant

    getting repeated errors after 2nd visit

    Cheers, I've added objConn.mode=adModeReadWrite And hopefully this will sort it! All okay so far!
  13. A1Defiant

    getting repeated errors after 2nd visit

    I keep getting this connection error after trying to access the same asp page several times over. I guess it's to do with the connection I've setup. Here's my connection details, <!--#include file=&quot;adovbs.inc&quot;--> <% Set objConn = Server.CreateObject(&quot;ADODB.Connection&quot;)...
  14. A1Defiant

    Array Problem

    I'd advise you to reduce the array down to 5 elements and try and solve this one. It will make the code much easier to see then if it works add more elements
  15. A1Defiant

    Active X up the tree?!?

    Does anyone know how to capture when a ActiveX Object cant be created? I've got a piece of javascript to capture code but not all machines are capturing these errors. If anyone knows why some of these Win98 machines arent displaying with the little yellow excalmation mark either it would be...

Part and Inventory Search

Back
Top