Recent content by Sylv4n

Hi, I'm having a problem with .xdp files. We have a blank form hosted on a server data files are passed by e-mail 1. A User goes to that form fills it in and clicks submit 2. The form is then e-mailed to their line manager who opens it up reads what they have written adds some more then...

Thanks Victor V, some good points that you raise, however this is a server that has all our printers on site on it (many different HP models). so I am unable to try and change values without risking screwing up other printers. I'm going to give up on this idea, its only about 3 more clicks to...

by printer server I mean a network computer sharing many printers attached in LAN (PS1) I have tried to change the settings on the server, however I cannot change the default ones (called General Everyday Printing), I can however create a new "printing shortcut" and set all the options on that...

Hi all, We have a print server with several printers on it. I want to setup one of these printers (HP LaserJect 5100) for a specific job. this will require it to only print in A3 with duplex and a few other options set. the problem I'm having is that the printer seems to want to use "General...

Ok, I'm slowly making progress. I think they way I'm going to aproach this is create a button on the form to print with the following code: xfa.host.print(0, "0", (xfa.host.numPages -1).toString(), 0, 1, 0, 0, 0); now this is fine, it asks no questions and just sends it directly to the...

The problem with that is that I am using the PDF as a form, and so all m users who want to print it get is a xdp file, and I guess if I try and print that directly they will get the equivalent of a text file rather than the Adobe form with the xdp data in it.

Hi, what I want is for my end user to be able to click print and the printout will always come to a single specific printer on a A3 page with booklet printing. I have setup the printer so it only has A3 paper in it and it defaults to booklet printing the problems I am having are as follows...

Tsuji, That does solve the above problem, however I over simplified the question to writing my original post, in actual fact some of the departments do not reside in the Dept OU and they are more than one OU deep, so for example one may be in OU=Finance,OU=Dept whereas another could be in...

Hi, I'm trying to get all the members of a group. most of the groups are in the Dept OU but there are some elsewhere. I am using VBA behind a Excel worksheet I have the following syntax that works: Public Function getUsersInGroup(strGroup As String) Dim myResults() As String Dim objGroup...

Hi Guys, I have a question about hyperlinking, I want to open a folder with a hyperlink and thats fine, easy job! However I want a select a folder/file within the folder I am opening, so for example I want to open: s:\data\Defect and then select the folder: s:\data\Defect\PHOTOS\ so basically...

to open a sheet when a spreadsheet opens you need to go to the VBA Code of "ThisWorkbook" (rather than the code for a single sheet) then in there you can have Private Sub Workbook_Open() Sheets("Sheet3").Select End Sub where "Sheet3" is the name of your sheet and as for trying to lock macro's...

I have worked up a solution that works it basically searches the clipboard text for 'vbLf' and counts how many it can find (the number of rows) then it counts how many 'vbTab' it can find before the first 'vbLf' (the number of cols) and Skip I even used the code tags =) Public Function...

okay sorry for the late reply, Skip - for one cell ranges there is no problem becouse when they selct a cell I store the old value, so when its changed I can report what it was and what it is changed to. I have got that working xlbo - I am using the selection change event to store the values in...

Ok here is my problem, I am unable to use the Excel track changes in my application as it restricts other Excel functionality. so I have written my own VBA code to handle this, it works simply by using: Private Sub Worksheet_SelectionChange(ByVal Target As Range) so that when the user selects...

ahh figured it out, I needed to remove the end of line marker of '/r' and use '/r/n' which is a windows way of ending a file Working fine now =)