excel macro

Hey guys, Trying to create a macro button that, when pressed, populates empty columns, based on a match between Part_ID in excel sheet called BOM and Part_ID in database table called materials joined with tables manufacturers and vendors The code is as follows: <code style="font-family...

Hello, I am new to vba progeamming. I am looking for a vba macro preferably in excel. It should pick up a file name (e.g.example)from one of the cells in the excel file add .pps extension and then look for example.pps file in subfolders on shared drive (L:\). If it finds the file then it should...

Hi, I have an excel with a column listed with URLs. These URLs would direct me to image files. What I need to do is only verifying if such image file exists. The problem I have now is: Whenever the image does not exist, the website would replace it with "imagenotfound.png", making me really...

Hello! I need some help please if possible, is anyone able to write a code for me? I've had a look around online but struggling to find anything that can do the trick for me. I would like a script on excel to run when i receive a certain email in my inbox which goes to a specific folder. The...

Hi Guys, Thank you so much for reading my post. I really need your help to create the following excel macro. I want to get some particular data from the website but unable to get it. What i do is 1) Go the website www.ebharatgas.com 2) Click on "Transparency Portal" which is available on...

Simply put I want a macro to auto run upon launching excel 2014, to create Auto Time stamps in cells , when data is WRITTEN or PASTED into adjacent Column cells. I want to do this in multiple "column pairs ". The columns are paired but rows function indepently. Ex: Column A and B is a Pair...

I am attempting to move all of my visible sheets to a new word document. I have set up the portion of the macro that makes the appropriate sheets visible using IF statements. That works fine. Below is a code which moves all of the sheets (including hidden sheets) into a new word document. I am...

I am writing a macro that checks the value of specific cells on a sheet titled 1-SUMMARY and unhides specific sheets if the value of the cell is greater than $0.00.

Hello I have a workbook with 20+ sheets. All of these sheets relate to the "Summary" sheet. I would like to create a macro that checks certain cells in the Summary sheet (ex. A1:A8), and if the value in that cell is greater than $0.00, the macro will choose the appropriate sheet that relates to...

Shown below is the code that I want looped. I want it to loop it to 5 different colors (RGB(197, 217, 241), RGB (0, 191, 288), etc) to make the coding look neater. Otherwise, I'd have to copy and paste the code 5 different times with different color codings. Note that there are two areas in bold...

Hi Guys, I have a quick question. I have almost 100 too 200 excel files which i want to import and the sheet name to sheet1, sheet2 and so on OR else just change the first sheet to sheet1 and save it into another folder called NewExcelSheets. Thanks

I am trying to create a macro to catch all information for different time frames. For example, if there are 105 items, the macro below would only catch 100 of the items to sort. The selection for the macro does not have a specific range but the sort function does, which wouldn't make the macro...

HI, I am sure it is simple but I know nothing of macro editing although I recorded this one and simply need it to repeat on each consecutive row to line 228 so its range is set at A18:J18 I then need it to run on A19:J19 then so on till A228:J228 I would greatly appreciate any education on how...

Guys i have cross-posted in other forums, please go through the links to find replies to my posts - http://www.excelforum.com/excel-prog...ml#post3617163 http://www.excelguru.ca/forums/showthread.php?2769-Validation-for-data-mismatch&p=11910#post11910 Hi All, I used to copy row data from...

Hi, I'm getting a runtime 1004 error: application or object defined error on the code below Seems to be in relation to "ActiveWorkbook.Connections("Database2").Refresh," Any advice appreciated. Sub Send2Access2() Dim cnn As New ADODB.Connection Dim rst As New ADODB.Recordset Dim...

Hi all, Hope you all doin good..well am new to this forum as well as VBA.I have a 30+ seperate excel files in one folder.The sheets contains data for a single month for 30+ projets.I want to pull the data into new master file using excel macro.Im trying to create macro .What i need is 1.The...

I thought it was simple but couldn't find a solution so far : how can i write some lines in an excel macro to produce a sound signal on another pc in the windows home network ?

Hi Friends, Need your help to modify this macro. I have a macro in which we can mail through excel sheet having a specific text in last column and row. It's working perfect as i want but now i want to modify this according to my another need. In this macro it is searching for last row and...

Lotus code looks like this except it was all on one line: <BASEFONT color=#000000 size=1 face=Arial LOTUS_SIZE="10"></BASEFONT> <TBODY> {?}{RIGHT}{?}{RIGHT}{?}{RIGHT}{?}{RIGHT}{?}{RIGHT}{?}{DOWN}{LEFT 4}{RIGHT}{?}{RIGHT}{?}{RIGHT}{?}{RIGHT}{?}{DOWN}{LEFT 5}{BRANCH \C} </TBODY> I let Excel...