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...

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...

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?

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...

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...

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...

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...

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...

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...

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...

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...

[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...

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...

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...

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...

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...

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...

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...

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...