Recent content by KenPuls

Hi sudakov, Yes, this can certainly be done. A couple of key questions: 1) What version of Word are you using? 2) Do you have anything against downloading a free piece of software to use? Reasons I ask... 1) If you are using Word 2007 or 2010, you can automate the process using default...

I can't see why it wouldn't... I don't have Sharepoint, so I can't test this, but my understanding is that you build your workbook in Excel, then upload it to the Sharepoint server where it is rendered in Excel Services. The data connections that you've created to Oracel or MS SQL in your...

Sorry, still don't follow. Are you using the code from my site (using PDF Creator) or the code from this thread (using Distiller, posted by macropod)? If you're using the PDFCreator code, then Adobe settings won't make any difference. If you are using Adobe, I'm not sure if Adobe's Distiller...

That setting should not be controlled by the print driver, but rather the pagesetup. You may want to take a look at your page setup manually, to see if it is indeed portrait, and then review your code to see if you toggle the settings there. Also, you still haven't said what program you...

Hi everyone, I noticed that you're testing for file existence with Dir. If you decide to get into testing directories with Dir for any reason, just be aware that it won't return true if there is no FILE in the directory (even if there are subdirectories.) I created a function to test if a...

Try looking up the cDate function. It's used to convert textual dates to actual dates. HTH, Ken Puls, CMA www.excelguru.ca

If you are more interested in the PDF route, I'll throw in a second vote for PDF Creator. It's an awesome little free application that works very well. It also exposes its classes to VBA, so that you can code it as well, as I show here: http://www.excelguru.ca/node/21 Ken Puls, CMA...

Go in to the workbook, and right click your controls. -If it comes up with a right click menu that shows the "Assign Macro" command, (near the bottom,) it is NOT and ActiveX control, it is a Forms control. -If it comes up with a right click menu that shows the "Properties" and "View Code"...

Interesting, Glenn. Thanks for linking. I'll definately file that away for future reference. :) Ken Puls, CMA www.excelguru.ca

HI there, From the Macro recorder: Range("A1:D18").Sort Key1:=Range("D2"), Order1:=xlAscending, Header:= _ xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal You'll need to adapt the range to suit. If you need it dynamic...

Ah! Fair enough. :) Ken Puls, CMA www.excelguru.ca

We can use a Worksheet_BeforeDoubleClick event, check the value of the target, and probably even feed it into a single modfiied version of your script. As Zack reiterated, though, we need to code to help you convert it. Ken Puls, CMA www.excelguru.ca

Cool, glad you got it sorted! For the record, what I meant with v5 was not to install it. Just keep the disks hanging around, and start the install using the upgrade copy. Usually, although I don't know with Visio, you'd get prompted to supply them because it couldn't find a suitable version...

Hi there, I'm not sure I quite followed that last bit. You have a VBS script to take a bunch of users listed in an Excel sheet and put them in a group. What you want to do is place a single user in a group. Is that correct? If that's the case, please post the VBS script, and I'm sure that...

Hi there, I usually prefer to test this on live data, but I don't want to try and replicate your workbook here. If I understand correctly, you want to overwrite rows 1,2 and 3 every time. The way you're set up, you are measuring the count of the current region every time. Add data, and that...