Search results for query: *

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

Skip, No Luck, still not picking up the source data from the workbook. It opens it alright, as I can watch it go into the VBA behind the source workbook. But it just will not get the data from the source cells in the worksheet. Frankly, I am having to put this on the back burner now. I just...

Hmm, Thanks to all. But on the face of it, it seems this has never been done before and nobody has any better idea than I do, on how to go about it. So I am putting this in the too time consuming to be bothered with box. 'If at first you don't succeed, then your hammer is below specifications'

Sorry to have taken so long to get back on this. Its been a bit busy. So once again stepping through. It opens the folder dialog. Accepts the selected workbook Opens the selected workbook passes though all instances of SH1 copy/paste but without populating it at all. (I put a watch on all...

Mintjulep, The template is not the problem here. That is retained as a default. The problem lies in the fact the users do not do as instructed, in that they; a) Do not consistently use the assigned naming strategy. b) Do not save the reports to the assigned location. Therefore trying to find...

PHV I tried your suggestion, It is still not bringing the data in, it was applied as below. Sub importFPRptData() Dim X As Long, Z As Variant, Y As Variant Dim Bk As Workbook, Sh As Worksheet, Sh1 As Worksheet Dim rng As Range Dim rng1 As Range Set Sh = Workbooks("FP...

Skip, Thanks for that. I shall look at the code in the template for future use. At the moment I have 50,000+ records to go through, so its not something I can do retrospectively. I am trying to consolidate key information from the workbooks to make look up and analysis easier. PHV. I shall...

OK, Good news and bad news. The good news. The script works when getting data from a normal spreadsheet, no problem. The Bad news. It does not take the data from the source workbook sheets that I am trying to get the data from. The sheets are not protected at all. But they do have some code...

Thanks all, I cannot believe I could not see that. Talk about being as thick as a short plank. It works fine now with the 'Ah Hem!' correction. 'If at first you don't succeed, then your hammer is below specifications'

Hi Skip, I have stepped through it and watched the values for rng and rng1. It seems that it is hitting the 'If Not Sh1 Is Nothing Then' statement, after opening the source document, then going straight to the 'End If' statement, bypassing the 'copy/paste' statements entirely. I tried...

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

Thanks for that, It looks as if that would be the general answer, but how does it work after that? Is it the same structure as in Excel? How would I get the information from fields in the document to populate variables? In excel it would be by referencing the cell contents, how does that work...

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

Nodrog77, Good news, it does work under windows 8, but you have to copy it from the clipboard, it will not open an xlsm document. Skip, Thanks for that, good advice. I started out programming COBOL many years ago, but haven't done anything serious for years. Thanks all. 'If at first you...

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

Thanks for the responses, Jason, The endif is at the end if each section for copying the data to the destination cell/workbook. I would not have thought that another would have been required as it appeared to me it would be orphaned. But I will give it a shot. PHV, Unfortunately each...

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

Hey, Worked like a dream, SkipVought always says I over think these things. Many thanks 'If at first you don't succeed, then your hammer is below specifications'

Sorry, Not to have got back to this before now, but the issue got taken overtaken by other events. Solved the issue in another manner. But here's a thing. I have this bit of code (Robbed from another author, don't know who) and I am trying to figure out how to include hyperlinking. so that the...

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