drive

  1. P

    Upload file to Google Drive

    Can someone point me to code that uploads a file to Google Drive? I have many metrics that we want to automatically post to the cloud.
  2. Johnny Thunder

    Anyone have a link to the Excel Jeanie or a Copy of the Download Files in English?

    I am currently using the German version and it works great but I always end up having to retranslate alot of the text when it generates HTML code. I can setup a Google Drive Folder for the files to be placed inside for other users if someone has it? Please let me know, thanks!
  3. P

    Find drive letter of a mapped drive

    Hi, I know there is a way to do this, can't find it in the forums. Basically, everywhere at work is mapped to the same network drive, but it isn't dictated which letter they have used. So, for example, my V:\ drive may be the same as someone else's S:\ drive. I need code to check all mapped...
  4. MPG Radio

    External Directory Listing

    I am new and was not able to find something specific. We have an external drive, this drive has folders, in those folders there are more folders, in the folders are videos of various formats. Im looking to list the top level folder name and below that list the names of the files. In excel...
  5. A

    Date from query not recognized

    Hi everyone, I hope you'd be able to help me with an issue I have been struggling for over 1 hour now and can't figure out a solution. So I have added a CSV query from a folder on my drive that has a date in this format: DD/MM/YYYY, but when I run the query and want to convert the date to week...
  6. P

    Frequency of unique values based on a single criteria

    Hi there, I am trying to find the number of non-repeated (unique/frequency) family names in each grade. I have prepared a sample and uploaded to one drive. I would appreciate it if someone could help? https://1drv.ms/x/s!AgQdYsSdg735fXy_R4rJuVlmcuw
  7. D

    Excel search engine

    How to create a vb script in excel wherein i can type a word and/or numbers and it will search all the cells in excel files in the entire shared drive that contains the word/numbers and returns the filename hyperlink on a different sheet? Preferably wildcard search. Thank you.
  8. V

    Using vlookup function in a table

    I have 'inherited' a spreadsheet that has a vlookup in a table that refers to a table in another file. It won't work. Any suggestions?.. I have tried making sure the files are both in the same e-folder on my c drive. I am lost for ideas. I am new to working in tables. would appreciate any...
  9. M

    Network path in footer

    I know how to get the file path in the footer by using &[Path] but I was wondering how to get the network path. Instead of: S:\share\pathname\ I wanted to get \\server-1\share\pathname\ because different people's S drive would be mapped to a different server depending on where they are...
  10. 1

    Macro to grab data from file located on sharepoint

    I need some help with a macro here. Currently I have a workbook that will copy data from several workbooks on a shared drive. The macro works fine, however it is designed for multiple units to utilize, so therefore I use some array formulas which really slow things down. What I would like to...
  11. 4

    Complex Combinatorial sort VBA/Macro

    Hi everyone, I have a tricky task :) Let me clarify that step by step below. Input table with 5 columns columns are: combination, place1, place2, place3, income column combination represents a number of each combination (combination of 3 places) place1, 2, 3 are basically points where a car...
  12. E

    Share user form on One Drive?

    Is it possible? thanks.
  13. P

    How to find the earliest and latest date when multiple criteria is met.

    Hi, Please help. I have a sheet of data that is outputted from an external source, see below: <tbody> Vehicle Reg AxleType Axle Position Dimension New/Retread Brand Pattern Event Mileage OTD Date RTD Removal Regrooved abc123 Drive 3 L 295/80R22.5 New GOODYEAR KMAX Fitment 10 24 1.1.2016 24...
  14. R

    Broadcasting Spreadsheet

    I call the local high school games on the radio and want my stat guy to have an excel sheet where he can type on the D&D, the YL, Player # and gain/loss yardage. When he enters that information I want to have the D&D & YL calculated for the next play depending on the result of the play prior. Is...
  15. M

    Need my Personal.xlsb saved on a network drive instead of c:\\XLSTART - Possible?

    Need my Personal.xlsb saved on my network drive as we are required to use network drives for all files. I tried moving my file but it does not show up under View Macros. Is this possible?
  16. H

    Macro for hiding rows and columns based on selection in drop down list

    Hi, I need help with the macro vba coding.... My tab in the workbook is titled "Worksheet" In cell A9, I have data validation set up where the user can select from a drop down list that has 4 values (Box, Bag, Ramp, Drive, null value) If the user selects Box or the value is null in cell...
  17. P

    Establish Connection to Network Drive (not mapped)

    Good evening, Please can someone help with this. I have a macro workbook that accesses a SharePoint folder to import some modules. This works perfectly well if the user has mapped the SharePoint drive to their computer (I guess because Windows establishes a connection to this drive when...
  18. W

    Excel VBA Connection With Google Drive

    Hellow Experts, Please kindly guide if there is some way that we can upload file to Google Drive Directly like CDO email. Regards,
  19. A

    VBA to refresh data links / 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...
  20. A

    Remove Read Only Vba file

    hi all, when i opened my vba file on Windows Drive , its opened in Read-only. but other Drive its opened without any problem, how can i open vba file without Readonly on windows Drive??? thanks in advanced.

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