app

Hi Team We currently have large files that we share with a team of about 100 users around the country. Not everyone will be using it at the same time. the spreadsheets have filters. For the desktop users, we get a prompt that says "Others are also making changes" and gives the user option to...

Is it possible to launch a windows store app from excel VBA? I'm trying to launch the alarm and clock app to use the timer when clicked from a button in Excel. The run command to launch the app is "explorer.exe shell:Appsfolder\Microsoft.WindowsAlarms_8wekyb3d8bbwe!App". I don't know how to go...

Hello All I want to open an application with any code in attached and want to send these number one by one through that application! That application is bushbullet, which linked with my mobile msg box! https://www.pushbullet.com/ for more understanding! When I hit button in sheet that call...

Hi All, Could anyone please point me in the right direction as to how to change a workbook I have into a mobile app. The workbook has 14 worksheets within it and loads of vba. I have it on OneDrive at the moment as their are numerous users all at the same time. I wish to make this more user...

After troubleshooting why my Excel 2007 seemed to be unnaturally sluggish, especially with copy/paste functions, I traced the problem to Microsoft's "Mouse Without Borders" app (which lets you share a single mouse/keyboard with two different computers, and glide from one desktop onto the other...

Good day, I've having trouble transposing a bunch of XML bracket data horizontally. Data is like so <tbody> App a b c d /App App a c d e f /App </tbody> I need it to look like this <tbody> App a b c d /App App a c d e f /App </tbody>...

Hi, I'm working with several freelancers to develop a simple excel based inventory system with fingerprint authentication. The general workflow of this app is : 1. Assuming there are 3 shifts per day, A, B, C 2. Employee A inputs data for Shift A in Sheet A 3. When changing shifts from Shift A...

I have a code set to run when any workbook opens. It's set on Personal>ThisWorkbook. Works flawlessly until there's any kind of error and then I have to close and reopen the Excel app to get it to work again. Is there another way to reset without restarting the app? Thanks!

I'm looking to see if there's a formula that solves the problem below. In column A, I have a series of application I.D.s; some can appear once, some twice, some three times etc...there is no way of knowing in advance how many times an application I.D. will appear. In column B, I have a...

Hi All I have just discovered this add in app - very excited, but confused. In need to create a heat map of data relating to wards/postcodes within a UK local authority; I understand the concept, but has anyone else managed to do this successfully using this app in Excel? If so maybe we...

Is there a workaround for entering Time and Date stamps in an app where there are no command keys, like Alt or Ctrl. Or must all entries be made manually?

Hi, I have a VBA program to mark the application no which is generated sequentially. There are multiple worksheets for different types of application. The workbook is shared to be updated by a group of people. The sequential no is a counter stored in one of the worksheet, counting no of...

Hello, I have a spreadsheet that has multiple columns of data. I need a macro that will prompt the user to select a row, then concatenate the info into another cell. The point of this is so the data can be copied, and pasted into a label maker. This label printer only prints from its...

I have this Public colnum As Long Sub Callcolnum() colnum = Round((Date - DateValue("12/20/2017")) / 7, 0) MsgBox colnum End Sub in a modole renamed to COLNUMDECLARATIONCODE and this Private Sub Workbook_Open() Callcolnum at the beginning of ThisWorkbook code. Everything works fine - until...

Hi all, When I create a calculated field in Microsoft Power Query feature ("Get and Transform" since Excel 2016) I use a combination two simple formulae: Value.Divide() and Value.Add(). For some reason, this does not work and all I get is null values. Here is the series of steps that I...

Hi I went to start menu and opened excel. It would open with workbook1.xlsx. How can I close workbook1 without closing the app itself. I do not have that option. If I click on X that would close all the apps. If i go to File->close that would close everything. Any idea please? I want to see what...

Hi experts I am new to vba and looking for a way to modify data in a large file (extract below) as explained below. <tbody> Record ref Date created Type Stage Status Department Client Cost Price AAM000001 01/04/2015 APP Closed - Funded Application v1 - Approved CEEEE FUN00023 487,993.00...

Hello - I have an Excel/VBA app that consistently hangs up for 30-60 seconds when I tab past the last unlocked cell on the sheet. Here are some of the details: - the behaviour is consistent; when the sheet is locked there are a few unlocked cells for data entry that I can tab through. when I...

I need a solution to merge 2 PDFs that is in each subfolder in a single PDF/A file (vba or script). Any way to do that within Word/Excel VBA? If not, there's another app that do this? Thanks

I’m looking to do some conditional formatting on the excel app for iPad Pro as in being able to autocapitalize and change fill color based on what letter is typed in to given cells. Is that possible on the app for excel? Does that require an Office 365 subscription? Any help would be...