+ Reply to Thread
Results 1 to 6 of 6

Make Folder on Desktop

  1. 05-15-2009, 04:08 PM #1
    realniceguy5000
    realniceguy5000 is offline
    Valued Forum Contributor realniceguy5000's Avatar
    Join Date
    03-20-2008
    Location
    Fl
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    951

    Make Folder on Desktop

    Hi,

    I'm trying to create a folder on the desktop and save the activeworkbook in that folder. Since other users will use this I dont know the exact path. However I'm using this function below to tell the script where to find the path. Everything was working fine till I started to make the folder can someone point out what I may be doing wrong?

    Thank You, Mike

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Last edited by realniceguy5000; 05-18-2009 at 08:07 AM.
    Reply With QuoteRegister To Reply
  2. 05-15-2009, 04:16 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Make Folder on Desktop

    Put Option Explicit at the top of your module and try again.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 05-15-2009, 04:20 PM #3
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Make Folder on Desktop 

    Please Login or Register  to view this content.
    Last edited by shg; 05-15-2009 at 04:32 PM.
    Reply With QuoteRegister To Reply
  4. 05-15-2009, 04:28 PM #4
    realniceguy5000
    realniceguy5000 is offline
    Valued Forum Contributor realniceguy5000's Avatar
    Join Date
    03-20-2008
    Location
    Fl
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    951

    Re: Make Folder on Desktop

    Quote Originally Posted by shg View Post
    Put Option Explicit at the top of your module and try again.
    My bad on that I did say I was going to start using that...about 20 post ago...:-(

    I'll try to get this going over the weekend

    Thank You Shg

    Mike
    Reply With QuoteRegister To Reply
  5. 05-15-2009, 11:15 PM #5
    Kenneth Hobson
    Kenneth Hobson is offline
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: Make Folder on Desktop 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 05-18-2009, 08:07 AM #6
    realniceguy5000
    realniceguy5000 is offline
    Valued Forum Contributor realniceguy5000's Avatar
    Join Date
    03-20-2008
    Location
    Fl
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    951

    Re: Make Folder on Desktop

    Working Now.

    Thanks for the hint Shg. I was able to debug and correct.

    Ken your code worked as is.

    Thank You Both...

    Mike
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1