excelvba

Hello, I'm using Excel 2013 and modified some code to help me filter a certain column, 7th column (the hub name), copy that filtered data, paste that to a new workbook, save it by the hub name being filtered, and format the new workbook. The code works. I'm just wondering why, however, I had...

Hi everyone, I have several word documents named 001 002 003....... 999. I need to print a selection of all these documents. From the beginning till the word END is found. When I print these documents I want to place some information in the header. I have written the code below. it does what i...

Hello everybody, I have a trouble with getting ModelMeasureNames collection of Power Pivot model by using Excel/VBA. I can't find any function that would allow me to do this. I can get the Power Pivot model of the workbook by ActiveWorkbook.model. But this model object does not have any...

Hello Mr.Excel :) This is my third question, I have to fill the form and filter only the people who pass my condition to new sheet. My conditions are... 1. If the all fields are blank, do not copy them to "Output" sheet. 2. If the salary is less than 30, do not copy them to "Output" sheet. I...

Hello Mr.Excel forum, :) I'm doing the final exam for my mother, I have created the input sheet as below. The table contain questions and 4 choices <tbody> Questions Choice 1 Choice 2 Choice 3 Choice 4 What is animal ? Box Cat Man Desk What is the meaning of dance ? Sleep Run Walk Move...

I'm having a issue to split my data set into multiple sheets with specify number of rows with their headers from input sheet. I want to use Excel-VBA to solve this, Thank you... Example: My input dataset <tbody> Name Cost Dew 12000 Dew 12001 Dew 12002 Dew 12003 Dew 12004 Dew...

hello again, I have below questions with which I need help/suggestions please. 1. A userform created in excel 2007 which has calendar control option in additional controls - will this work as it is if system having 2013 on it? 2. How do I get Calendar control in 2013? If not, the code? 3. I...

I need a stacked area graph, from what I know, my horizontal (x-axis) can only be category or time based. Is there any way to use a macro to change my axis to scale it according to the value? If a macro can't change the axis (because excel defaults it), is there a way to combine this graph to a...

Hi all. I've written a macro that iterates between several workbooks. Each workbook has a sheet with a data validation list with different "Views" as options. When selecting each view, the workbook automatically hides and unhides columns. All i need to do is, go through every view and get the...

I am working on a excel macro that selects certain data from workbook and post it to a web service. For that I have to verify the users credentials with sso authentication of our companies main web application. Is there a way to do SSO authentication directly from the macro with excel vba...

I hope somebody is able to help me on this one. I have a data base in a worksheet which has town names (a2:a22) and the same town names across (b1:u1) Then the range b2:u22 is the km's. I have manage to put this together in the normal sheet index match, however what I'm now trying to do is put...

Hello I have a question on how to do a VLOOKUP on different sheets within the same workbook... Basically I would like to make a macro code to do the following: 1. Select Sheet PS 2. In cell D2 enter the Vlookup 3. Drag the formula down to the last row I have this Vlookup but it return an error...

Dear Team, I have a situation here, i have a spread sheet where in i have to update some data, this data vary everyday. I am trying to create a text file from the data, also the text file should not contain the header row of the excel workbook. Can this be done using VBA ? Please help. KR...