Replies

BATcher,

Thanks for the nice reference!

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

John,

Been there, done that!

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

I think you’ll find that this line:

Activeworkbook.names.add Name:=”your name here”, _
 RefersTo:=selection.currentregion.address(,,xlR1C1)

should be:

Activeworkbook.names.add Name:=”your name here”, _
 RefersToR1C1:=selection.currentregion.address(,,xlR1C1)

Rory, Right your are, it should be! Interestingly it will work the other way at least in 2003 it still generates the same reference for the name!

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Only just now had a chance to look at this again.

Unfortunately they seem to have removed this in later versions. In both 2007 and 2010 I find it hard to find the Sort and Group Dialog (Is it a Design Issue or an Arrange Issue or a Format issue?) so I was hoping this right click would work.

John,

Could this be because you are trying to do it on a Form vs a Report?
I tried it on my Laptop with 2007 and it’s there, see below.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Itconc,

Can you post your Access Import code?
I tested the create range name code on an excel sheet I have and the name showed up when I tried to use Names,paste.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Ok guys am I missing something here? Why not just email the link? If you’re using FireFox you can get the EmailThis addon, just click the icon opens up Outlook with the link in the body, address it and send.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Eric,

I used to teach C and the two books on my must have list are:
“The C Programming Language, 2nd Ed.” Brian W. Kernighan & Dennis M. Ritchie, ISBN:0-13-11-362 – This is basically the Bible for the C language even though it’s not a large book.
“C The Complete Reference” Herbert Schildt, ISBN: 0-07-881263-1 – This is the book I used as the course text reference.

C is a great language…good luck in your quest!

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Welcome to the lounge.

Try this.

Here’s another one.

Here’s the BEST one! See picture below. Make sure you go to the link for instructions!

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

The Ctrl-Scroll wheel will only work in a browser.

Russ,

Sorry, but I beg to differ. That little trick works just fine on my Windows 7 desktop adjusting the size of the icons on the desktop.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Ron,

The knowledge base on this forum is vast, however, I think you might do better posting this question on one of the Linux forums as that community is focused on that OS and you’re much more likely to find someone with your particular hardware or someone who has asked the same question before. Of course, I’m sure someone here will probably prove me wrong.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Neil,

Try holding your Ctrl key while scrolling your mouse wheel. This is something that can be done inadvertently.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

There are some ideas here
Hands off my master

John,

Thanks.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

What you need is:

Application.displayalerts = false
{your save code}
Application.displayalerts=true

For the rangename try:

Activeworkbook.names.add Name:=”your name here“, _
RefersTo:=selection.currentregion.address(,,xlR1C1)

Note: the above assumes your cursor is located within the current region! If not you need to locate it there first or do a selection of the current region first then delete the .currentregion from the above code.

Note 2: Don’t miss the two commas in the arguments to the Address property! If you want you can replace that with .address(ReferenceStyle:=xlR1C1)

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

John,

Top O’ The Day to Ya! and welcome to the lounge. Gee if only you posted that a Year and a half ago when I trashed ALL my floppies. I know there was a copy of Windows 3.1 along with a couple of DOS 6.1’s. Good luck with your search.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Dick,

Ok here goes:

Acronis True Image – Backups – Images
RoboCopy – Intermittent data backups
SyncToy 2.1 – keep Desktop & Laptop data files syncronized.
FEBE – {firefox addin} – Backups of FF data.
CCleaner – Clean temp files & registry.
AutoRuns – See what’s starting up at boot.
What’s Running – Use if machine seems to be getting slow.
Auslogic Defragger – DeFrag HD {don’t do this as often since XP introduced NTFS partitions}
Belarc Advisor & SIW – System Information
Acronis Disk Director – Work with disk partitions w/o loosing data {I still do an Image Backup first!}

With the exception of the Acronis products the rest are FREE!
That should keep you busy for a while…

Ok guys what did I miss that YOU can’t do with out.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs