Changing a part of vba code

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Changing a part of vba code

09-11-2014, 10:34 PM

excelledsoftware excelledsoftware is offline

Windows 7 64bit Changing a part of vba code

Office 2003

IT Specialist

Join Date: Jan 2012

Location: Utah

Posts: 455

You need to change this instance

Code:

If UCase(Right(filename, 3)) = "MP3" Then

Code:

If UCase(Right(filename, 3)) = "MKV" Then

Remember to keep it uppercase

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Code for shading part of a word	SQLUSA	Word	4	10-29-2013 05:57 AM
How to transpose the datas of part code and supplier into row and column	PRADEEPB270	Excel	3	10-26-2012 07:22 PM
VBA code for changing capital letters become lower	Jasa P	Word VBA	6	05-02-2012 12:10 AM
changing font size without changing leading	carolns	Word	1	09-14-2009 12:30 PM
Code for Changing Cell Backgrounds	leroytrolley	Excel	2	12-05-2008 02:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:22 AM.