| Thread | Last Post | Replies |
|
| PlayWavFile | 18 Aug 2008 20:06 GMT | 9 |
Does anybody know if there is any issues or problems with function "PlayWavFile" in 2007? I tried using this but it keeps telling me function not defined. Please help.
|
| VBA - UserForm Reset Option | 18 Aug 2008 18:54 GMT | 13 |
Here is my Userform that I created: Sub Import() ' ' Import Macro
|
| How to leave Selection.Sort Key open.... | 18 Aug 2008 18:33 GMT | 6 |
Any way to change the sort key to be wherever cell it lands on in column C? Not limited to row number 73,74..... Sub Macro1()
|
| Using Replace to remove part of a string | 18 Aug 2008 17:06 GMT | 5 |
I have a number of cells that end with ;Color=12342. For example - Alan;Color=12342 Jane;Color=12342 Clare;Color=12342
|
| User form varible passing | 18 Aug 2008 16:58 GMT | 4 |
In my VBA module "module1" i have a global varible Private global_var1 as boolean I initialize it in the main Subroutine global_var1 = false
|
| Adding sount to a macro | 18 Aug 2008 16:48 GMT | 10 |
Can somebody explain to me how to add a sound file to a macro. I need exact instructions, since what I got (below) does not seem to work for some reason, and error comes up. Can you please explain how to do it exactly? Here is what I have:
|
| Creating new workbook from different workbook | 18 Aug 2008 16:09 GMT | 6 |
I am trying to figure out a way to create a work schedule for employees via EXCEL. I want the scheduler to use one workbook, defining certain info like beginning date of schedule and actually creating the schedule (indicating who
|
| Deleting columns on multiple sheets | 18 Aug 2008 13:28 GMT | 4 |
I have a macro that attempts to delete column A on all sheets in the workbook. What it currently does s delete all columns on the first sheet (activesheet) only. For Each ws In ActiveWorkbook.Worksheets
|
| Problem with (One location = Another location) | 18 Aug 2008 12:34 GMT | 6 |
RBS.Sheets("RBS").Range("I4").End(xlDown).Copy Destintion:=AccRep.Sheets("Volumes").Cells.Find("latest").Offset(7, 0) It says Object or Method is not supported. I tried this as well RBS.Sheets("RBS").Range("I4").End(xlDown).Copy
|
| Macro to find and log all formula errors on all sheets | 18 Aug 2008 08:40 GMT | 10 |
Is there a code that goes thru each sheet of the work book and looks for formula errors (any type) and then record the name of the file and type of error into a different workbook? I have a workbook that has a list of paths to lots of other workbooks, in
|
| run time error 53 | 18 Aug 2008 05:06 GMT | 10 |
I am using a macro to open up unknown files from one folder, put them in another and change the name. what happenes is when the folder runs out of files it stops the macro mid point. I need to get past this error with out a msg box or any stoppage.
|