Messages

76

General Software Discussion / Re: xls to png

« on: April 08, 2012, 05:46 PM »

Selection.CopyPicture Appearance:=xlPrinter, Format:=xlPicture
    checked this again, either it quit working or never did, sorry
Something always worth trying is recording a macro.  I just recorded it again but this time selected "as printed".

It's been a while since I've used Excel daily.  Back then I would have either been able to quickly give you the basic code to save files, or looked at something similar I'd already done (more likely) and then modified it.

I don't even remember which spreadsheets had the good file-related code I was using, so I'll first try to record something to see if it jogs the memory.  I'll get back to you.
 

77

General Software Discussion / Re: xls to png

« on: April 08, 2012, 05:26 PM »

I want to select cells in EXCEL and export them as image (screenshot) with one click

-kalos (April 06, 2012, 08:43 AM)

I'm still using Excel 2002, but the Shift-Edit thing works.  When I record using it to copy a picture or group of cells  to the clipboard, one line of code is generated:

Selection.CopyPicture Appearance:=xlScreen, Format:=xlBitmap

So this would be the first line of a macro you could assign to a button.  Select your picture or cells, click the button, and the picture is copied to the clipboard.

There is vba code to save files, etc.  When you say "export as image" you mean to a file?  What kind?

78

General Software Discussion / Re: web dir in excel

« on: April 05, 2012, 08:17 PM »

ASAP Utilities, indispensable!   

79

General Software Discussion / Re: Recommend a Free simple Database program for Windows XP

« on: April 04, 2012, 11:48 PM »

Sounded like basic stuff was all that was required.  If the level of functionality required would be met by a Word table that one could filter and query, a database manager might be overkill.

80

General Software Discussion / Re: Recommend a Free simple Database program for Windows XP

« on: April 04, 2012, 08:57 PM »

The main reason I don't just use a Microsoft Word (2002) table is there is no way to filter the table and perform queries.

-pschroeter (April 03, 2012, 11:41 PM)

If a "filterable and queriable" Word table would do the job, then why not use Excel?

81

General Software Discussion / Re: web dir in excel

« on: April 04, 2012, 08:49 PM »

For the first part, in the column to the right of the original cells, make a formula to append your constant text:
                        
    ="YourConstantText"&TheCellAddressToTheLeft

Then copy that formula down, so that each original cell has a cell to the right that now has your url.  (If you have no further need of the original column or the formula, first copy the second column over itself, using PasteValues to turn the formula into fixed data, and then delete the original column.)   Now you have a column of URLs.

Can't help you with the second part since I haven't done that sort of thing b4 and don't have time to play.  If no one here can help, it might be worth asking over in vbaexpress.com, particularly if it is something more easily done with macro code.

82

General Software Discussion / Re: restart router after few minutes of inactivity

« on: April 02, 2012, 08:36 PM »

You could always make a screensaver to do it

-Carol Haynes (April 02, 2012, 01:35 PM)

that's what I was thinking.  Plus I'd have a shortcut to manually activate the screensaver/reset script whenever I was getting up from the computer for more than a few minutes, so even if I came back in 5 minutes, the reset would be finished.

83

General Software Discussion / Re: restart router after few minutes of inactivity

« on: April 02, 2012, 01:10 PM »

...
is there a software to restart/reset my router after few minutes of inactivity?
...

-kalos (April 01, 2012, 03:41 PM)

When you say "inactivity", your goal is to have the reset happen when you are not working and would therefore not be inconvenienced by a reset?

84

General Software Discussion / Re: Whats your preferred web browser?

« on: March 25, 2012, 10:13 PM »

I've managed to stick with Firefox 3.6, and am still liking it quite a lot.

-mrainey (March 25, 2012, 07:32 PM)

Yeah, me too.  But I'm thinking I'm going to have to upgrade at some point, not looking forward to it.

85

Living Room / Re: how to find the oldest (=original) file on the Internet?

« on: March 25, 2012, 10:10 PM »

Didn't the internet start at some university?  That would be the 'original' stuff, I imagine...

-kunkel321 (March 25, 2012, 07:50 PM)

It started with ARPANET.  From Wikipedia:

The Advanced Research Projects Agency Network (ARPANET), was the world's first operational packet switching network and the core network of a set that came to compose the global Internet. The network was funded by the Defense Advanced Research Projects Agency (DARPA) of the United States Department of Defense for use by its projects at universities and research laboratories in the US. The packet switching of the ARPANET was based on designs by Lawrence Roberts of the Lincoln Laboratory.[1]

So the oldest file might be something military.

86

General Software Discussion / Re: Excel and third-party clipboard managers

« on: March 19, 2012, 10:01 PM »

I've been using an old version of ClipCache Pro with an old version of Excel (2002) with no problems for a long time.

87

Living Room / Re: URGENT Board Mod Request: Sobriety Mod

« on: March 10, 2012, 08:39 AM »

http://www.breathaly...-Kit-p/al9000usb.htm

