# IT/Excel/huge nerd

**URL:** <https://forums.speedlife.net/t/it-excel-huge-nerd/16704>\
**Category:** NYSpeed Off Topic\
**Created:** [August 30, 2006, 6:56am UTC](https://forums.speedlife.net/t/it-excel-huge-nerd/16704 "2006-08-30T06:56:37Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![zwarbyt](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/zwarbyt/32/7623_2.png) [@zwarbyt](https://forums.speedlife.net/u/zwarbyt)\
**Post date:** [August 30, 2006, 6:56am UTC](https://forums.speedlife.net/t/it-excel-huge-nerd/16704/1 "2006-08-30T06:56:37Z")

</div>

i have a display (flatscreen) in our telemarketing area that displays month to date stats from our sql database (using excell) also It has a ranking for a different department (seperate spreadsheet)

is there any program that will either

A. tab between them at say a 5 minute interval

or

B. display them as a screensaver fading between the two

and before you ask they can’t be dumped onto the same page the resolution isnt great and theres too much info to have them on the same page

thanks

---

<div class="post-metadata">

**Author:** ![Locutus](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/locutus/32/7574_2.png) [@Locutus](https://forums.speedlife.net/u/Locutus)\
**Post date:** [August 30, 2006, 7:08am UTC](https://forums.speedlife.net/t/it-excel-huge-nerd/16704/2 "2006-08-30T07:08:01Z")

</div>

tab between each sheet?

is the sheet being activly updated or is it static?

---

<div class="post-metadata">

**Author:** ![zwarbyt](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/zwarbyt/32/7623_2.png) [@zwarbyt](https://forums.speedlife.net/u/zwarbyt)\
**Post date:** [August 30, 2006, 7:49am UTC](https://forums.speedlife.net/t/it-excel-huge-nerd/16704/3 "2006-08-30T07:49:00Z")

</div>

activly updated… every minute

is there anything that will auto-tab? like a script?

---

<div class="post-metadata">

**Author:** ![Locutus](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/locutus/32/7574_2.png) [@Locutus](https://forums.speedlife.net/u/Locutus)\
**Post date:** [August 30, 2006, 7:50am UTC](https://forums.speedlife.net/t/it-excel-huge-nerd/16704/4 "2006-08-30T07:50:08Z")

</div>

im sure there is… if it was static it would be easier… our programmer was went to another company, too bad though, cus he would be able to do it…

hrmmm let me ponder i mightbe able to figure it out.

---

<div class="post-metadata">

**Author:** ![Locutus](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/locutus/32/7574_2.png) [@Locutus](https://forums.speedlife.net/u/Locutus)\
**Post date:** [August 30, 2006, 7:51am UTC](https://forums.speedlife.net/t/it-excel-huge-nerd/16704/5 "2006-08-30T07:51:31Z")

</div>

so wait. this excel doc is actvly updated by the sql data base…

all you need it to do is tab to each sheet within one workbook?

---

<div class="post-metadata">

**Author:** ![zwarbyt](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/zwarbyt/32/7623_2.png) [@zwarbyt](https://forums.speedlife.net/u/zwarbyt)\
**Post date:** [August 30, 2006, 7:57am UTC](https://forums.speedlife.net/t/it-excel-huge-nerd/16704/6 "2006-08-30T07:57:22Z")

</div>

eh, right now they are seperate files, but they could be combined into one doc

---

<div class="post-metadata">

**Author:** ![zwarbyt](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/zwarbyt/32/7623_2.png) [@zwarbyt](https://forums.speedlife.net/u/zwarbyt)\
**Post date:** [August 30, 2006, 8:01am UTC](https://forums.speedlife.net/t/it-excel-huge-nerd/16704/7 "2006-08-30T08:01:35Z")

</div>

nevermind my excel buddy is sending me something in VBcode to change it

---

<div class="post-metadata">

**Author:** ![Locutus](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/locutus/32/7574_2.png) [@Locutus](https://forums.speedlife.net/u/Locutus)\
**Post date:** [August 30, 2006, 8:02am UTC](https://forums.speedlife.net/t/it-excel-huge-nerd/16704/8 "2006-08-30T08:02:17Z")

</div>

basterd… 😉

there has to be a way to automate alt+tab to a system… cept im not a programmer 🙂

---

<div class="post-metadata">

**Author:** ![zwarbyt](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/zwarbyt/32/7623_2.png) [@zwarbyt](https://forums.speedlife.net/u/zwarbyt)\
**Post date:** [August 30, 2006, 10:11am UTC](https://forums.speedlife.net/t/it-excel-huge-nerd/16704/9 "2006-08-30T10:11:13Z")

</div>

if anyone cares, set a macro in vb (altf11)

```
                Private NextSwitch As Date
               
                ' ***** HERE IS WHERE YOU SET THE VARIABLES (not case sensitive)
                Const File1 As String = "Filename 1.xls"
                Const File2 As String = "Filename 2.xls"
                Const TimeInterval As String = "00:02:00"

```

'“hh:mm:ss”

```
                Sub StartSwitching()
                 NextSwitch = Now + TimeValue(TimeInterval) 'current time + 2 minutes, change as needed
                 Application.OnTime EarliestTime:=NextSwitch, Procedure:="ShowNext"
                End Sub
               
                Sub EndSwitching()
                 Application.OnTime EarliestTime:=NextSwitch, Procedure:="ShowNext", Schedule:=False
                End Sub
               
                Private Sub ShowNext()
                 If LCase(ActiveWorkbook.Name) = LCase(File1) Then
                  Workbooks(File2).Activate
                 Else
                  Workbooks(File1).Activate
                 End If
                 NextSwitch = Now + TimeValue(TimeInterval)
                 Application.OnTime EarliestTime:=NextSwitch, Procedure:="ShowNext"
                End Sub
```