drive

  1. A

    **VBA** Refresh data linked / connected to another workbook via shared network drive

    Hi, My workbook relies on values from other 5 workbooks saved on a network drive. The issue is that when someone tries to use the same workbook, they will need to go an update each link as the mapping drive letter varies between us. Therefore, I would like to add the ability to replace drive...
  2. L

    Button OnAction Macro Assignment "drive" letter getting reassigned

    Hello, I can't find any topics on this issue. I create a button using vba and assign a macro using onaction. .OnAction = "'c:\data\macro.xla'!copy" The macro continues and saves the file to c:\data\temp\ Everything works fine with the button at this point. I can also saveas to a different...
  3. A

    Find Subfolder file path

    I need code that searches through all sub folders in the C drive and when it it matches to a specified file it returns the file path. Any suggestions?
  4. B

    Error; "The Workbook you opened contains automatic links to information in another workbook"

    Working from a 2015 macbook pro, excel 2011, a file I use daily suddenly gave me an error I recall having seen some years ago, but can't remember how it was resolved; "The Workbook you opened contains automatic links to information in another workbook". I don't recall copying/pasting to/from...
  5. maheshmaxi

    Edit Excel file stored in Google Drive using MS Office - Excel 2016 application

    Hi, I am trying to edit an excel file stored in Google Drive using MS Office Excel 2016. Even after i installed "driveforoffice.exe" plugin, i am able to browse/access the file using following 2 methods in MS Office Excel 2016, but still when i click on "Select" button, the files is opened in...
  6. A

    Saving file on a network drive where the drive letter varies between users

    This is the code I have but it really only works when the user has the L: drive which is not always the case. How do I save a file when I users all have different drive letters? Also why doesn't my error handling work? I feel like I don't fully understand how to structure the error handling. All...
  7. P

    Excel spreadsheet double saving

    I have a spreadsheet with numerous macros that seems to be doing two saves when I click to save the file to a shared drive .... G: drive at my workplace. On clicking to save to the shared drive (G: drive), I get the usual swirling hourglass for about 6 to 10 seconds ... this is what I have...
  8. S

    GetSaveAsFilename() ALWAYS opens in My Documents even with ChDirNet()

    Hi Everyone, I have a problem with getting GetSaveAsFileName() function to open Save dialogue box in a Network drive instead of always opening in my documents. Basically, I have implemented a workaround to change path to a network drive via: Top of my working module: Private Declare Function...
  9. S

    Share a locked down pw protected Excel model

    I need to share a complex model with potential clients while at the same time keeping it secure. I've been using the excellent program XLS Padlock, but now many IT departments are blocking all .exe files (even camouflaged ones) via download or even usb drive. Short of mailing the client a...
  10. D

    Read Only Format Cannot Be Fixed?

    I use several Excel spreadsheets. I am running WIN 10. About a week ago, all of my Excel spreadsheets opened in READ ONLY format, including archived documents, new documents, and templates that I re-use frequently. I tried re-naming, save as, changing settings, etc., and other suggestions...
  11. M

    VBA - help, from Another workbook.

    Hi Team, I want to apply vlook up in workbook (1) which i opened it from D drive. And my data is in workbook 2. (E dRIVE) in sheet1 (column A Only) In workbook 1 under sheets (1,2,5) in column b of each sheet , I want to apply vlookup formula and drag the formula till last row of Column A...
  12. G

    Check if USB drive of path is present

    [CODE]Hi Excel guru’s: I need a revision on the Macro below. I need to check if drive or path is present so that it will not create an error. Maybe a message like “ Please insert a USB in the drive” something like that. It creates an error if the USB drive is not inserted on the slot. Thank...
  13. R

    Macro works fine on local drive, will not work on network drive?

    I have a workbook (located on my local drive) with a rather simple macro setup that unlocks a sheet upon the workbook opening, refreshes the data, then locks the sheet again. The sheet it unlocks is called "SignSheet" and it refreshes the data from a workbook called "signsheet" on another...
  14. K

    Convert network UNC file path to the local drive reference path

    I am referencing files from a network drive, however it may be mapped as different letter drives on different users computers e.g. L:\ or R:\. Is there a way of finding what the drive has been mapped as on the users pc using the UNC file path e.g. \\server\folder\folder\file.xlsm Ideally I...
  15. P

    Change drives and change directories

    Hi, I need to write code such that when the workbook is opened at any location (can be up to 14,000 stores) I can open a directory on a virtual drive R (which is localized to that location) to access folders located there and pull data. Currently, I inherited a file that says this, but I...
  16. A

    Login to network drive help

    Hi all, I'm trying to create a macro, that would map a network drive to a letter, login, and post some files there. I have been able to accomplish all but the login part, which is a bit of a pain... Below is what I've got so far: Sub MapDrive() ' =================== MAP DRIVE Z...
  17. L

    Connection with Path instead of Drive letter?

    Hi, I have some code which creates a connection to a folder at a path I specify in a cell, but I'd like to be able to have others use it on the network drive. The issue is that not everyone has the same Drive letter that I have. I've tried the fix I usually use, but it did not work. How...
  18. M

    Update Properties values in Explorer

    Hi: I need to figure out the VBA---either run by a Word or Excel macro, it doesn't matter---that cycles through all PowerPoint, Excel, and Word documents in a folder and then updates the following property fields: Title, Subject, Author, Category, and Keywords. I can use Application.InputBox to...
  19. L

    Help Excel Macro needs to reference file on network drive multiple users

    Hi, I have a macro that does a lookup from a file that is in a central network drive. There are multiple users who use the macro. I have shared the file so that everyone can be in it at once so the macro can do the lookups. The issue is that the users have the drive where the lookup file is...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top