Good Afternoon, I am trying to find a way to forward all of the print jobs on a specific printer to a folder as PRN files automatically without using the print to file dialog box, does anyone know how to do this programatically?
The function I am using is =MID(A1:A5000&" "&A1:A5000, FIND(" ",A1:A5000)+1,LEN(A1:A5000)) and I tried using it in a macro this way:
Sub InsertFormula()
Worksheets("Sheet1").Range("A1:A5000").Formula = "=MID(A1:A5000, FIND(Space(1),A1:A5000)+1,LEN(A1:A5000))"
End Sub
But it got a...
Hello, I have a column in excel that contains the first name middle, middle initial, and last name. I need the order of this to be changed with a macro. The current format of the cell is: Smith John M and I would like the format to be John M Smith does anyone know of a way to do this. I have a...
Hi I am working on an ASP online form / Access project. I have an asp form that users fill out and it sends that data to an access database. I then have administrators add some data for each user that fills out a form. My question is how can I set this up so that users can fill out the form and...
Hello, I have two vb files one is class and the other is a module that uses that class. How can I pass a string of a text from a text box into my module?
Hi I was wondering if there was a way to open the address/contact list from outlook 2003 from a vb.net program. The address/contact list that I am talking about is same list that comes up when you click "To" if you have an open email message. Any help would be appreciated thanks.
Hello I have a mandrake 9.2 web server... old I know and I just installed xml module on php. My php version is 4.3 and my apache 1.3.9 and the xml.so and the xml.ini showed up fine but I was wondering what if any lines I had to add to my php.ini file and also if I had to restart apache for this...
Hi I was wondering if there was a quick way I could add "JR" at the end of cells I have selected in Excel. Currently the cells contain names without JR for example: John Smith but I want it to add JR at the end so it would be : John Smith JR?
Hello , I have an array that I run from two buttons and for each buttons event it has the exact same code except one button reads from 1 text file and the other button reads from a different text file. How can I use this code one time instead of having to use it for both buttons but be able to...
Thanks for the help, I figured that like Andys code has it everytime you add .readline it reads that specific so if I just call that before I need to read a line it will get me to the correct place.
Hi, I have the following code that reads a text file into an array and then displays it into a textbox. The contents of my text file are :
General
Hey,There
My question is how can I get streamreader to ignore the first line of the file (General) and just read the second line of the file...
Hi I was wondering how I could check a text file to see if the word "success" was contained in it. I know I can use filestringreader and system.io to read the file but I dont know how I would use it to check to see if the word success was in the file. Any suggestions ?
Thank you mansii, woogoo, AlexCuse I got this to work and I am going to use a treecontrol like you suggested to help prevent errors, so thanks for the help.
My form has a textbox and a button and what I want it to do is when you enter a directory in the textbox I want all of the extensions from the files in that directory to go from .txt to .doc.
Its not really changing the extensions that is giving me a problem, it is passing the directory from the textbox to the path in the code that is whats giving me problems.
Hello I am currently building a project that involves renaming file extensions, and what I am trying to do is to have the user input a directory into a textbox for example C:\new, and then from that information I want the files in that directory to be changed from .txt to .doc, I was wondering...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.