app

  1. M

    Excel Time Keeping "Application"

    I have an Excel based time keeping application that allows the user to record the tasks that they work on regularly, that I'd like to share. In a nutshell, it pops up a selection menu of those tasks every 15 minutes (or a time period of your choosing) at which time you would select the task or...
  2. M

    "Others are also making changes" prompt in iphone 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...
  3. R

    Launch windows store app from Excel VB

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

    SMS with App

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

    Turn a workbook with macros/vba coding into a mobile app

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

    Mouse Without Borders -- causing bad Excel Lag, esp w/ copy-paste

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

    Have trouble transposing XML Data

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

    Possibility of calling external Fingerprint program

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

    Resetting workbookopen code after error

    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!
  10. D

    Unique Values and Dependents

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

    Heat Map Add In for use in the UK

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

    Initiating Date and Time Stamp entries in an XL phone app

    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?
  13. L

    VBA - allow concurrent change for shared workbook

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

    popup to select row, then concatenate

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

    Keeping a Public variable always available

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

    Power Query added column - Value.Divide(Value.Add( )) returns all null values

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

    opening excel as an app - without workbook(s) - excel 2013

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

    Removing conditional duplicate rows using comparative data from multiple columns

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

    Excel/VBA app hangs up temporarily when tabbing past last unlocked cell

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

    Merge multiple PDF files

    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

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