application

  1. A

    Application.ScreenUpdating = False issues

    Found this post, ScreenUpdating = False not working, that is having a similar issue to mine. From what I've read this is a common issue with Excel after an update Microsoft did. Below is my code and I cannot figure out how to keep ScreenUpdating set to false. It's not a major issue but the...
  2. S

    Macro/VBA for finding data locations outside Excel

    Hi All, I have here a problem wherein I want to find the location of a certain data with no match outside Excel. Below are reference photo and explanation for clearer description of the problem. Here are the locations of the data that I will be putting in Excel. This is a sample of what's...
  3. M

    Noob Help Please

    I am hoping someone can help. It seems like such an easy thing to do and I just can't find the answer anywhere. So, I would like to search a range of cells F2:F6 (APPLICATION) for the word "Yes" The word will be returned in multiple cells and I would like to copy the B2:B6 corresponding cell...
  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

    Open Another Application by Excel with VBA

    Signal is generated in Excel Either Buy or Sell. The Vba should Open the Another Application Perform Functions Like enter amount, name,.....From Excel Only then Submit and Close. Wait for next Signal and Repeat the same Process Again.:)
  6. Nelson78

    Application.SendKeys "{TAB 2}" does not work

    Hello everybody. I'm a newbie about automating external application via sendkeys method. Now, I can get in the external application, I can write (for example "5"), but I cannot shift the focus two fields on the right (as I manually do without problem). I mean: nothing happens. Maybe somebody...
  7. R

    Barcode scanning application

    Hi Hope you are doing well!! I need to create an excel sheet for store support. Application details: I have a material which has a QR code and some Location racks with QR Code. Whenever i get the material to my store i will scan QR code in material and rack.this two data should be recorded in...
  8. C

    Bound vs. UnBound Forms

    So I created and administer an MS Access DB -- approximately 20 end users -- they each have an .accde FE on their desktops, while the back end sits on a network drive. The primary data entry form has approximately 70+ fields, with currently 50k plus records. There is a subform on this form as...
  9. E

    Can't copy and paste after using VBA code. Any help please

    Hello guys I'm so glad to be part of this forum and to learn and share excel best practices. I'm a novice in VBA and need some help on the following. I created a check-list with a multirow highlight feature through VBA that I got inspired from an amazing guy. However I can't copy and paste...
  10. JenniferMurphy

    UDF stops running if I hot-key to another task

    I have a UDF that does some iterative calculations. It can take anywhere from about 2 to 8-10 seconds to complete its work. The data, which I enter into an InputBox, comes from another application. If I hot-key over to the other application, the UDF stops running until I hot-key back. Is there...
  11. M

    Automation Error Exception Occurred

    Hi everyone I would like to ask a help regarding on Automation Error Exception Occurred. I have created an Excel application. Excep as a front end and Ms Access as a backend. Basically all the data that will input in the Excel userform will be exported to Ms Access. The application is running...
  12. VBE313

    How can i replace this "a" without application ran code?

    How can i replace the bold part? Function test1234() Dim a As Long If ActiveSheet.Name = "Sheet1" Then Else End If a = Application.Caller.Row + 1 Do While Cells(a, 1).Value <> "Yes" If Cells(a, 2) = "Yes" Then Exit Do test1234 = test1234 + Val(Cells(a, 2).Value)...
  13. M

    Using Excel to close the correct word document

    I have been using Excel to create a report, that is then pasted into another application. Because of the restrictions of the other application, I need to copy the information from Excel, Paste it into Word, and then copy from Word to paste into the application. (it has to do with merged cells...
  14. skorpionkz

    [VBA] Toolbox show up for end user

    Hi all, I developed some User Forms base application in VBA excel. My question is not related to code. I am not sure what cause it, but some of end users can see Toolbox, even though then using application and don't even have developer screen opened. Is there any way to disable tool box, so...
  15. Y

    Counting Names in one column, only IF there is a date entered into another column

    Hi Guys, Just joined the forum so I could post a question as I've searched for an answer to this on the net and couldn't find it. I have a spreadsheet with employee names (Advisors) in one column (H) and when the advisor generates a new client application we put the application date in another...
  16. D

    Application defined or object defined error

    I had this line of code in my spreadsheet and it worked, it just printed the formula in the cell. .Range("J" & .Range("J" & .Rows.Count).End(xlUp).Row).Formula = "RC[-1]+RC[-2])" All I did was add = before the RC and it gave me an error. .Range("J" & .Range("J" &...
  17. JackDanIce

    VBA Custom sort pivot field

    Hi, (Adjusted), I have the following code which custom sorts the given pivot field: Public Sub Pivot_Data() With Application .EnableEvents = False .ScreenUpdating = False .AddCustomList wMain.Range("List_Status").Value End With With wPivot1.PivotTables(1)...
  18. VBE313

    Co-worker doesn’t know how to save

    My co-workers computer turned off due to a power outage and lost his file he was working on for hours and didn’t save. Is there an application code that can do create an if statement like If Application has been open for 20 minutes, msgbox “Save!!”
  19. R

    Recording a long formula is splitting it and destroying it

    Hi all, I'm trying to record a sumif with 6 different criteria pointing at different workbooks, when I record it, it seems to cut it after a point and replace a bunch of it with a " _ & " As a result, I think I fixed it with this but I still get application or object defined error...
  20. G

    How to show if open in browser or Excel application?

    I'm looking for a way to show if a file is open in a browser or if it is open in the excel application. Or alternatively, a way of ensuring the file opens in the application. My reasoning is that the file is a compiler and has macros which can only be run through the app and my colleagues...

Some videos you may like

This Week's Hot Topics

Top