excel & vba

Hi, I'm trying to copy column one of each sheet and save it to new sheet which will then be saved as csv file and name of new sheet should be pulled from old workbook. if sheet names are If ShtNames(i) = "Sheet1" Or "Error log" Or "JUMPER REPORT" Or "WIRE LABELS" Or "TERMINATION COUNT" Then...

Hello, I hope my request is possible. I need to create a code to go through the data on a spreadsheet and create chart for each product block. There are might be multiple product blocks. I got code to create the first one, but I am pretty bad with loops and have no idea how to make it go...

Hi, I went through http://www.rondebruin.nl/sendmail.htm however it did not help since I am not much familiar with writing VBA code. Can anyone help me with VBA to send email based on values in Excel pivot? I have embedded a sample excel file below:- I need separate email where column A...

This is going to be a long one. I apologize. I found some VBA script online (this is not something I wrote and can't take credit for any of it) that allows me to export and save the active range as a pdf and it automatically attaches it to an email with some predetermined verbiage. I have...

I'm running a simulation with over 500,000 iterations. I've got screenupdating turned on on, statusBar display is on, and I've activated the status bar to print on the iteration number, but it prints out 6000+ and then stops. Could it be that the software is running faster than the screen can...

I am looking to construct a VBA that unhides specific rows across different sheets in a workbook. I can write separate VBA for each sheet/row combination, but was wondering if I can put them all together instead? 3 sheets need the same rows unhidden that I already have code for: Sub Test()...

Hello All, I am attempting to insert N number of rows based on N being inserted in cell "D7" Rows are to be inserted at A10, with the formatting (borders) extending to D10 This is the code i have so far but I keep getting the error message "Runtime error 1004 unable to set the weight...

Hey guys keep getting an error msg of object variable or with block variable not set..excel highlighted the string of code that may be giving me the issue I a completely stumped need help! the code is below..any help is appreciated Sub Macro5() ' ' Macro5 Macro ' ' Keyboard Shortcut: Ctrl+e '...

Hi all, Please help to run this formula if the day in cell C2 value is saturday Range("F2").Formula = "=IF(AND(D2>=TIME(9,16,0),D2<=TIME(11,59,0)),D2-TIME(9,0,0),IF(AND(D2>=TIME(14,16,0),D2>=TIME(12,00,0)),D2-TIME(14,0,0)*1,0))" and if Cell C2 value is Sunday to Friday...

Hi all, I have a situation where I need to do SUMIFS + SUMIFS + SUMIFS to get the desired result. For example, in the table below I am trying to populate the third column - essentially trying to add the data for client A123 + client B123 + client C123 for Dec 1,2018 in cell c1. Similarly...

As the above title suggests I'm tring to open an Excel document that is embedded in a Word document from within my Excel document using VBA. This is the first time I couldn't find a pre-existing answer to my problem. The reason I'm trying to do this, in case someone has a better solution, is...

I want the button on userformTombol in document "Agendaku.docm" activate after The Excel application Quit. What is the mistakes in the following code: ? (error message : Object dosn't support this property or method) Private Sub CommandButton1_Click()Dim ObjWord As Object Dim ObjDoc As Object...

Hello When I run my send email macro, the excel sheet data that populates in the email body has errors in one column. Eg: In the workbook the values are reflecting as <tbody> 3/9/2019 22:00 </tbody> But in the email body the values are reflecting as 3/8/2015 22:00 Why is this happening...

I need a script that will count all files ending in "_1" in all subfolder, then return that number to cell "H11" by pressing a key or by a certain time interval. It needs to select todays folder with this format 20190308-F3-kh, only paying attention to the 20190308 as the date. The "-F3-kh"...

I have data in even row i would like to copy data from even row and paste into odd row and loop goes to last row of sheet. <tbody> A B C 1 2 Data1 Data1 Data1 3 4 Data2 Data2 Data2 5 6 Data3 Data3 Data3 7 </tbody> <tbody> A B C 1 2 Data1 Data1 Data1 3...

Hi Is it possible to use VBA to move several files that have been imported into the 'Downloads' folder (from a web-based application) into a new folder within the downloads folder? I'd want to create and re-name the folder that the files would go into. TIA

Hello, I've been trying to create an excel daily schedule that archives the days that I put in according to their date. I want to be able to type in a certain date and have the sheet show the plan for that specific date. I'm okay with using VBA, any ideas? Thanks. (New to this forum, by the way)

Hello, I need to open PPT file form SharePoint using the Excel VAB, can any one please help me how to do it.:confused::confused::confused:

I need to interpolate data from my table and I already have a way of doing so, which I learned from: https://www.engineerexcel.com/bilinear-interpolation-excel/ However, I wanted to incorporate it to my workbook in a way it can automatically fill in the values, since I have many similar tables...

Hi guys, I am new to VBA and I need some help please. I created a calendar in vba using different sources that I found online. It I supposed to pop up in two cells on my Excel spreadsheet when I Click on those cells, and it does. The problem is that when I click on any date, it will not...