How to automatically apply the file path from a cell in VBA?

Now I am using this code for running a Excel Chart Template on bar charts: Apply Saved Chart Template ActiveChart.ApplyChartTemplate ( _ "C:\Users\Bosco\AppData\Roaming\Microsoft\Templates\Charts\Bar Chart.crtx" _ ) Since this link will be decid

Specific dynamic numbering in Excel

I have a question, is there are any way to make numbering format in excel ( 1; 1.1; 1.2.... )with formula? I need to hide second row, numbering should be dynamic and still show (1; 1.1; 1.2...) not (1; 1.2)... and i need to lock first (1) number by s

unable to reset the used range

I was trying to add an automatic macro to my very large workbook to at least trim some fat off by resetting the used range. I've tried numerous codes and cannot get it to work and can't figure out why. (It seemed to work a few time when I would manua

How to call a subset of subroutines with a loop in VBA?

I have a series of subroutines (Sub1, Sub2, Sub3, etc). I want to call a subset of these subroutines based on user defined values. For example, subs 7 through 13. I thought of using a loop based on the number in the name of subroutine, but it does no

Conditional deletion in VBA

I am trying to piece together code to make my macro work correctly. This approach has served me well in the past but I cannot seem to adapt any code correctly. I found the following Sub way() Dim Cell As Range For Each Cell In Range("A1").Curren

Separate IP Address Bytes Using Formulas

I want to separate out the octets of an IP address using Formulas. I have tried some things like substitute & find but cannot figure this out. Example of what I want to achieve, by only starting with Cell A1 and Cell B1: | 10

VBA INDEX-MATCH loop with Sub or Function error not defined

I have a looping INDEX-MATCH VBA that I am trying to debug, as it is constantly throwing a Sub or Function not defined error. With what I have already found on this site, I was able to check my references, but I still seem to be missing something ("S

Adding cell values ​​to the cell's indirect location

I'm trying to generate a function with VBA that automatically adds Values from one cell of a defined range of an Excel Sheet to the cell on it's right, so that for example when you put a number in A1 that number will automatically be added to the val

the day and the month are reversed

I have a cell with the following content : 01/02/2015 The cell is date formated Then I copy the value and put it in my module class : Set Line = New CTravelLine Line.Date= Cells(1, 8).value Everything works fine until the moment I put this value in a

Excel: Period of the next year

How to get next year period based on current month and year, for example: Jan 2014 - Dec 2014 Feb 2014 - Jan 2015 Mar 2014 - Feb 2015 Apr 2014 - Mar 2015 May 2014 - Apr 2015 Jun 2014 - May 2015 Jul 2014 - Jun 2015 Aug 2014 - Jul 2015 Sep 2014 - Aug 2

Replace chips by numbering

I have the following text: This is user message Message one Message two Message three where I want to replace all the bullets with numbers: This is user message Message one Message two Message three This text in available in only one cell of Excel fi

Sum of weeks for the monthly totals formula

I have this excel sheet picturee below. I'm trying to get the sums of the weeks in the column of the month using a sumif or sumifs but keep returning 0. Here is the forumala I've used. Any ideas? Thanks =SUMIF(B6:B50,">=1/1/2013 && <=1/

Scripting and storing Google form responses to a database

I've been trying to find the right solution to this and greatly appreciate anyone's help. I've created a google form called "Career Progress Report Form" which stores the type of activity you've done on the day. I've created this to keep track o

Excel formula to do the simple division of 2 cells uses a = +

I've been sent a excel spreadsheet to replicate in SSRS and the calculations used are set out differently to anything I have ever seen. for example =+E2/E3 = 100 This gives the same result as =E2/E3, so to me the + does noting? Just want to understan

Mono for Android, read and write on XLSX

I am developing an app using Mono for Android. I need capabilities to read and create XLSX (Excel) files. I have tried with EPPlus and NPOI, and had a quick look at Microsoft's Open XML SDK and found the following problems: EPPlus requires the Window

How to rename duplicate rows

I have an Excel sheet with I have around 25k rows of data in the following format: Column1 | Column 2 A | value1 A | value2 A | value3 B | value1 B | value2 C | value1 C | value2 and so on. I would like to rename the duplicate rows and put an integer

How can I extract Tridion keywords into Excel format?

How can I extract keywords from Tridion into an Excel format? This is for the purpose of translation of the website.If you're using Tridion 2009: If you're not, you'll have to

Unable to open XLS returned as attachment via Django view

I'm using xlwt to generate an Excel file which I'm returning as an attachment in the HttpResponse in a Django view. from django.http import HttpResponse def my_view(request): ... workbook = xlwt.Workbook(encoding='utf-8') #write my workbook data here

Problem with OleDbConnection, Excel, and connection pooling

So, I have the same symptoms as described in C#/ASP.NET Oledb - MS Excel read "Unspecified error", but my my answer did not seem to fix it. Even always closing the OleDBConnection and disposing of it show the same symptoms. var connectionString