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 dencom 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 rj771972

  1. rj771972

    Powerpoint add slide

    Hello, I notice that when I use the code below, a slide is added BEFORE the current slide rather than AFTER. Not sure why Dim oPPt Dim oPPs Dim ObjSlide Dim ObjShape Dim objWnd Dim ObjImage Const ppLayoutText = 12 Set oPPt = CreateObject("PowerPoint.Application") Set oPPs =...
  2. rj771972

    VBA TO VBSCRIPT

    thanks, will try
  3. rj771972

    VBA TO VBSCRIPT

    here is another one. This time VBSCRIPT for powerpoint: the line .Shapes.AddTextbox does not work Dim applPP Dim prsntPP Dim slidePP Dim shapePP Dim shpCurrShape Dim slideCount Dim oPicture Dim ppPath, ppName Set applPP = CreateObject("PowerPoint.Application") 'applPP.Visible =...
  4. rj771972

    VBA TO VBSCRIPT

    thank, you are right any chance you have the codes for xlDown? Can you share any reference link? Thank you
  5. rj771972

    VBA TO VBSCRIPT

    Thanks! it works now!
  6. rj771972

    VBA TO VBSCRIPT

    Thanks, but I'm afraid it still does not work. It calls for a problem in the last line first column. please see attached error message Dim objExcel, strExcelPath, objSheet ' You need to create the Example.xls file first. strExcelPath = "C:\tmp\test.xlsx" ' Open specified spreadsheet and...
  7. rj771972

    VBA TO VBSCRIPT

    I have this code bits that work in VBA and I need the VBScript version. All I am trying to do, is get the latest column number of row 1 and the last row of column 15 Last two lines do not work. Any ideas? Dim objExcel, strExcelPath, objSheet strExcelPath = "C:\tmp\test.xlsx" Set objExcel =...
  8. rj771972

    does moving files change sime BuiltinDocumentProperties?

    Hello, In windows 7 or 10, when I move files, the "Created Date" and "Last Modified Date" seem to be changed. Q1: is this always true? Q2: if the answer to Q1 is Yes, is there a workaround to preserve these properties? Thank you
  9. rj771972

    unable to detect undefined names

    Hello, I have this simple code ======== code starts ================ import sys from magot import * B=MILS2MM print(B) ======== code ends ================ Where magot.py is the following ======== magot.py starts ================ import math as math def sind(x): return math.sin(x *...
  10. rj771972

    Does cmath operate on arrays?

    Hello, In Matlab I can do in one line: c=a+j*b where j=sqrt(-1) and a,b,c are arrays. Can I do this in python using cmath? Thanks Robert

Part and Inventory Search

Back
Top