Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Walter349
  • Content: Threads
  • Order by date
  1. Walter349

    Error in previously functioning script for saving workbooks to users desktop

    Hi, Due to a change in security policy, we have had to change our hardware, operating system (now its WIN7) and MS office suite (rolled back to office 2007). and of course its at about 48hours notice. So the excel script that as previously used under Office 2010 and XP and was working fine, now...
  2. Walter349

    Excel 2010 - Collect and import data Problem

    I have a bit of a problem. The following code does everything, except actually bring the data from the source to the destination. -What its supposed to do: It is intended to open a directory listing and allow selection of specific workbook/s to be processed. Then to collect data from specific...
  3. Walter349

    WORD VBA- how to Automaticaly save a duplicate and name a document

    I am trying to find a way in WORD 2012, to automatically save a duplicate of a document to a specified location, when the user selects the menu 'save' or 'save as' function. Ideally this should be transparent to the user. But is not strictly necessary. The document is a template, that users...
  4. Walter349

    HP Formatter Asy question

    Does anyone know if a Q5965-60001 Formatter assy fits and works in an HP CLJ 1600. The 1600 does have an opening for an Ethernet port, but the installed formatter assy does not have the port on it. The Q5965 I believe is for the CLJ 2600, but appears the same, but with the Ethernet port...
  5. Walter349

    'Next without for' Compile error Excel 2010

    I cannot for the life of me, see why I am getting a 'Next without for' compile error for this. Can anyone throw some light on what I am not seeing here? There is clearly something I have stuffed up. For X = 1 To UBound(Z) Set Bk = Workbooks.Open(Z(X)) On Error Resume Next Set...
  6. Walter349

    Listing Files % Folders to a spreadsheet in EXCEL 2010

    Seems the code has changed in EXCEL 2010. The fully functional code I have always used before in 2003 version, no longer works in 2010. Does anyone have any idea how this works now with Excel 2010? Tried the 'Holy Book of Google' no luck strangely enough. Lots of references to the old method...
  7. Walter349

    MS Multipoint Server installation - Video driver issues

    Does anyone have any experiance, positive or otherwise, with installing MS Multipoint on a DELL Poweredge 1900? The problem I am having, is that the OS does not recognise the on board video card, but does boot to the console. I downloaded a suitable driver, but I cannot install it as it comes...
  8. Walter349

    Applications that will work with RDP on a multipoint serve

    I am going to be setting up a multipoint server in a domain and need to know what applications will work with RDP. The MS Office is sorted as its a corporate licence edition, but I am interested in using VISIO, ADOBE Acrobat and others. is there a reference anywhere that provides this...
  9. Walter349

    Looking for a Source for replacement items

    Lacking any specific forum, I launch this question here. What I am looking for is a vendor source for the little plastic form adaptors, that come with some models of LAN testers and enable you to test RJ11 cables in an RJ45 tester port. They are just little plastic moulds that reduce the port...
  10. Walter349

    HP CLJ CM3035 Printer fault - Not printing Black

    Hi, I have had this thing dumped on me.The printer has had a major toner spill(Black), it was in drifts on the base of the printer. I have cleaned it out (mostly), to do it any better will require a complete tear down to component level. I have cleaned out the toner area. The lower fan area...
  11. Walter349

    Kyocera KM-3035 Parts list or IPB

    I am looking to source a print controller board (print system) for this unit. I have a service manual for it, but although it refers to the print system and a print controller PCB in the manual, it does not list the part numbers at all. Can anyone supply me with the parts list or IPB for this...
  12. Walter349

    Getting existing IP address 3Com 4210 Switch

    Can anyone tell me how to get the existing IP address for a 3Com 4210 switch. I can console onto the thing, but cannot find the command line string to show the configured IP address. I know whats its supposed to be, according to the label, but the records show that address against a different...
  13. Walter349

    Canon Imageclass D1120 'Output tray full' Error

    I am getting a 'Output tray full' error on this printer model, when in fact the output tray is not full. Having dismanteled the printer to fully access the exit tray paper bail. I find its a split bail with the right most part of the bail activating the sensor. it appears that this gets stuck...
  14. Walter349

    Cutting & Pasting JPGs to a userform in EXCEL 2010

    I have a requirement to create a user form for gathering data. However it also needs to be able to receive a jpg from another source. Directly linking to the source data is not permitted, so cut and paste is the way it is normally done on the existing spreadsheet in use. Due to user...
  15. Walter349

    VBA for printer properties settings from excel

    Is there a way of being able to set the paper type to Plain, within VBA for Excel. I can set size, margings, oriantation etc.But I need to find away to force the use of plain type paper. 'If at first you don't succeed, then your hammer is below specifications'
  16. Walter349

    HP CLJ3530 MFP Not printing Black

    Got a problem with this printer. It does not print black or cyan at all and the internal diagnostics page comes out blank, the indivdual PQ pages come out on the yellow and Magenta paths only. The toner cartridges are brand new. The OTB is in generally good shape. Any ideas? 'If at first you...
  17. Walter349

    HP2840n Printing only right, vertical side of page

    I have a 2840 that is only printing the right hand side of the page, fading in from blank (LH) to full colour and detail(RH) on the right. So far I have replaced the imaging drum and cleaned the laser head unit, reset to default settings and reset the NVRAM but to no avail. There are no...
  18. Walter349

    getopenfilename runtime error 13 type mismatch

    Had a search but could not find anything that addressed this issue. When running the following code I get the above error, As only one file will be selected at any time, going for the array approach seems excessive. The files to be opened are all xls extension, running under Excel MSO 2010...
  19. Walter349

    Pasting Photos to fit inside a specific cell/row area on a worksheet

    I've had a look around and not found anything that seems to address this issue. We have a number of staff using a spreadsheet, designed as a data form( NOT a User form). One of the things they have to do when completing it, is to copy a photo from another propriety database and paste it onto...
  20. Walter349

    Non-Contiguous Copy paste problem

    trying run this on a test workbook, but I am getting an Object error. This is a test that will be applied to the proper workbook once it is finalised, there are more columns in the proper workbook than are currently in the test workbook to simplify things. The test workbook has two worksheets...

Part and Inventory Search

Back
Top