Advertisement
Advertisement
| 07.02.2008 at 09:38PM PDT, ID: 23535838 |
|
[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! |
||
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: 36: 37: 38: |
Sub a105__Move_ALERT_REPORT_Sheet_to_SMOOTHTRADES_Directory_for_Webposting()
'TURN REFRESH & ALERTS OFF
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Application.Calculation = xlCalculationManual
'SELECT "ALERT REPORT" and HIDE SPECIFICS COLUMNS
Sheets("2 Alert Report").Select
Range("E:E,F:F,G:G,H:H,J:J,K:K,L:L,N:N,V:V,Y:Y,AA:AA,AB:AB,AC:AC").Select
Range("AC1").Activate
Selection.EntireColumn.Hidden = True
'COPY ALERT REPORT SHEET to NEW BOOK
Sheets("2 Alert Report").Select
Sheets("2 Alert Report").Copy
'????
'Is there a way I could DELETE the file named dar_current.htm (located at the pathway below)
'so that the "save as" statements will not need to overwrite the previously existing file?
ChDir "C:\Program Files\Yahoo SiteBuilder\sites\sites\smoothtrades.com"
ActiveWorkbook.SaveAs Filename:= _
"C:\Program Files\Yahoo SiteBuilder\sites\sites\smoothtrades.com\dar_current.htm" _
, FileFormat:=xlHtml, ReadOnlyRecommended:=False, CreateBackup:=False
'RETURN TO PREVIOUS WINDOW and CONTINUE PROCESSING
Windows("S3_Watch.xlsm").Activate
ActiveWindow.WindowState = xlNormal
ActiveWindow.WindowState = xlNormal
Range("A1").Select
'TURN REFRESH & ALERTS BACK ON
Application.ScreenUpdating = True
Application.DisplayAlerts = True
Application.Calculation = xlCalculationAutomatic
End Sub
|