Results 1 to 2 of 2

open images with microsoft office picture manager from macros

Threaded View

  1. #1
    Registered User
    Join Date
    06-27-2013
    Location
    jakarta
    MS-Off Ver
    Excel 2003
    Posts
    5

    Red face open images with microsoft office picture manager from macros

    dear all,
    I have macros code below

    Sub openfile()
    Dim sSrcFolder As String, sFilename As String Dim c As Range, rPatterns As Range
    sSrcFolder = Range("F1")
    Set rPatterns = ActiveCell.Offset(0, 0)
    For Each c In rPatterns
    sFilename = Dir(sSrcFolder & "*" & c.Text & "*")
    If sFilename = "" Then MsgBox ("Data not found")
    If sFilename <> "" Then*** Do While sFilename <> ""
    Shell "ois.exe sSrcFolder & sFilename "
    sFilename = Dir()
    Loop
    End If
    Next
    end sub

    I want open file with clue at range a1, but the code not work.
    please help to fix my code.
    thx
    Last edited by superbeltsazar; 10-07-2013 at 12:14 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 03-09-2013, 04:30 AM
  2. Adding Text to another cell VB code (Help Tweeking code) (Excel 2007)
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-06-2012, 11:37 AM
  3. Code for email alerts from excel isn't working, wrong code possibly?
    By jessthorogood in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-27-2012, 01:45 AM
  4. Replies: 2
    Last Post: 03-17-2011, 08:55 PM
  5. Replies: 0
    Last Post: 10-06-2006, 09:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1