excel vba 2013

I have a large string of text: 01/10/13 / Free Estimate on repair vs replace on opener / son will be home to let you in, call Nick when you are on site to go over recommendation ~VNL**Chris / 15 year old craftsman 1/2 belt with stripped gear.Told him his options and he said he wanted to do the...

Hi Guys I am a beginner with vb and wondering if somebody can help. I have source workbook with dropdowllist in B3 sheet name "Front Sheet", the list is based on data from another sheet in same workbook. I also have destination macro-enabled workbook "Combined", from here I like to run my vb...

OK, I really did look for the answer for this, but after about 2 hours of reading posts, I'm no closer to the answer. :( I am trying to open a second workbook from the one with the VBA in it. I need to set that other file's name in one place so someone else could edit my code if they exporting...

I had a loop that should have run in a few seconds but it was just sitting there, so I hit ctrl-break to see where it was and it was only within the first hundred records. I hit F5 to continue, and it finished the other 3000 records in a second or two. Puzzled, I limited it to the first 100...

I am new to Excel and VBA. I am making a Project list wherein I have two columns for Status, Status and Status in Words. In the former I Need to enter the Status in form of numbers, e.g. 50% or 80% and in the latter I Need to enter the Project Status in words i.e. Open, Closed, In Progress etc...

i have a workbook name as ColorDB and 2 sheets inside that workbook. The Sheets are named as "CNT" and the other one as "PPB". I have a macro button inserted onto the "PPB" sheet. when i click that macro button , i would like to browse and open a .dat file and import the data onto the same sheet...

I have data in .dat file format. It is basically a color database. I need to import the contents in the notepad into excel. I have browsed and found a code which does the job of importing .dat data into excel. The screen shot of the data available in the .dat file when opened in notepad looks...

Hi Everyone, I am copying a module from one workbook to another so that in the future, the new workbook can run a macro from within itself rather than referring to an external workbook (which may or may not be open in the future). Then I create a new workbook by moving a sheet from one to the...

Hi, This is my first post on this site, I hope someone can help. Forgive me in advance, as I am no expert and in the very early stages of learning excel vba. I would appreciate if you could provide any help on the following. Any suggestions of improvement of codes is always welcome too...

Hi, How Can I get the data from google result, it's like in this example, but not only first result also alt least 10 or 20 first results. Sub XMLHTTP() Dim url As String, lastRow As Long Dim XMLHTTP As Object, html As Object, objResultDiv As Object, objH3 As Object, link As Object...

Hi experts, I have a "flatten" table with countries and years in Excel. eg. <code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif...

Dear Experts, Thanks for all your suggestions and inputs you have provided me for different queries I have posted on this forum. Request your help again for an enhancement feature, to include in my existing user form. I have attached screen shot of user form, which is to input data for service...

Hi Experts, This is my first post here and I hope this would be more interesting for Excel VBA Geeks like you all. Ok, here is my (problem) description: I have created a new Excel VBA application, which will accept a number (Ex: 59745-7845-5412). Once the user clicks on the Fetch button after...

I have master workbook ‘WORK ORDER.xlsm’.with few worksheets (Main, Summary 14 days, Invoice, Data). My employees filling up ‘Summary 14 days’ sheet every day and in the end pressing button with vba code. My intension was to save workbook (always same company network folder) with different name...

Hi I am currently using the code below to read the data from worksheet 'data' to a cell in the current active worksheet. This works fine. I now need to change this so that worksheet 'data' is a new, separate spreadsheet. I need to be able to define the folder and the filename of the new...

Hi I am using VB code created by recording a macro. I need to import as text, the content of a CSV file into a worksheet. The code I used is below. When I first ran the code, I got an error (Run-time error 5, Invalid procedure call or argument). I searched the internet and found a few people...

hi Friends, Excel 2013. I am trying to have a pivot table with hyperlink features enabled using EXCEL VBA. http://postimg.org/image/vz7ozq8qj/ So in the above picture you see the pivot table with two fields [ProjectName] & [ClicktoPR] displayed. I want to write a VBA code so that only...

I have written a function xxDay(row)" that I refer to a cell on my worksheet, passing the data of another cell. Within the xxDay function I call "ExecuteExcel4Macro" for data from a closed WB and I get #VALUE returned to the cell on my worksheet. When I run the xxDay function as a sub it works...