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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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 05:00 AM.