excelmacro

Hello! I am new here and I hope you can help me as I am a noob when in comes to macros. I have a macro that I want to create that can list down all the file name and the file path of each item inside a folder. I also want this macro to list the items inside a subfolder. Note that there is also...

Public Sub Extract_Data() Dim httpReq As Object Dim HTMLdoc As Object Dim resultsTable As Object Dim tRow As Object, tCell As Object Dim destCell As Range With ActiveSheet .Cells.ClearContents Set destCell = .Range("A1") End With Set httpReq...

Hello, I am struggling to figure out how to create a macro that allows me to create pivot tables using the current/active sheet as the data source. Each sheet has the same format and layout. My goal is to create a report sheet that will have a combination of all of the pivot tables. Thank you...

Hi All, I'm trying to send email from excel sheet, but before sending im getting a Outlook warning "A program is trying to access outlook email information..." with Allow, Deny and cancel button. im thinking of fully automating it but then this warning keeps on poping up whenever i sent an...

Hello Guys, I have a Pivot table, where i need to add new row above the pivot table and show the subtotal of each column till last available Column. (Pivot range may vary) Below is the code which i tried but it was not working correctly. Please help. LR = ActiveSheet.Cells.Find("*"...

Hi, I am looking to write a formula that will include into one cell all the values that are visible in column A after filtering. Looking online I have only been able to find the below; Public Function ConcatenateVisible(rng As Variant, seperator As String, Optional IGNORE_EMPTY As Boolean =...

Hi, I have a ready csv file to be upload it to the website. I want to upload this file to https://login.xero.com i have the login id and password. can anybody help me how can i do this ? Kind regards, Shaikhstonevilla

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...

I have a subset of data that I am writing a MACRO to pull out into a different spreadsheet. Within this subset of data I have comparative numerical values in 9 of the 15 columns (E2:M2). I need to be able to highlight or isolate the greatest value in each row, but while also putting this on a...

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 want your help creating a macro. I have two excel file open on my computer. Say Book1 and Book2 accordingly I want to perfom the task as under 1) save book2 file as csv at the specific path 2) file name shold be as per Cell no A5 in the book1 3) close the saved csv file without any...

Hie All, So basically i am making invoices from a master file where all the necessary inputs are there, what i want is automation of the invoices, the master file contains the following data: B2 C2 D2 F2 G2 J2 K2 L2 M2 P2 SrNo Date Quot Date Inv Product StockC ProdcutC Qty Price And the file...

Hi, I am a new macro user I have a folder, which consists of lots of excels. Now I need to create a new excel with a macro that can, (After running the macro) 1. have a text box to ask me to type in what keyword I want to search for. 2. search through all the Sheet1 in all my excels in that...

Hie all, Basically i am creating a excel sheet where i would be required to have random numbers in a particular range and in multiples for 5 and all the numbers generated should have the total which is entered. Let me elaborate Input Number- 136400 Random Numbers Range- 12000 to 15000 (Range...

Hey Guys, I have been building this section of code for about a month. I have many revs of this code, however, while it SEEMS this code works in other versions. I cannot get it to stop breaking on the same line. Sub alertGen() Dim lync As CommunicatorAPI.IMessengerConversationWndAdvanced...

Hello Excel Pundits, I need a small favor. I have a file like this string1 1 4 7 2 5 8 3 6 9 string2 I need to write a macro that searches this specific string1 and shift the numbers underneath the cell until string2 to right. thank you so much for the help.