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