runtime error 1004 activeprinter Saucier Mississippi

Address 15312 Dedeaux Rd, Gulfport, MS 39503
Phone (228) 832-9450
Website Link

runtime error 1004 activeprinter Saucier, Mississippi

Register Help Remember Me? their ADOBE PDF printer had a different name. (I don't know why our shop uses printers with "extended names" such as Adobe PDF on Ne09 instead of just Adobe PDF). Sec ... All contents Copyright 1998-2016 by MrExcel Consulting.

It did it a few days ago and now it does not work. Advanced Excel Integration XL-Dennis corner in the Excel-world OTHER STUFF DAVE HAWLEY FOUNDATION Newsletters Competitions HAV-A-CHAT Book Suggestions & Reviews Test Area Excel Development & Consultancy EXCEL SEARCH & RESOURCES Excel The time now is 12:44 AM. If you don't like Google AdSense in the posts, register or log in above.

I'm using OS X 10.6. Here's Why Members Love Tek-Tips Forums: Talk To Other Members Notification Of Responses To Questions Favorite Forums One Click Access Keyword Search Of All Posts, And More... Steve FaircloughI.T. However, trying to do this on a Mac returned a Microsoft Visual Basic dialog box with the following error: Run-time Error '1004'; This command not available for Excel for Macintosh.

Any tipes would be greatly appreciated. Code: Application.ActivePrinter = "Acrobat Distiller on Ne01:" ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _ "Acrobat Distiller on Ne01:", PrintToFile:=True, Collate:=True, _ PrToFileName:=PrFile Sincerely, Wayne Ask Your Own Question Privacy Policy | Disclaimer Copyright © Help me please... I don't understand why it would run fine for me but not someone else.

any suggestions would be helpful. I can't believe I did that! Try that. here is the save code.

Join UsClose ERROR The requested URL could not be retrieved The following error was encountered while trying to retrieve the URL: Connection to failed. GET STARTED Join & Write a Comment Already a member? I have tried setting the active printer using: VB: Application.ActivePrinter = "\\WP0101\" If you like these VB formatting tags please consider sponsoring me in support of injured Royal Marines with little Code: Dim myPath As String Dim myFileName As String myPath = "C:\TEST STUDY\DCF\" myFileName = "test.pdf" ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:="Acrobat Distiller on Ne04:", Collate:=True, PrToFileName:=myPath & myFileName Any idea what's going on

This works just fine. However, you can go to file, print, and select this printer and it prints out without any problem to the printer specified in the code. tx again, s 0 Featured Post Gigs: Get Your Project Delivered by an Expert Promoted by Experts Exchange Select from freelancers specializing in everything from database administration to programming, who have Your code is simply brilliant.

At startup Excel will set Application.ActivePrinter to your default printer, in my case usually a Laserjet. Is there anything when these two Macros are started to make it ask me what printer I want to print the specified number of copies to? I want to be able to print using the ip address of the color printer. If you're having a computer problem, ask on our forum for advice.

The sheet will always be 2 pages, and I think the code will always ensure Adobe PDF is selected as the printer. Otherwise your code should set the active printer to the one specified. To start viewing messages, select the forum that you want to visit from the selection below. Don't know if there is VBA to get the default printer on a certain machine though.

Sign up now! LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode I seem to only get the error message when I have 2 copies of the same workbook open at once. Fatbelly (TechnicalUser) 16 Jul 04 14:26 Here is some code i found for the same problemFunction NetworkPrinter(ByVal myprinter As String)On Error Resume NextDim NetWork As VariantDim X As Integer'/// Define NetWork

The printer is networked from my other computer that runs XP Professional. Your cache administrator is webmaster. Does anyone know of a simple cause for something like this to happen? This is especially helpful for the Vlookup function.

Excel is "refusing" to display and print anything on landscape format, it only prints and displays portrait. We're a friendly computing community, bustling with knowledgeable members to help solve your tech questions. You can check what all the installed printers are by using this code: Code: Sub Printers() Set WshNetwork = CreateObject("WScript.Network") Set objPrinters = WshNetwork.EnumPrinterConnections PrinterStr = "Printers:" & Chr(13) For i No go.

Powered by vBulletin® Version 4.1.8 Copyright © 2012 vBulletin Solutions, Inc. This means that if a cell contains formulas, text, nu Combine Multiple Workbooks into One - This macro for Microsoft Excel allows you to combine multiple workbooks and worksheets into one On Error GoTo 0 (does it mean to ignore errors and continue to next sentence?) tx, s 0 LVL 9 Overall: Level 9 MS Excel 7 MS Access 3 Does anyone have any suggestion ?

I am taking over a project and once and a while I get the following error message: runtime error 1004 method save of object _workbook failed I was wondering if this Please help again! B3 is a formula that will display alpha-numeric characters (such as C0123456). Ozgrid has been a great source of information and solutions in the past.

This is my code: Code: Sub SavePDF() ' ' SavePDF Macro ' Macro recorded 1/6/2010 ' ' ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, ActivePrinter:="Adobe PDF" Dim filename As String filename = Range("b3").Value End Sub Click File: Print to create." MsgBox Msg, vbCritical, "Make PDF" End Sub If you like these VB formatting tags please consider sponsoring me in support of injured Royal Marines Ask Your eg NE01: to NE16: Just loop through the possible network numbers with an On Error resume next and error check ...... Can anyone tell me how to do this on a Mac?

The fax doc > gets printed out on the fax machine. > > Any help will be appreciated. > > Prabhu kiat, Aug 18, 2003 #1 Advertisements Show Ignored Content Any help would be appreciated. thanks in advance! You could, if you wished, test this by amending the location in your original code and then seeing if it runs on her computer without fault.

Already a member? The time now is 13:44. Is the Ne05 part of the network infrastructure or what does that refer to? During this migration there may be some intermittent down time preventing access to the forum or certain features.