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 derfloh 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: Katto
  • Order by date
  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

    thanks
  13. 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
  14. 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
  15. Katto

    VBA create link to a module without running it

    There you go!
  16. Katto

    VBA create link to a module without running it

    Thank you. Works great!
  17. Katto

    VBA create link to a module without running it

    Hello, I have an excel file with many macros so I sometimes have to spend too much time finding it. I was able to create a list of the modules on a sheet. Next, I would like to create hyperlinks, so that when I click (or double click) on the cell, it would bring me to the module in the Visual...
  18. Katto

    Get the last filled line in excel

    Oops, sorry, I fixed a typo and now it works. All set, Thank you
  19. Katto

    Get the last filled line in excel

    I was happy too soon I added the line xlUp = -4162 and the LastRow line still gives me an error: Invalid or unqualified reference
  20. Katto

    Get the last filled line in excel

    Great, Thank you all

Part and Inventory Search

Back
Top