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 Chriss Miller 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 Katto

  1. Katto

    VBA permutation of arrays

    it's a good start. eanough to allow me to cusotmize it to my specific need thanks again
  2. Katto

    VBA permutation of arrays

    Thanks mikrom It works great
  3. Katto

    VBA permutation of arrays

    Wow, Thank you all for your responses I'll try the VBA code suggested
  4. Katto

    VBA permutation of arrays

    you do understand that your solution is the trivial solution to the problem I stated, right? It's not quite what I was looking for
  5. Katto

    VBA permutation of arrays

    no business requirement. it's just a problem that I had before and can't stop trying to get an answer to it
  6. Katto

    VBA permutation of arrays

    Thanks, but, as I mentioned before, I need a script where the NUMBER OF Variables can be a variable ITSELF In your code, there are 3 nested loops. If another case requires 10 variable, I need to rewrite the code to accomodate 10 nested loops. No big deal but, it limites the generality of the...
  7. Katto

    VBA permutation of arrays

    Here is a more detailed presentation of the question: I have 3 variables A,B,C which can have repectively 6,4 and 3 possible values. I need to create SETS of [A B C] that cover all the possible combinations of A, B and C values. All this in VBA where the input is the NUMBER of VARIABLES (here...
  8. Katto

    VBA permutation of arrays

    Hello, I have the following Table Name Min Max Nvals A -5 6.7 6 B -10 23 4 C 2 15 3 I am looking for a code that generates all the sets of [A B C] that include all the possible variatiosn as defined in the Table The cath is that the code has to be able to cope with an apriori unknown number...
  9. Katto

    Paste picture from clipboard into aslide of an opened powerpoint file

    Hello, I am trying to paste a picture into an open powerpoint slide using VBSCRIPT. I need to find the latest slide an paste it there I have this code which fails on the Activewindow.Selection line. Also the ns line does not work Help would be appreciated Thank you Dim oPPS Dim studio Dim...
  10. Katto

    Excel VBA functions in VBScript

    Thank you. fixed it
  11. Katto

    Excel VBA functions in VBScript

    Hello, I have this script and the LastColumn and LastRow lines do not work. Any suggestions? Thank you Set objExcel = CreateObject("Excel.Application") strExcelPath="C:\TMP\TEST.XLSX" objExcel.Workbooks.Open strExcelPath objExcel.Visible = True Set objSheet =...
  12. Katto

    Translate word document using VBA

    yes, I have a word version of a book in Russian and I would like to translate it in English
  13. Katto

    Translate word document using VBA

    I would like to translate a section of a word document using VBA. Is this possible? Can anybody help with a source code sample? Thank you

Part and Inventory Search

Back
Top