+ Reply to Thread
Results 1 to 5 of 5

Is there a shorcut to save a document by dragging it into an opened folder

  1. #1
    Forum Contributor
    Join Date
    01-08-2013
    Location
    ankara
    MS-Off Ver
    Excel 2010
    Posts
    126

    Is there a shorcut to save a document by dragging it into an opened folder

    Hello everyone one,
    I use windows.
    Suppose I worked on a excel file and want to save that file into a folder that is already opened.
    Normally, I use save button and from the opened menu, I try to find the location of the opened folder. Sometimes, it may take a long time to find the location. I can copy and paste the location of the folder from address bar. I know it. However, is there a way to drag my file onto the folder and solve it quickly?

    I find that mac has a closer dragging method:
    https://www.youtube.com/watch?v=3hZ0jiujD4g
    06:49 7. Drag Folders To Save Dialog

    thanks in advance

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,438

    Re: Is there a shorcut to save a document by dragging it into an opened folder

    This might work for you. I don't use mapped drives. Instead, I create shortcuts. They are easy to create: go to the directory to which you want to make a shortcut. Click in the navigation bar. This should show you the real pathname to the folder. Copy this path name (CTRL-C) then right click on the desktop and select New > Shortcut. Paste the path name into the destination box (CTRL-V). Give it a descriptive name. You now have a shortcut on your desktop.

    I suggest making a copy of the shortcut in My Documents as well. Many applications default to this directory when you save files. I name my shortcuts with a caret symbol (^) in front of them such as ^S Shortage Report. The caret moves it up in the directory listing.

    There is also a program called free launch bar. It's a good place to organize the clutter that would normally be on your desktop. It's free, one of the "folders" or "menus" I have on it contains all the shortcuts I've made. So in two clicks, I can open any folder I want.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Forum Contributor
    Join Date
    01-08-2013
    Location
    ankara
    MS-Off Ver
    Excel 2010
    Posts
    126

    Re: Is there a shorcut to save a document by dragging it into an opened folder

    Thank you very much. I loved your suggestions. That's good for constant folders. However, I want a way for my workplace. In my work, there are autocreated folders in network with many subfolders and each day newly created folders are added that I need to work on.

    You know, sometimes you spend too much time on a routine operation and then one of your friend shows you the shortcut, you say "wooow, amazing..!". So I give a shot to my problem

    For example, a few days ago one of my friend told me that when you want to copy an excel sheet into the same file, you just need to hold ctrl button and drag it to right. I said "You are king"

  4. #4
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,438

    Re: Is there a shorcut to save a document by dragging it into an opened folder

    Maybe the attached will help.

    I manage my monthly memos in My Documents\Memos\YYYY\MM MMMM format. For example, currently I am working in: MyDocuments\Memos\2022\11 Nov.

    I run this on the first of every month. The utility figures out what year and month it is and creates the directory and two shortcuts to it: one for the quick launch (Free Launch Bar) and one in My Documents since that's where many of the downloads for applications want to download their data by default.

    I even associate an Icon with it.

    If the directories to which you are trying to make a shortcut are predictable, then perhaps you can modify this code to meet your needs.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    01-08-2013
    Location
    ankara
    MS-Off Ver
    Excel 2010
    Posts
    126

    Re: Is there a shorcut to save a document by dragging it into an opened folder

    Ty Mr. Flak. Actually, I can use this file because for my another work, I upload a file from the recent folder to a webpage for e-signature and move it to archeive. So, each time my web browser looks to my documents folder. There I can add your code to the bottom of my macro so that I can modify a shortcut to my recent file to upload. That's a very nice idea and lowers my probability to misupload another file.

+ 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. VBA to create folder frim Excell and save Word document in that folder
    By dzagorac in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-25-2021, 07:32 AM
  2. [SOLVED] VBA save document as PDF in folder and attached to an outlook email
    By Danny1986 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-19-2020, 10:38 AM
  3. [SOLVED] Macro to open files in folder and Save As if any bold, italics or underline in document
    By shaspos60 in forum Word Programming / VBA / Macros
    Replies: 7
    Last Post: 02-08-2018, 01:11 AM
  4. Macro to print and save a document to specific folder with unique number
    By kasenga in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-16-2014, 09:59 AM
  5. Trying to save a Mail Merge word Document to a specific folder
    By jtemp57 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-19-2014, 06:56 PM
  6. VBA: Save workbook in same folder where it is opened.
    By sroysroy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-09-2013, 11:51 PM
  7. How to save the opened word document as a Notepad/text file?
    By Rahul888 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-10-2012, 05:38 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