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!

Search results for query: *

  • Users: Katto
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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 =...
  4. 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
  5. 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...
  6. Katto

    Get the last filled line in excel

    Hello, I am trying to convert a VBA script to VBS. The script below gives me an error on the line starting with LastRow (invalid or unqualified reference). Not sure how to fix this. Thanks SPATH = "Z:\MyNetworkScriptsNew\Simulation_Journal\" strExcelPath = SPATH +...
  7. Katto

    vbs script to read a mixed variable file

    Hello, I need to read a list of 3 columns where column A & C are strings and column B consists of numbers They are comma separated as shown below A,2,C V,3,G U,1,R etc I tried: ========================== while eof(1)=false line input#1,T$ TT=split(T$,",") ========================== and...
  8. Katto

    vba write a dxf file

    I really need a macro that writes a DXF file for ONE polyline. I did read many posts and heavily googled the topic. I also found a AutoCAD DXF format document, but unfortunately I was not yet able to make it on my own. Made a dxf file with one polyline in it and tried to delete the header and...
  9. Katto

    Debug VBS with Microsoft Community Studio 2019

    Hello, I am not sure why it executes the first line and terminates without any errors. Please see snapshot attached. Thank you https://files.engineering.com/getfile.aspx?folder=d4569761-a9b7-4b8f-84fc-b82542c0b5fd&file=vbs_visualstudio2019.JPG
  10. Katto

    vba list all autocad files open

    Hello, I would like to generate in VBA a list of all the AutoCAD files opened (dwg as well as dxf) Any ideas? Thank you
  11. Katto

    Hello, I am trying to migrate fr

    Hello, I am trying to migrate from Microsoft Office to OpenOffice. I am trying to do the following in VBS for the PowerPoint equivalent Impress: open an impress presentation. add a slide add a text on the slide import a picture on the same slide I could not find any relevant information just...
  12. Katto

    script for Norton firewall

    I would like to have a script that creates rules for Norton that would allow me to block/allow an entire folder. I downloaded a program from MajorGeeks that does that for Windows Defender. I have Norton which takes over the Windows Defender, so I would like to apply the rules on Norton. Is this...
  13. Katto

    extract images from Acrobat using VBA

    Hello, I am looking for a VBA code which would allow to extract images from Acrobat and paste them in a PowerPoint presentation. Any ideas? Thank you
  14. Katto

    vlc in vba

    Hello, I am trying to create a VBA project in which I have a VLC object running a stream whose link is listed in an excel sheet. I was not yet able to find a running example online. I found examples for Visual Basic and C but not for VBA. I will not bother you with the cases I tried since...
  15. Katto

    Graphics for Fortran

    Hello, Is there any graphics package that works with Visual Fortran? something less complicated than PGplot. Thanks
  16. Katto

    Compaq (Microsoft) Visual Fortran pro 6.6 - Help problem

    Hello, I guess there used to be a problem with Microsoft MDSN and Visual fortran help file (can't work simultaneously). I understand that somewhere in the Dev Studio you can't change the help file (from MDSN to Visual Fortren) questions: 1. where can I do this change? 2. Was this problem...
  17. Katto

    Compaq (Microsoft) Visual Fortran pro 6.6 - Debug problem

    Hello, I am trying to debug a file, that crashes. When crashes, I get the assembly screen. Q; What do I need to do to get the source screen so I can see where it did crash and check values?
  18. Katto

    export coordinates of a line from Autocad

    Hello, I am (desperately) looking for a lisp routine and/or a VBA program which would allow me to click on a line/polyline/spline and write the coordinates of the end-point on an ascii (text) file. I have used for a long time ASCPOINT (by Tony Dazillo) which does exaclty the opposite and...
  19. Katto

    system questions

    1. I am calling an executable from Fortran using the call system(filename.exe) routine. Is there another function that can wait for the filename.exe to finish before gets to the execution of the next line ? 2. If not, is there a function like "call wait(###)" where ### are time units? at least...

Part and Inventory Search

Back
Top