application

Hi all. I recently made an excel VBA project which then turned out to be a huge application. This application is being saved in a network shared folder where multiple users are able to access the file (only one at a time though). So, this application runs smoothly thus far on multiple machine...

Hi, i need some help on two matters. both are related to filters, involving dates and multiple column. a sample of my database as such: <tbody> Name Project Gender Type Funding Topic Date of Application Survey Date 1 Survey Date 2 Survey Date 3 Survey Date 4 Survey Date 5...

Dear All, Please guide me about how do i open vba forms and coding pages from one my vba application file type.. Pls guide someone..

Hi guy ! How can i go directly to a window of an application with it'ID , because it does not have Please

Hi There I got this macro from Mr Excel forum but I forgot who gave it to me. I have a bug on the line that says: If MyData(r, 1).HasFormula = True Then The bug says "Object Required" Can someone fix this for me? Below is the macro Sub CopyPaste1() Application.ScreenUpdating = False Dim...

Dear All, If you run this application, and this opens the xlMicrsoftWord ..... how do you get VBA to CLOSE it?? Sub Macro1() ' Application.ActivateMicrosoftApp xlMicrosoftWord End Sub Thank you, Pinaceous

Hi I want to insert some pivotcharts and charts to userform in Microsoft Excel 2013 visual basic for application. Would you please help me on this ? Thank you in advance.

I am getting following error Getting Application Defined or object defined error in syntax below ws.Cells(1, 3).Formula = "=(ws.Cells(1, 1).value) * (ws.Cells(1, 2).value)" Pl dont show any .formula with range thanks NimishK

Hi all, We are very small organization working, we are getting data of 10K (71 columns) on weekly basis. My job is to collect this data and consolidate for month and year, over a period of time this data becomes huge ( 300mb in 2018). These details having fixed columns and then I apply few...

Hi, So, the problem I'm having is that some code I am writing calls another macro. This second macro has a userform with fields that must be completed before it will continue. Is there any way I can have code in the first macro that will enter data into the userform from the second? The main...

hi guys.! any body help me ? I have problem with my excel macros project. I will editing data on cells together with the active userform of vba application. because, now I cant click for edit cell or toggles, menu excel application if userform vba is active?

I've tried to search for help on this but struggling with the keywords I'd need to find a query like this. Basically I'm wanting to know if it is possible to create a simple text hyperlink to an application, but when the hyperlink is clicked rather than taking the user to the original...

My application is going to run on an enormously slow computer, the end user will have to save it several times. The idea of saving my entire workbook seems wasteful just to change a last name in one field. Should I use a second workbook that contains only my data and no macros to make it...

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

Have 2 versions of Access installed on my computer. One of them is not working probably. Have created to open an access database. Unfortunately, it opens it with the access application that does not work. How can I setup that it opens with the access application that work. (It is not...

I have an application defined or object defined error on the following line: SearchArray = Sheets("CurrentSheet").Range(Cells(6, 5), Cells(EndArray, 6)) EndArray is an integer variable and SearchArray is a Range variable. I don't see where the problem is occurring. Any ideas?

Hi All, I'm looking for a way to open my workbook in a separate instance of Excel and then hide the application and show only a userform called Client_Information_UF. After searching around I found this bit of code to create a separate instance of Excel, but if I change xlApp.Visible = True to...

Hi Using Object browser, Application class has the following: Activecell as range Activechart as chart Activesheet as object Activeworkbook as workbook ActiveWindow as winodw All of them make sense to me except ActiveSheet? Why is define as Object? What does that mean? Why they did not...

I have the following code which automatically copies from one tab to 4 other tabs. rivate Sub Worksheet_Change(ByVal Target As Range) Dim ws As Worksheet If Target.CountLarge > 1 Then Exit Sub With Application .EnableEvents = False .ScreenUpdating = False End With If Intersect(Target...

Hello An application windows is already opened. It is reduced when I clicked a cell in my Excel sheet. How can I recall / select it and copy the content of the clipboard. I think it could be done using the " vbNormalFocus", If so how do I know the path of the desired application. Hope I'm...