Messages

1426

General Software Discussion / Re: ctrl + tab (first in, first out history) for excel sheets?

« on: April 03, 2007, 08:42 PM »

Yes! This it it! perfect!

-urlwolf (April 03, 2007, 08:04 PM)

Got there in the end 

It also will open WorkBooks that you've closed 

Didn't mention that Chase Dependants button only automatically activates Dependants located on the current sheet (Excel restriction), otherwise it displays the links.

Did you sort out the issues with the other Add-In?

I couldn't install the new one (because of privileges), but the older one works fine: ie both together.

1427

General Software Discussion / Re: ctrl + tab (first in, first out history) for excel sheets?

« on: April 03, 2007, 06:02 PM »

Do you have any idea why?
Office 2007, win XP SP 2 here.

-urlwolf (April 02, 2007, 07:00 PM)

None at all: I can't install it here so it'll have to wait until I get home.

I've attached the new version of the Add-In. This includes:

• CTRL+TAB: Windows style forward navigate through view history
  
• CTRL+TAB+SHIFT: Windows style backward navigate through view history
  
• Back Button: Browser style back through view history
  
• Forward Button: Browser style forward through view history
  
• Follow: Follow's References
  
• Chase: Follow's Dependants (Cell's referencing selected cell)

See how you go...

1428

General Software Discussion / Re: ctrl + tab (first in, first out history) for excel sheets?

« on: April 02, 2007, 09:10 PM »

Perry, for some reason, when I moved yout addin to C:\Documents and Settings\UserName\Application Data\Microsoft\AddIns, my 'other' favorite addin stopped working.

-urlwolf (April 02, 2007, 07:00 PM)

Stopped working or did not open?

If it didn't open you can go to Tools > Add-Ins and select it, and it should open automatically in future.

You should be able to open as many as you like  But I don't have Office2007, but I'd think it should work the same.

I've also got the ALT+TAB  working the way you'd like it to work (I think): now there's the best of both worlds:

• ALT+TAB and ALT+SHIFT+TAB to navigate through Windows Style
  
• Buttons to navigate through Browser Style

I'll upload it when I get home from work 

1429

General Software Discussion / Re: ctrl + tab (first in, first out history) for excel sheets?

« on: April 02, 2007, 08:50 AM »

Is this easy to implement?

-urlwolf (April 02, 2007, 08:38 AM)

I'm working on it... It's getting there...

1430

General Software Discussion / Re: ctrl + tab (first in, first out history) for excel sheets?

« on: April 02, 2007, 08:00 AM »

example. We have tabs A-C, and we click A, B, C. We are in C now, doing some work. I want to go back to B, so I hit ctrl tab. check some data, then I want to go back to C, and hit ctrl tab (as in windows alt tab). The current code takes me to A, not to C.

-urlwolf (April 02, 2007, 07:44 AM)

You're right, it's more like a Browser History.

So you browse from A > B > C,
press GoBack = B
press GoForward = C
press GoBack = B
press GoBack = A
press GoForward = B

Hmm, that's what made sense at the time 

1431

General Software Discussion / Re: ctrl + tab (first in, first out history) for excel sheets?

« on: April 02, 2007, 07:55 AM »

You are right 
 CTRL+ALT+TAB is a contorsion for me.
I'll try to change it on the code.

-urlwolf (April 02, 2007, 07:33 AM)

No, don't worry, try the attached.

The penny's finally dropped that you don't want to cycle through the WorkSheets, so I've removed it 

The Add-In is now set:

• CNTL+TAB goes back in the view history
  
• CNTL+SHIFT+TAB goes forward

I've also added a function that I find very handy: FollowReference. I don't know about you, but my sheets tend to reference lots of other cells. FollowReference will activate the referenced cell (if it can figure it out) or display the Precendants for you to choose.

I've also added buttons to the tool bar.

I've just a bit of a play, and everything seems to work without falling apart gracelessly 

Most of the settings are at the top of the WorkHistory Module: HotKey combinations, number of "views" to remember.

Then, how do I make this change "permanent" (i.e., opening with excel everytime)?

