in
All Tags » VBA » from (RSS)

Browse by Tags

  • VBA VLOOKUP from Another Workbook

    I have two open workbooks; Book1 and Book2 Book2 has a lookup table on sheet1 I want to run code from book1 that will pick up a value from cell A1 and then lookup from sheet1 in book2 that value and return into B1 what is in column 2 The code I have tried is [B1] = Application.VLookup(Range("A1"...
    Posted to Excel (Forum) by microsoft on 03-06-2010

  • VBA Code to create PDF from XLS

    Can someone please provide VBA code to create a PDF from XLS with the file name automatically taken from a cell value without any dialog pop ups, so fully automatic? I have surfed and tried so numerous different codes and nothing works. I have Acrobat Distiller 8 and Acrobat 8 Professional installed...
    Posted to Excel (Forum) by microsoft on 08-16-2009

  • Get Time zone from System settings

    How to get the system time zone settings from VBA to be used in calculating the GMT.
    Posted to Access (Forum) by microsoft on 07-20-2009

  • Run Batch File From VBA

    Hello all.. I have been searching the net and trying various solutions to run a batch file from within Access 2000 on an XP machine. The most common answer i come across is to use the shell command as in: call Shell ( Environ$ ( "COMSPEC" ) & " /c c:\test.bat", vbNormalFocus)...
    Posted to Access (Forum) by microsoft on 07-16-2009

  • run vba from command prompt

    hi, i have written a vba script in microsoft access 2000. I want to run this from the command prompt. I need to do so to make a *.bat file. Is it possible to do so? If so, how? thanks sanjana
    Posted to Access (Forum) by microsoft on 07-14-2009

  • vba Form Image, get picture from clipboard

    Hello Experts, I have a userform in word, i would like to change the image1 picture to the picture placed on the clipboard. The picture i want to insert is a table within the document. If it is not possible to use the clipboard directly, i would like to copy the table and save it as an image in a tempory...
    Posted to Microsoft Office (Forum) by microsoft on 07-09-2009

  • Call function in Input Parameters string

    From VBA help, If ound this example on how to pass a value from a control or prompt for a value. @state char=[Form]![StateList], @salesyear smallint=[Enter year of interest] My question is can the refernece to the control [Form]![StateList] be repleaced with a call to a vba fucntion in a code module...
    Posted to Access (Forum) by microsoft on 07-03-2009

  • POWERPOINT: Using VBA to insert slides from file

    Hi I'd like to be able to insert slides from files using vba (in much the same way you would insert a file using Insert | Slides From Files |Browse from the drop down menu. I'd like to be able to run this from Access which has a list of ppt file names. Essentially, what happens is: 1> I build...
    Posted to Microsoft Office (Forum) by microsoft on 07-02-2009

  • Stop form from scrolling on load

    I have an application that consists of several forms. When some of the forms load, the Detail section scrolls down so the information on the top of the Detail section is not visible. I would like the scroll bar to be reset automatically in the topmost position. Is this possible in VBA?
    Posted to Access (Forum) by microsoft on 06-30-2009

  • Create excel spreadsheet from access vba

    Hi All, I need to create a spreadsheet from access from an sql string or recordset in vba. The spreadsheet should look like: (Name Column) | Name DoB Address ( F Bloggs 05/12/76 Here J Smith 10/06/53 There I need to create the spreadsheet with the header row and name column (as shown above) as protected...
    Posted to Access (Forum) by microsoft on 06-26-2009
Page 1 of 2 (15 items) 1 2 Next >