+ Reply to Thread
Results 1 to 2 of 2

Opening a folder created on FTP server

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Hollidaysburg, Pa
    MS-Off Ver
    Excel 2010
    Posts
    398

    Opening a folder created on FTP server

    Hello,

    I have been using the following code to open a folder I just created

    to create a folder

      MkDir ("C:\Subbby\SubbbyDance" & "\" & Cells(iRow, sSerialNumberCOLUMN))
             Shell "C:\Subbby\SubbbyDance" & "\" & Cells(iRow, sSerialNumberCOLUMN)
    To open this folder

        Shell "C:\Subby\Subby Dance "
    source : Post # 2 on http://www.excelforum.com/excel-prog...he-folder.html

    When I try to edit the link and put a FTP link. It does create the folder on the ftp server on the desired root folder but doesn't open this folder . It opens "My documents" instead. How do i fix this?



    The code I replaced was

    "\\MCLFTP\ftproot\Dummy\Global\"

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    6,007

    Re: Opening a folder created on FTP server

    You forgot to include the program to use in the Shell command. Try:

    Shell "C:\WINDOWS\explorer.exe ""C:\Subbby\SubbbyDance\" & Cells(iRow, sSerialNumberCOLUMN).Value, vbNormalFocus
    Note that

    "C:\Subbby\SubbbyDance" & "\" & ....

    is the same as

    "C:\Subbby\SubbbyDance\" & .....
    Bernie Deitrick
    Excel MVP 2000-2010

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Removing On Opening Server Check VBA
    By kiktuo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-07-2015, 11:01 AM
  2. [SOLVED] Specific folder when opening windows popup folder selection with msoFileDialogFolderPicker
    By trizzo in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-18-2015, 11:05 AM
  3. new folder creation and moving of photos into that created folder on different drive
    By meer_ali in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-20-2014, 02:29 AM
  4. [SOLVED] Need help opening a newly created folder and placing files into it
    By gleppelman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-13-2013, 04:24 PM
  5. opening csv from ftp-server sometimes causes error message
    By jymatthiasg in forum Excel General
    Replies: 0
    Last Post: 09-17-2008, 06:37 AM
  6. [SOLVED] Error when opening recordset of SQL Server via ADO
    By Glenn Ray in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-02-2005, 06:05 PM
  7. Data from Programmatically created Excel into SQL Server
    By Raj in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-20-2005, 06:06 PM

Tags for this Thread

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