exce-vba

Hello all and thanks in advance, I wonder if it is possible to create a macro, and if so how, that tells excel ,that everytime that changes in the sheet get saved , send an email to a certain outlook account. That would help heaps to fix some comunication problems that happen in the company...

Hi, I want to check the Colum A and Column E value and then collapse the Pivot table based on the values. myfile.Sheets(3).Select Dim dd As Range Dim ee As Range Dim ff As String For Each ee In myfile.Sheets(3).Range("E1:E20000") For Each dd In myfile.Sheets(3).Range("A1:A20000")...

Hello, I have an Excel File where i have all my projects and a button so when i need to open a project i just click on the button to open it. but the problem is that when i already have that file open and i click on it again it doesn't let me open it without erasing the data i had worked on...

here under is my excel sheet it gets every 5 minutes data. but i want to paste every 15 minutes data on G H I J K L column respectively. suppose at now time 9.00 AM when time 9.15 AM that data automatically paste on another mention column G H I J K L respectively . is it possible ...

Hello again. I am running into a compile error saying “Sub or Function Not Defined” for the following: LastRowInOneColumn Could you please help me out! Here is my code: Range(strCopyRange).Select Selection.Copy currentWB.Activate Sheets(strWhereToCopy).Select LastRow =...

Hi, I need a macro which displays the folder and subfolder name from a specific path in the column A of the excel sheet in the same heirarchy. Also whenever a sub folder name is displayed in column A, I need its main folder name to be displayed in the same row Column B i.e offset(0,1). I have a...

Friends, I am using the following code to find a NAME in my work sheet and to enter their status. But this macro is not compatible if a duplicate or Similar name exist. Friends can you help me to sort out this. What I need is I need this macro to activate the search NAME Cell and then a VB box...

Hi, I have a .mpp file and how can I open it without using tools.

Sub Nationality() Dim rng As Range Dim cell As Variant lRow = Range("R" & Rows.Count).End(xlUp).Row Set rng = Range("R2:R500" & lRow) For Each cell In rng If Cells(i, "R").Value <> "UK" Then Cells(i, "R").Interior.ColorIndex = 3 End If Next I'm New to excel vba, It seems to be simple...

Hello Dear Excel Expert! I have two worksheets; Worksheet "Data". Worksheet "Form". In Worksheet "Data", The data is arranged in tabulated form, has headers and records, Column A has unique ID and the header name of Column A is "responseID". All headers are unique as well. In worksheet...

How can i modify the code below so it does the following: - Extract data from all the documents within a folder- Not a single file at the time. I have to process 6000 word documents.:( - Copies only the data within the cell that starts with "External References"- instead of every table within a...

Hi, I am trying below code to share the folder i created, but i am getting "Folder not shared" all times, dont know what is wrong in this code, and i am not sure whether sharename is wrong, please clear this issue Const FILE_SHARE = 0 strComputer = "." Set objWMIService = GetObject("winmgmts:"...

I am current using following code to export data from worksheet to Ms.Access database, the code is looping through each row and insert data to Ms.Access Table. Public Sub TransData() Application.ScreenUpdating = False Application.EnableAnimations = False Application.EnableEvents = False...