-urlwolf (April 02, 2007, 07:33 AM)

You just put it into your Excel Add-In directory, the location of which depends what version of Windows you are running:
For Excel 2007 for the PC, the default path to this folder is for Windows XP, and probably Vista:

[Select]

C:\Documents and Settings\UserName\Application Data\Microsoft\AddIns

For Excel 2003, XP and 2000 for the PC, the default path to this folder is for Windows 2000 or Windows XP:

[Select]

C:\Documents and Settings\UserName\Application Data\Microsoft\AddIns

or, if user profiles are used on your computer:

[Select]

C:\Windows\Profiles\UserName\Application Data\Microsoft\AddIns

or, for older Windows operating systems:

[Select]

C:\Windows\Application Data\Microsoft\AddIns

For Excel 97 for the PC, the default path is:

[Select]

C:\Program Files\Microsoft Office\Office\Library

Hope that helps, let me know if things don't work,
Perry

1432

General Software Discussion / Re: ctrl + tab (first in, first out history) for excel sheets?

« on: April 02, 2007, 05:55 AM »

Yes, I'm  using Navigate.xls, but not getting the "back to recently viewed worksheets" functionality. I get exactly the same functionality as when I do ctrl + page up/down. Is this what I should be getting?

-urlwolf (April 02, 2007, 04:35 AM)

I think you're using CTRL+TAB not CTRL+ALT+TAB?

1433

General Software Discussion / Re: ctrl + tab (first in, first out history) for excel sheets?

« on: April 02, 2007, 03:49 AM »

Hi Kevin:

One comment... why ctrl-alt-tab?  Why not ctrl-shift-tab?  Most of the programs that I've seen that use ctrl-tab add shift to go background.  But, since it's in vba, it's easily customizable! 

-kfitting (April 01, 2007, 12:30 PM)

I agree, as set up in the last Add-In: CTRL+TAB navigated forward through the open WorkSheets; CTRL+ALT+TAB navigated backwards through the view history (different functionality). I was going to use CTRL+ALT+SHIFT+TAB to go forward through the backward navigated history.

But it's editable anyway.

- Perry

1434

General Software Discussion / Re: ctrl + tab (first in, first out history) for excel sheets?

« on: April 02, 2007, 03:02 AM »

