local

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.

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

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

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

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

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

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)?

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

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

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

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

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

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

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

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

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

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

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

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

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