It includes "pc connectivity software", so I wonder if it  can be set up like an automobile ignition breathalyzer interlock  

88

General Software Discussion / Re: Change the icon for a program

« on: March 08, 2012, 11:36 PM »

If what you are interested in is the icon for .pdf files, you should be able to change the icon for that association (in XP it's the Folder Options dialog, File Associations tab).

If you are talking about the icon on the taskbar, that's something else.

89

General Software Discussion / Re: customize outlook context menus

« on: February 26, 2012, 03:53 PM »

Don't know much abt Outlook, but have added many things to Word and Excel context menus.

Word has an easy way to do this, Excel doesn't.  But in Excel you can change any context menu selection by using VBA.

I'm thinking you can change an Outlook context menu with VBA.

90

General Software Discussion / Re: visual basic for applications, where to go for resources and solved examples?

« on: February 26, 2012, 03:47 PM »

try VBA Express

http://www.vbaexpress.com/

91

Living Room / Re: Get Britain Working (But we won't pay you...)

« on: February 24, 2012, 07:29 AM »

Perhaps the greatest myth of the 20 and 21st centuries are convincing people that the debt on your credit card is the same as the national debt.

-rgdot (February 22, 2012, 05:43 PM)

And most of the people perpetuating this myth know better, know that the national debt is similar to debt on a business's balance sheet, an investment in the future if done properly, and money well spent.  

The intellectual dishonesty is staggering, if not surprising.

92

General Software Discussion / Re: Looking for a "virtual scanner' software in one pass, outputting in PDF.

« on: February 21, 2012, 12:17 PM »

I googled "print to jpg" just out of curiousity, several things there.

If you could print directly to a jpg or tiff (with no loss of quality), may be you could write a script to send the graphic output to a pdf maker etc.

93

Post New Requests Here / Re: IDEA: VBA (?) Utility to export info on Word 2010 styles to .csv or .txt file

« on: February 16, 2012, 08:50 PM »

Check out VBAExpress.  Here's some discussion re what you are looking for:

http://www.vbaexpres...owthread.php?t=36546

In that thread there is simple code to list the styles available:

[Select]

Public Sub SampleMyStyles()
    Dim mySty As Style
    With ActiveDocument
        For Each mySty In .Styles
            If .Styles(mySty.NameLocal).InUse = True Then
                Selection.TypeText mySty.NameLocal & vbCr
            End If
        Next
    End With
End Sub

But seeing only the styles currently in use requires extra steps, discussed in the thread.

This code just outputs the styles into the current document at the current cursor position, which is fine for testing the output if you put the cursor at the end of the file. Output into a separate text file would not be too difficult.  Someone at VBAExpress can tell you if there are parameters to list Font Name, Size, etc.

94

General Software Discussion / Re: numerical input

« on: February 08, 2012, 02:36 PM »

Learning to use a 10-key number pad is far easier than learning touch-typing.

And Ath is right, keying numbers that way is much much faster than saying them.  One possible exception would be strictly single digit numbers if the verbal integers didn't require an "Enter" or "Plus" between digits and the keypadder did.

95

General Software Discussion / Re: pdf context menu

« on: February 03, 2012, 01:48 PM »

if what you want can be called from a command line (C:\...\someprogram.exe parameters) you can always add it to a File Type's context menu thru the File Types tab (Advanced button) in Folder Options, at least in XP.

96

General Software Discussion / Re: anything more advanced than mail merge?

« on: January 29, 2012, 08:02 PM »

You could ask over at VBAExpress:

http://www.vbaexpress.com/forum/

97

General Software Discussion / Re: anything more advanced than mail merge?

« on: January 29, 2012, 12:24 PM »

You could try this in Word and/or Excel with a little VBA.

Especially if the only (or mostly the only) thing you need that mailmerge can't do is to pick which draft to use - use vba for that part and then start the mailmerge.  Or just use vba for the whole thing.

98

Living Room / Re: Looking for password "scheme" suggestions

« on: January 26, 2012, 07:01 PM »

Does cam low profile alter valve train component acceleration?

-4wd (January 26, 2012, 06:20 PM)

yes

99

Living Room / Re: Ripped off as an employee? "Free food" + the employment contract.

« on: January 24, 2012, 08:51 PM »

When you accept a perk over the cash equivalent, you are in reality making a deal to let someone else manage your money, with no say or control over how it is spent.

-app103 (January 22, 2012, 12:57 PM)

Can you say "Employer-provided Health Insurance"?

Hard bargaining is a lie, especially when it comes to skills.  And people that bargain that way don't value what they've bargained for.

-wraith808 (January 22, 2012, 01:16 PM)

Very very true!

100

General Software Discussion / Re: Recommend less known macro apps and text expanders

« on: January 21, 2012, 02:59 PM »

Been using AutoHotkey and MacroExpress.  One or the other is better or easier for this or that.  I have a few ME macros that call an AH script.  I've been pleased.