exce

Hi Good People, Below code opens a session of reflection desktop and extract data from a particular screen. My problem is, I don't want to open another session, instead it should find the active session of reflection workspace then execute the code. However, I am nowhere near from that the...

I've an issue to export attachments from outlook to excel cells. The attachment is not the filename, but the file itself. For example, if PDF file, it will extract the PDF file to the cells, not the filename or the details inside of PDF. I know how to save attachment to the folder but not on the...

Hello, i have a question for a practice interview test which is On the ‘Workings’ sheet use formula and/or pivots to analyse this dataset to identify the percentage of students still retained and graduated at the end of the third year (by course) and the proportion of graduates that received a...

Hello everybody, I'm having trouble changing my Macro's colors when it automatically selects fields. Does anyone have any idea how I can solve this problem? Thanks for listening. This code VBA i'm use: Sub RemoveLeadingSpace() Dim Rng, WorkRng As Range On Error Resume Next xTitleId =...

Instead of applying it into on cell what can i change to apply it to the whole column? Sub Return_nth_character() 'declare variables Dim ws As Worksheet Set ws = Worksheets("sheet4") 'extract the 3rd character from a string ws.Range("b1").EntireRow.Select = Mid(ws.Range("A1"), 3, 16) End Sub

Hi there, I am a bit of a newb when it comes to VBA. I've tried many different options and nothing worked. I cannot think of a way to get this to work. Would appreciate any help: Aim: I wish to paste a sum formula in Sheet1, Column R starting in Row 2. which sums the previous 4 columns (simple...

this code works great and deletes empty rows and shifts things up sub test() with range("L12:L28") for i=.rows.count to 1 step -1 if isempty(.cells(i,1)) then .rows(i).delete shift:=xlup next end with end sub But the problem is that it also shifts anything below the L28 up and it ruins the...

Using VBA macro, Is there a way to copy the value in a cell from one workbook that has, ex, value is "X" in cell A2 workbook1 sheet 1 and paste that value into another workbook, but the pasted value is a Yes/No in cell A2 in workbook2 sheet1 if that cell is the value X? Example shown below...

Hello, I was wondering if there is a way to have three workbooks. Workbook1 has multiple sheets, example sheet1, sheet2, ect, with tables with cells containing questions and then the cell next to it where values can be typed into. Workbook3 has the a similar format but the cells that need...

Hi all, how would I populate a specific cell when a checkbox is checked? I tried the code below, but it doesnt change the cell value automatically. Any help would be appreciated. Private Sub CommandButton9_Click() If CheckBox1.Value = True Then Range("A109").Value = "ZJ2" ElseIf...

Need help with a vba to make a lot of copies of a excel file i have. I have looked around and couldn't find anything really. Any help would be greatly appreciated

My workbook contains an 'inputs tab' where i will have 3 inputs: "date", "amount" and "number of months." In my 'output tab' i have row 1 filled with all the month end dates. I.e Jan 31, 2020, Feb 28, 2020....etc I want to have a dynamic formula in row 2 that will match the "date" from...

So I have been beating my head against this for a couple of days now. If column R is blank, exclude or ignore that entire record from the code. The problem is, I can get it to work.... if I permentantly delete that row from the sheet. The entire code is very very long so I will only include the...

I'm using this Workbook's SaveSheet event to prevent users from adding a new sheet from within my main workbook file. OK, that's half the goal. But that event isn't triggered if user tries to copy/move a sheet from another WB into my main file. I've started looking at a workbook lock/protect...

Check in Sheet 1 the sum of the field “Long” is equal “Long” in Sheet 2 for the same “code” where “Ap” is “0”. If this is not correct put in sheet 2 in column “Sum” the value “Not correct”. Sheet 1 <tbody> Code Long Ap 15-15 100 0 16-16 50 1 15-15 100 0 14-14 50 0...

Hi, Everyone! I have column A, In which every cell has words including spaces in between. Every cell has leading and trailing spaces as well. I have denoted words with english alphabets A, B, C, D, E, F and G. I want to perform an operation on column A such that the duplicate words are removed...

I have written some code that uses the copy to new sheet function in excel a very format heavy tab. I then have written some code to save said tab and some other code to update some values in the original sheet and alter the country loop through it saving the file each time. Each bit of the...

How can I in Excel, resolve this question about this table: Invoice Number | Item | Product | Value 1001 | 1 | potatoes | 100 1001 | 2 | tomatoes | 150 1002 | 1 | potatoes | 100 1003 | 1 | water | 50 1004...

I have a sheet "Data" with an empty table "Table1" I need a macro that retrieves everything that is in the table, it can be from one to several rows, and inserts it at the bottom of another table "Table2" in the sheet "LockedData " and then converts "Table1" so it's an empty one row table again...