local

  1. T

    VBA Get File Path of Active Workbook as String without a URL

    When I use ThisWorkbook.path I get back a URL (https://...) instead of a file path (C:\...). How do I use VBA to get the local file path? For context, the workbook I'm using is saved in my OneDrive folder.
  2. leopardhawk

    Get External Data (long shot question!)

    This is likely a long shot but I am wondering if it is at all possible for Excel to somehow 'change' the contents of a URL that is being linked to by 'Get External Data' every year on January 1 at 00:01 local time? The following URL is currently in use on a worksheet within my workbook...
  3. P

    OUTLOOK VBA to download attachment/s to LOCAL ZIP folder

    Hi All, Hoping someone can help me out? I'm trying to download all attachments from an open Outlook email to a zip file, name of my choice, to a local folder. There's no record function on outlook and i cant compile from scratch. I can only find stuff about downloading all attachments in an...
  4. S

    [VBA HELP] Copy Data.

    Hi everyone, I need help on VBA code to copy and merge data from 2 pivot tables into a single data set to be display in another sheet. Below is data Sheet 1 in excel. <tbody> Pivot A Shipto Soldto LV1 LV2 LV3 001 A Local NE Manufacturer 002 B Local NE Manufacturer 003 C Global CE...
  5. S

    Copy Data from 2 pivot table and make a new data set......

    Hi, I need help on VBA code to copy and merge data from 2 pivot tables into a single data set to be display in another sheet. Below is data Sheet 1 in excel. <colgroup><col span="2"><col><col><col></colgroup><tbody> Pivot A Shipto Soldto LV1 LV2 LV3 001 A Local NE Manufacturer...
  6. rjbinney

    Creating Dynamic Calendar

    I'd like to put together a sheet that builds a calendar using data from a table. AND that "translates" the appointment time into whatever local time zone the reader selects. (I'm happy to hard-code the options on the main table.) Here's the deal - I will be traveling in one country while my...
  7. S

    powershell for local parameters?

    Can vba change my local IP from 10.0.0.2 (Cell A1) to 10.0.0.5 (cell A2) or set it to a dynamic ip (versus static)?
  8. J

    2 lookups

    Hi, Does anyone know a formula that match Client ID & weight and return correct Weight Range? <tbody> Client ID Weight Weight Range Home 21.05 ?? Local 28.50 ?? Weight Range Lower Weight Range Upper Client ID Weight Range 1.0000 26.9900 Local Up to 27kg 22.9901 42.9900...
  9. A

    Trigger event based on local maxima and minima

    Hi, I want to trigger an event based on two conditions: at a fixed percentage of a data value of a local maxima, after a local maxima occurs in the data, to turn the event on. Alternatively, at fixed a percentage of the data value where a local minima occurs, to turn the event off. Data values...
  10. M

    Rag rating

    Afternoon... After some excel related inspiration if anyone is feeling in a giving mood? I need to RAG rate individual cells containing a list of people, places, processes and plans and this needs to be done/displayed in a visually pleasing way as this will be displayed in offices across the...
  11. Anne Troy

    Office 365: Online -vs- Local

    How can I tell -- by talking to someone over the phone -- if they have a local install of Excel? I've sent 2 people a macro file and the macros don't work. I believe they're using the online version, but I don't know REALLY how to tell (save a copy seems to be one way?). And then, I helped one...
  12. S

    Linking O365 to local excel files

    Hi all I'm looking at building a dashboard in O365 using the snazzy dynamic array formulas that I've been reading about, but I'm running into a theoretical hitch with how to accomplish something. I can schedule exports from our database to run automagically and save csvs with the data...
  13. T

    GMT/UTC to local time conversion

    Hi guys, I'm trying to convert from GMT time to local time. I have the a column where my data has the format: 19-01-2019,07:20:23 I applied the formula: =A2-(5/24) to calculate the local time but i got the error: There's something wrong with the way your formula is typed. Or, there's...
  14. S

    VLOOKUP and return string + INDIRECT relative to where initial VLOOKUP runs

    I have a table that looks like this: <tbody> refrigerator =vlookup(randbetween(1,4),worksheet!$A1:$B4,2,false) </tbody> The vlookup where it's seeking (worksheet!$A1:$B4) this looks like: <tbody> 1 "Buy a "&INDIRECT(ADDRESS(ROW(),COLUMN()-1))&" from us" 2 "Everything we sell is great"...
  15. J

    Map drive to a local folder using vba

    Hi all, I've done a fair amount of searching and trying different methods myself; however, I am unable to map a drive letter to a local folder on my machine. This thread shows how to map to a network drive, and it works well for actual network locations...
  16. S

    How to apply vlookup with 2 different condition and files

    I want to bring cost of the product based on local and imported files please help me to apply vlookup. Summary Code No. Cost. A 40 B 50 C 60 D 70 Local Code No. Cost A...
  17. U

    I need a way to copy every file from a server's url to my C drive using VBA

    Our network has become very slow so I need to work with local files and I cannot trust the user to copy the files. The server is a SharePoint server and the url starts with "\\sps.global." FileCopy doesn't work so has anyone got a solution that will work? I have looked for hours and tried...
  18. O

    Index/ Match/ Lookup

    Hi All, Thank you for viewing my post. I am having difficulty with the index/match function. Below is an extract of my table (I had issues uploading the table via the normal channels). <tbody> A B C D E F G 1 Local code Age Universal Code Local Code Age Boundary Universal Code 2 TUCEG...
  19. G

    Linking Excel Worksheet and chart from Cloud

    Hello, I'm trying to find a way to have a PowerPoint slide contain a linked Excel Worksheet that is housed on the cloud so that we (team of peers) no longer have to send the worksheet in tow with the presentation every time we email it. I accessed my O365 One Drive acct. which my company...
  20. Patcheen

    if and function

    im using this formula to give me whats in fixtures and results I4 but it says You've entered too many arguments for this function =IF(AND('Fixtures and Results'!A4=local!A6,'Fixtures and Results'!c4=local!b6),'Fixtures and Results'!F4,local!A101,'Fixtures and Results'!I4,"") do i need to...

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