application

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

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

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

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

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

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!!”

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

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

Hi all, I am using this code to open a workbook with a splash screen as follows. Unfortunately when I enter it and try to exit, I get an error which states: "Compile error: Ambiguous name detected: Workbook_BeforeClose" What should i do to correct it? Private Sub Workbook_Open() MSG1 =...

Hello, I created userform and added Application Goto reference in a code. The code is, when I add sheet name to the textbox5 then application goto reference goes to that sheet. But if that sheet doesn't exist, which code do I need to get msgbox that "sheet doesn't exist"? Please see below my...

Hi all, I have a module as below to open pdf files from an excel sheet sCell = Application.ActiveWindow.ActiveCell.Text sFile = "C:\Program Files\Nitro\Pro 11\NitroPDF C:\Users\" & Environ("username") & "\Downloads\" & sCell & ".pdf" retal = Shell(sFile, 1) The problem is that i need to...

Hello, I'm getting a self generated Microsoft Excel popup message: Is there any way to suppress this self generated Microsoft Excel pop-up message? Please let me know. Thank you! Pinaceous

Hi I have been under impression that to call any vba function (please see the list below), I need to use this syntax application.FunctionName but I just noticed that I can call these function without Application. Sub myfunctions() MsgBox Chr(66) MsgBox Now() MsgBox Int(55.12345) End Sub...

We have some file naming conventions where the persons LAST NAME and FIRST INITIAL is enclosed by "--", and then there is the form name then a period and the file application. S:\### xx\xxx\### xxxxx xxxxx--### xx\LAST E\########--LAST E--FORMNAME.pdf I have been trying to figure out how two...

Hi I wanted to use Trim function (Application.Trim) in my code. So I went to Object Browser and typed Application, thinking that under Application, I will see these functions. Otherwise why it is (Application.trim). But to my surprised, I could not find Trim or other functions under...

Hi I removed application from the second line like this DisplayAlerts = False but that did not work, excel gave me the warning. Why I need to add Application. in this case? because with workbooks, I do not need to add Application. So I can say workbooks.add instead of...

In Excel 2010, if I use the close workbook "X", Workbook_BeforeClose works, but if I use the application close button, it does not - why?

I try to run this code and all it says it application defined or object defined error and it highlights this row Workbooks(DocYearName).Worksheets(Combo).Range("A5").CurrentRegion.Select key1:=Range("A3"), order1:=xlAscending, header:=xlYes However, I don't think it is a problem with this line...

I have a an Excel Spreadsheet with Macros (and some XML also)that I have created an installer for using NSIS. Basically when user clicks application it installs the spreadsheet on the Desktop - Installs some documentation and installs a license file in the root of C: Everything works fine...

Hi guys... If i have 200 applications to process daily and i have 12-15 people to process them daily, each application takes about 3 hours. How would I put this piece into an excel formula where I want 3 hours to be average to process each app or ok.. how many people would i need in order to...