+ Reply to Thread
Results 1 to 2 of 2

Creating a folder in desktop and inside it, save new workbooks...

  1. #1
    Registered User
    Join Date
    03-07-2014
    Location
    New Jersey
    MS-Off Ver
    Excel 2007
    Posts
    7

    Creating a folder in desktop and inside it, save new workbooks...

    How would I go about doing something like this in VBA?

    Let's say we have an active worksheet containing the following:

    A B
    1 foo1 Hello1
    2 foo2 Hi2

    Given that, I want to be able to create a folder in my desktop called "test" and within that folder create two excel workbooks. The first workbook will be named "foo1" and contains "Hello1" in cell A1, and the second workbook will be named "foo2" and contains "Hi2" in cell A1?

    Thanks!

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,653

    Re: Creating a folder in desktop and inside it, save new workbooks...

    Try this...

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

+ 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. [SOLVED] VBA: Create a new folder on any users desktop and save the file as value in cell (A51)
    By nwb in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-24-2014, 11:02 PM
  2. code for opening all workbooks in a folder on desktop
    By ammartino44 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-21-2014, 04:39 PM
  3. Save as CSV to specific folder on desktop and current date as filename
    By stokiejames09 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-28-2013, 05:52 PM
  4. Replies: 0
    Last Post: 10-10-2012, 03:51 AM
  5. [SOLVED] save as CSV file on desktop but in a 'New folder'
    By mike02 in forum Excel General
    Replies: 6
    Last Post: 08-15-2012, 05:25 PM

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