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!

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

Search results for query: *

  • Users: gaiya
  • Order by date
  1. gaiya

    Writing Excel SS via VB

    Thanks CajunCenturion, One last thing. Is there any documentation, books etc you could point me to. Cheers
  2. gaiya

    Writing Excel SS via VB

    Thanks CajunCenturion, Unfortunately your answer falls down in a couple of places. The variables holding the range values need to be numeric values so "A3" is no good. Also, the syntax you have suggested is incorrect. The ":" separating the start & end values is not...
  3. gaiya

    Writing Excel SS via VB

    Trying to create & manipulate Excel SS via VB. Stuck trying to replicate the Macro Code below as to the syntax required in VB. i.e how to represent a Range of cells. Any Takers? Range("A1:A10").Select With Selection.Interior .ColorIndex = 19 .Pattern = xlSolid...
  4. gaiya

    How to Open .xls or .doc files from within a VB App

    I am a numpty VB developer trying to do the above. I can identify the file either by the CommDialog or by use of drv, dir, fil list boxes but cannot suss out how to open the file. Any help, code snippets or links appreciated. Also, will it be the same method in VBA for use within Access?

Part and Inventory Search

Back
Top