excelvba

I'm trying to use VBA for web scrapping (★ Dream Catcher Home Stay, Cochin, India) and get numerical value for "b_hotel_id" line in the code below <td class="line-number" value="568"></td> <td class="line-content">b_hotel_id: '554615',</td> but I don't know how to refer to it, as there is no...

I understand that this might be a long process, So I thought we can take it solve the intentions one by one and I would keep on editing the post :) I have a data dump that I want to extract into a template and be printed out. Here are my intentions: [Initial][1] 1. From the data dump (sample...

Hi all... Not sure if this is even a thing but... I am trying to do what I can only describe as a VLOOKUP and a HLOOKUP and copy data to the appropriate cell from one workbook to another. Basically, I want to open a window, select the import file, and copy the data to the root workbook based...

Was wondering how I can use a Where statement in a SQL qry Am doing a mail merge, and trying to avoid the rows in the Name column that only contain a function that returns "" SQLStatement:="SELECT * FROM `" & wsName & "$`", SQLStatement1:=""

I would like to use a wildcard to check if a folder exist. i have tried the following: "C:\Users\*\Desktop\New folder" "C:\Users" & "*" & "\Desktop\New folder" "C:\Users\ + "*" + "\Desktop\New folder" i get, "bad file name or number." is there a way to do this? Sub TestForDir()Dim strDir As...

I have been looking at the www.automateexcel.com to help me automate the creation of my coding. I am a poor code writer and a lot of these tools would improve my abilities, but I am curious if there are any other software that compares to Automate Excel. Does anyone have any suggestions or...

I have the following formula in several cells in column C from row 8 to row 61: =IFERROR(INDEX(Comments!$K$2:$K$76,MATCH(C22,Comments!$B$2:$B$76,0)),"COMMENT REQUIRED") Since it is an index match, only values are copied. I would like to implement VBA code that will preserve this index match...

Team , I have below VBA code to hide few rows in excel but 2nd code in this is not working in combination with first one . When I do it separately its working fine . Any Suggestions ? Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("B7")) Is Nothing Then...

Hello Everyone, I have been doing some reach in the forum trying to find the answer of my question but haven't quite found the thing that I want so following up on that. I have two sheets, sheet1 that have multiple projects on Column A and Column L have multiple dates. What I want to happen...

Hey, all. New to the forum and really appreciate what you all have here. I've looked around the internet and several other forums for a way to increase the time it takes my code to add data to tables. I have an excel database that stores all the data for projects that I've worked on and will...

I'd like to select a specific number of cells in Sheet3 based on the count available in cell Z1 in Sheet2. The below code is somewhat of help, but not completely. The data in Sheet3 is a filtered range and I'd like to select only the visible cells (based on the count provided in Z1) below the...

So this is my code: Dim src As Workbook Set src = Workbooks.Open("UMF_IR_ADM_<wbr style="font-family: arial, sans-serif; font-size: 12.8px;">SPARTACUS_1910 (Data as of 3-5-2018)") Worksheets("Executive").Range(<wbr>"D7").Value =...

I am trying to simplify the VBA below as there's too many selects and with the array of data being copied from one sheet to the other as the sheets get larger in size, I want to reduce the overhead and increase the speed it executes. It currently works, but isn't the cleanest. The "TODAYS_DATA"...

Hi, I have the below code that is working for most of my users but is crashing in the red line for some of the users. The only common trend I've found for those that this is not working is that they are Excel 2013 users as everyone else is Excel 2010. The Excel 2013 users have a run-time error...

Greetings. I have a problem getting the .find to work on a table column. In the table, is a column labeled 'ID'. Towards the end of my program is the line: foundrow = summObj.listcolumns... I have tried for hours to google for help and have tried many different syntaxes and I cannot get it to...

Hello, I am trying to modify this VBA to exclude the ".txt" from the sheetname after import - but not sure how to that, is it easier to just add a line to remove the last 4 characters from the sheet name after import is done? thanks Dim xWb As WorkbookDim xToBook As Workbook Dim xStrPath As...

Hi all, I have found the below mentioned code for outlook 15.0 Can someone help me to make changes in the code for outlook 10.0 which can be used in a button in excel user form to extract data in "extract raw" sheet this code is giving me "2147221233 (8004010f)" error Below is the code '...

Hi I have a task of collating data from 20 or 22 text files in excel however, 99%of time I will have data in text delimited format but 1%chance that out of the 20odd text files 1 file will have the data formatted using text to column function when u test check it while opening the text files...

I'm really new to VBA and Excel, I know a few bits and I have created validation lists and a macro to rename the sheetname depending on what text is entered into a certain cell etc. I don't really know where to begin with creating a macro to report back a list of sheet names onto the...

Hello all, I need help with multiple voucher printing from excel. In sheet No.2 I have following data: In Column A, I have put approx 2000 dates (dd-mm-yyyy). I have voucher nos in Column B (approx 2000 voucher nos). In column C, I have different description in each Cell. IN column D, I...