Advertisement
Advertisement
| 01.29.2008 at 01:58PM PST, ID: 23121017 |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
|
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
| Microsoft |
| Apple |
| Internet |
| Gamers |
| Digital Living |
| Virus & Spyware |
| Hardware |
| Software |
| ITPro |
| Developer |
| Storage |
| OS |
| Database |
| Security |
| Programming |
| Web Development |
| Networking |
| Other |
| Community Support |
| 01.30.2008 at 04:52AM PST, ID: 20776560 |
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: |
Sub CheckForMods()
Dim OtherMod As Object
Dim EachFile As String
Dim FileLocation
Dim r As Range
Dim MyFile As Object
Dim x As Integer
Application.ScreenUpdating = False
Application.EnableEvents = False
FileLocation = Application.GetOpenFilename( _
fileFilter:="Pick any xls file (*.wk4, *.wk4")
If FileLocation = False Then Exit Sub
FileLocation = Left(FileLocation, InStrRev(FileLocation, "\") - 1)
EachFile = Dir(FileLocation & "\*.wk4")
Do While EachFile <> "" ' Start the loop.
EachFile = FileLocation & "\" & EachFile
Set MyFile = Workbooks.Open(EachFile, False)
MyFile.SaveAs ThisWorkbook.Path & "\" & Left(MyFile.Name, Len(MyFile.Name) - 4) & ".xls", xlExcel7
nxt:
EachFile = Dir ' Get next xls file
Loop
ActiveSheet.[A1].Select
Application.ScreenUpdating = True
Application.EnableEvents = True
Exit Sub
End Sub
|
| 01.30.2008 at 04:58AM PST, ID: 20776590 |
| 01.30.2008 at 01:04PM PST, ID: 20781278 |
| 01.30.2008 at 01:45PM PST, ID: 20781727 |
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: |
Sub ConvWk4ToXls()
Dim EachFile As String
Dim FileLocation
Dim MyFile As Object
Dim FileCount As Long
Application.ScreenUpdating = False
Application.EnableEvents = False
FileLocation = Application.GetOpenFilename( _
fileFilter:="Pick any wk4 file (*.wk4, *.wk4")
If FileLocation = False Then Exit Sub
FileLocation = Left(FileLocation, InStrRev(FileLocation, "\") - 1)
EachFile = Dir(FileLocation & "\*.wk4")
Do While EachFile <> "" ' Start the loop.
FileCount = FileCount + 1
EachFile = FileLocation & "\" & EachFile
Set MyFile = Workbooks.Open(EachFile, False)
MyFile.SaveAs ThisWorkbook.Path & "\" & Left(MyFile.Name, Len(MyFile.Name) - 4) & ".xls", xlExcel7
nxt:
MyFile.Close False
EachFile = Dir ' Get next xls file
Loop
Application.ScreenUpdating = True
Application.EnableEvents = True
MsgBox FileCount & " wk4 file(s) have been converted to Excel format and saved in: " & ThisWorkbook.Path
Exit Sub
End Sub
|
| 02.29.2008 at 11:49PM PST, ID: 21020616 |