I have magnaged to get some runtime errors. I deactivated all my other addins (that's how interested I am in this ctrl + tab functionality!), and have gotten rid of the runtime errors. However, the history doesn't work as expected (like normal windows ctrl + tab)... in my system, it just goes to next open sheet, not the last used. Example, imagine I have sheets A B C D E. I work on A, then click on C, and want to go back to A by doing ctrl + tab. The current implementation (at least in my system) goes to D (the SheetNumber ++), not to A.

-urlwolf (April 01, 2007, 03:56 PM)

Are you using Navigate.xls?

If so, CTRL + TAB Navigates through your open worksheets (as mentioned above)
CTRL + ALT + TAB Navigates back through your recently viewed worksheets (I think as you're requesting)

The keypresses are certainly editable.

Last night I aslo implemented a forward as well as a backward navigate through your view history.

I'll pop it up later

1435

General Software Discussion / Re: ctrl + tab (first in, first out history) for excel sheets?

« on: April 01, 2007, 07:37 AM »

Hi: I've made a few changes to the original Add-In, as detailed below...

Thanks Perry, that is an interesting piece of code.

-urlwolf (March 30, 2007, 12:18 PM)

I'm pretty adicted to it now: some of my workbooks have got quite a few sheets in them and if you expand the sheet tab area you loose scroller width.

With a shortcut to get to the find box, it can make switching between sheets pretty snappy. I'd still prefer to have something like ctrl + tab, though.

-urlwolf (March 30, 2007, 12:18 PM)

I've added code so that clicking the "refresh" button is not necessary (so I removed the button) 

I've also added other code to:

• Navigate through WorkSheets of the open WorkBook [CTRL + TAB]
  
• Navigate backwards through the History [CTRL + ALT + TAB]

kfitting posted almost the same code I wrote last night  , which navigates through the WorkSheets of the current WorkBook using CTRL + TAB keypress. I'm not sure if that's what you wanted or not?

Using CTRL + ALT + TAB will navigate backwards through the history of viewed WorkSheets.

As usual, to use this Add-In, load it through the Tools / Add-Ins menu.

- Perry

1436

General Software Discussion / Re: ctrl + tab (first in, first out history) for excel sheets?

« on: April 01, 2007, 05:49 AM »

Try the code below.

-kfitting (March 31, 2007, 02:07 PM)

Nice work: this was my next attempt too 

If it works as you want, I'll tell you how to get it to be present whenever you start excel (it's not intuitive and I don't know it off the top of my head... it involves making a personal.xls file and putting the following code in the workbook code module in an event function... if this works I'll step through that!)

-kfitting (March 31, 2007, 02:07 PM)

You just make an Add-In (like the one I attached to my first reply, and you can either let Excel add it in automatically by saving it in ...\Application Data\Microsoft\AddIns (Depending on your windows version); alternatively you can save it anywhere and load it manually.

- Perry

1437

General Software Discussion / Re: ctrl + tab (first in, first out history) for excel sheets?

« on: March 30, 2007, 10:36 AM »

but why are excel addins so pricey?

-urlwolf (March 30, 2007, 07:03 AM)

I think $30 is pretty standard for a professional Add-In (don't know how professional the one you mentioned is), probably because they're aimed at the business market: but there are lots of good free ones about too (although I couldn't find a ready-made menu for you).

- Perry

1438

General Software Discussion / Re: ctrl + tab (first in, first out history) for excel sheets?

« on: March 30, 2007, 10:33 AM »

Try the attached.

I found the code at http://www.contextur...com/xlToolbar01.html

Unfortunately I added a sort routine before I realised you wanted "first in first out": sorry. You can always add the original code back in if you like, but I thought that a sorted list was better (especially if tabs are turned off).

Anyway, hope that helps,
Perry

1439

General Software Discussion / Re: backup question: how to backup/sync my HD and USB HD #1 to USB HD #2?

« on: March 29, 2007, 10:41 AM »

Sounds like a job for Allway Sync or SyncBack 

I tried SyncBack some time ago to back up to my FTP, but had problems getting it to work so I opted for Corban (which does the job nicely for me). Though I have used SyncBack quite successfully in other situations.

I'm about to give Allway Sync a go (for my very similar scenario) to see how it goes.

But they both should do the job. I have no idea which is better though: anyone else??

- Perry

1440

General Software Discussion / Re: screen capture tool that appends captures to single image?

« on: March 23, 2007, 05:30 AM »

i think he meant something like this: Re: Photo panorama creation

-lanux128 (March 22, 2007, 10:12 PM)

I'm pretty sure Nod5 just meant "stitching" as in joining together, not the positioning & blending that happens with panoramas.

There are some added benefits of this method, especially if the images are not going to be commented/referenced individually. For example: I wanted a block of images, 5 wide and 2 high, which are examples of my desktop for inserting into Word. They wont be titled, they'll just sit there together... it'd be easier (in Word) to have them as a single image to import and move where I like.

I know I could import all 10, position them, and group them, but this sounds nicer 

To me it sounds like something that should be run from within ScreenShotCaptor, or accessible from the Context menu?

- Perry

1441

General Software Discussion / Re: Photo panorama creation

« on: March 22, 2007, 07:46 AM »

Glad to have you back on the topic again... I know that I really enjoyed reading what you've posted previously, and it almost resulted in a purchase; but there was a little too much competition for the $$$ at that stage. ...so thanks!! 

I know my back burner gets pretty expansive at times: I have to keep reminding myself that the computer was bought for me, not the other way around 

- Perry

1442

General Software Discussion / Re: Photo panorama creation

« on: March 22, 2007, 06:35 AM »

Here's another panorama maker, recently mentioned at snapfiles
 (http://www.snapfiles...r/zonerpanorama.html)
Its Zoner Panorama Maker for $9.99, website http://www.zoner.com/

-tsaint (August 23, 2006, 03:59 AM)

I don't know if this is needly reviving an old thread, but GiveAwayOfTheDay is giving Zoner away for free (for the next 19 hours anyway...)

I have not tried it either, and am probably unlikely to at this stage, but for anyone else who'd like to try, it's there...

- Perry

1443

General Software Discussion / Re: screen capture tool that appends captures to single image?

« on: March 22, 2007, 06:27 AM »

funny you should post this -- i have thought for a while about adding such a feature to my ScreenshotCaptor program.. it's not that hard to imagine cases where it might be useful.. the only thing that has really kept me from adding it is the thought that it might be more useful to make a general purpose program for arranging multiple images in such arragements easily via drag+drop.. 

-mouser (March 21, 2007, 07:44 PM)

Like an export option? That would work nicely inside of ScreenShot Captor, as that would be the programme doing the capturing.

SnagIt (which we're given at work) has a not-too-disimilar feature where you can add multiple objects from the one screen to one image (via multi-click), which means you can "composit" your base image more easily if it requires more than one window... but that's not what Nod5 was wanting anyway (but I thought I'd mention it anyway )

1444

General Software Discussion / Re: Text xpander that can handle RTF

« on: March 22, 2007, 02:08 AM »

Could you try our product, ATopSoft DeskCake?
The web link is
http://www.atopsoft....m/products/deskcake/

-atopsoft (March 21, 2007, 12:26 AM)

Hey, Hi and Welcome! It certainly looks good, if not a little over-featured.

But I really like the look of AutoSave! It's AutoBackUp is similar to File Hamster (which really is a great programme!

- Perry

1445

General Software Discussion / Re: Text xpander that can handle RTF

« on: March 20, 2007, 07:53 AM »

I'd assume that it's not just to expand the text with the current position's formatting, but to expand it with the "saved" formatting?? 

For example: If I want "clr" to expand into "Colour", there's no way a simple expanding is going to work.

- Perry

1446

Post New Requests Here / Re: Save web page to directory based on web site in browser title

« on: March 20, 2007, 04:35 AM »

I use SurfuLater to do this, either as a full page or as a bookmark (depending on what I want to do with the information).

But there are quite a few other similar applications that sit outside of the browser that should do what you want.

The beauty of an application like SurfuLater is that moving stuff around is really simple.

- Perry

1447

General Software Discussion / Re: can anybody help with a word/excel mail merge query?

« on: March 15, 2007, 08:44 AM »

I think you are right: you are asking the wrong question 

I've just had a play with using a series of NEXTIF, SKIPIF, IF's, bookmarks etc but it's all too complex. It's just not the way mail merges are meant to work!

I'd suggest writing a macro to transform your original data source into a one line per person type file: that's the way mail merges should work.

Probably the easiest way to handle the different numbers of 'Pages' for each person is to concatenate them into a single field (possibly with linebreaks if that suits with your letter).

Let me know if you need a hand with the macro.

- Perry

1448

Mini-Reviews by Members / Re: Mini-Review of FirstDefense-ISR (Raxco Software)

« on: March 12, 2007, 07:37 AM »

Are there any errors/interruptions when you create the archive?

-AdIyhc (March 05, 2007, 07:36 AM)

What's the story on that?? I was trying to Archive my primary snapshot to an external HD and it always fails; whilst archiving other snapshots works fine??

- Perry

1449

ProcessTamer / Re: MS Word2000?

« on: February 20, 2007, 04:47 AM »

has anybody out there had success "taming" MS Word2000?
would much appreciate to hear which settings work.

-chrisk (February 20, 2007, 04:01 AM)

Anything in particular? I use the Office2000 suite at home, without too many issues 

- Perry

1450

General Software Discussion / Re: Software for planning wood bookcases/cabinets/tables etc?

« on: February 07, 2007, 07:24 AM »

In the end, you'll probably be cursing and swearing and regretting that you didn't just buy some standard modular bookcases, though. At least I know I would.

-f0dder (February 07, 2007, 06:06 AM)

Heck no... it's great fun (and tribulation which did result a quite a bit of cursing and swearing): but I'm glad I did it. Though when I built our bedroom cupboards it took a lot longer than a weekend!

- Perry