Click here to Skip to main content
15,892,768 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Custom Events Pin
Dave Kreskowiak4-Dec-09 3:40
mveDave Kreskowiak4-Dec-09 3:40 
QuestionCheck file infection by CRC32 Pin
Gagan.203-Dec-09 23:04
Gagan.203-Dec-09 23:04 
AnswerRe: Check file infection by CRC32 Pin
David Skelly3-Dec-09 23:19
David Skelly3-Dec-09 23:19 
GeneralRe: Check file infection by CRC32 Pin
Gagan.204-Dec-09 5:05
Gagan.204-Dec-09 5:05 
GeneralRe: Check file infection by CRC32 Pin
Dave Kreskowiak4-Dec-09 5:34
mveDave Kreskowiak4-Dec-09 5:34 
GeneralRe: Check file infection by CRC32 Pin
David Skelly4-Dec-09 6:14
David Skelly4-Dec-09 6:14 
AnswerRe: Check file infection by CRC32 Pin
Gagan.204-Dec-09 14:56
Gagan.204-Dec-09 14:56 
QuestionPivotTable Strategery Pin
Bomb_shell3-Dec-09 11:31
Bomb_shell3-Dec-09 11:31 
So...lemme ask you guys this:
I'm trying to automate a [crappy] pivot table [that doesn't belong to me] where the data is time-phased. Meaning, that each week when I get the pivot table, the date range will be different.

So, how would you attack the problem of only viewing the last four weeks of data?

I wrote some simple pivottable code, but need to make it so the dates are non-specific:
Sub DUMMY()
'
' DUMMY Macro
'

'
    With ActiveSheet.PivotTables("PivotTable2").PivotFields("Weekend Sunday Date")
        .PivotItems("20090802").Visible = False
        .PivotItems("20090809").Visible = False
        .PivotItems("20090816").Visible = False
        .PivotItems("20090823").Visible = False
        .PivotItems("20090830").Visible = False
        .PivotItems("20090906").Visible = False
        .PivotItems("20090913").Visible = False
        .PivotItems("20090920").Visible = False
        .PivotItems("20090927").Visible = False
        .PivotItems("20091004").Visible = False
        .PivotItems("20091011").Visible = False
        .PivotItems("20091018").Visible = False
        .PivotItems("20091025").Visible = False
        .PivotItems("20091101").Visible = False
    End With
End Sub

How would you identify the range of dates and then pick the last four to be visible?
AnswerRe: PivotTable Strategery Pin
freakyit4-Dec-09 4:06
freakyit4-Dec-09 4:06 
GeneralRe: PivotTable Strategery Pin
Bomb_shell10-Dec-09 5:20
Bomb_shell10-Dec-09 5:20 
QuestionVB.Net MTAThread attribute (.Net 3.5) Pin
#realJSOP3-Dec-09 5:21
mve#realJSOP3-Dec-09 5:21 
AnswerRe: VB.Net MTAThread attribute (.Net 3.5) Pin
Duncan Edwards Jones3-Dec-09 5:42
professionalDuncan Edwards Jones3-Dec-09 5:42 
AnswerRe: VB.Net MTAThread attribute (.Net 3.5) Pin
Rama Krishna Vavilala3-Dec-09 5:48
Rama Krishna Vavilala3-Dec-09 5:48 
QuestionUsing Combobox as DataGridViewColumn Pin
EvanSaunders3-Dec-09 2:37
EvanSaunders3-Dec-09 2:37 
Questionhow can I built Hyperterminal functionality in vb.net Pin
Amanjot2-Dec-09 13:38
Amanjot2-Dec-09 13:38 
AnswerRe: how can I built Hyperterminal functionality in vb.net Pin
Dave Kreskowiak4-Dec-09 6:57
mveDave Kreskowiak4-Dec-09 6:57 
QuestionBouncing Ball Pin
rbjanaki2-Dec-09 12:57
rbjanaki2-Dec-09 12:57 
AnswerRe: Bouncing Ball Pin
Luc Pattyn2-Dec-09 13:13
sitebuilderLuc Pattyn2-Dec-09 13:13 
QuestionUninstalling a program Pin
RyJaBy2-Dec-09 7:04
RyJaBy2-Dec-09 7:04 
AnswerRe: Uninstalling a program Pin
The Man from U.N.C.L.E.2-Dec-09 7:34
The Man from U.N.C.L.E.2-Dec-09 7:34 
GeneralRe: Uninstalling a program Pin
RyJaBy4-Dec-09 6:38
RyJaBy4-Dec-09 6:38 
GeneralRe: Uninstalling a program Pin
Dave Kreskowiak4-Dec-09 6:57
mveDave Kreskowiak4-Dec-09 6:57 
GeneralRe: Uninstalling a program Pin
RyJaBy7-Dec-09 9:37
RyJaBy7-Dec-09 9:37 
GeneralRe: Uninstalling a program Pin
Dave Kreskowiak7-Dec-09 14:50
mveDave Kreskowiak7-Dec-09 14:50 
GeneralRe: Uninstalling a program Pin
RyJaBy9-Dec-09 7:30
RyJaBy9-Dec-09 7:30 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.