Search results for query: *

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...

To the question asked, don't believe so, no. You *may* be able to put in your v5 disks when prompted upon installing the new version. The other route that *might* work is copying the old files to the same folders on the new PC. I don't know if the upgrade checks for reg keys or certain files...

Hi there, Honestly, the difference between Office 2002 and 2003 is hardly what I'd consider a "MAJOR" software upgrade. The platforms are nearly identical, with the exception of Outlook. Typically, when I make the switch between versions of Office, I uninstall the first one completely, then...

If you want an alternate way, you can retrieve the data using SQL via an ADO connection. An example here: http://www.excelguru.ca/node/23 The size of the recordset totally depends on your SQL query. I've modified the method there to create functions to return a value, return entire arrays of...

Hi Zwicky, I'll have a play a bit later. Technically speaking, the continuation is actually space, underscore, hard return. The code you had above doesn't have the hard return, which is why I asked. ;) I have some code lying around somewhere to sync pivot fields, I believe, I just need to...

Hi there, These may be minor, or may not. I haven't tried to set up a PT, and don't use them much, so bear with me... Your line of code, is it really typed in the VBE exactly like this? Sheets("Pivot").PivotTables("Pivot").PivotFields("C Key"). _CurrentPage = ckey If so, you may want to...