Search results for query: *

and if so, whats the code and type of file that the object has to be?

I've tried doing this via a With ActiveSheet.PageSetup and then selecting all sheets to run the macro on - and also With ActiveWorkBook.PageSetup but still to no avail. Predominantly I want to PrintTitleRows across all sheets within a workbook - is this possible? Whats the code for this? Z123

My fault to be honest, I should have scrutinised the code more myself to realise that - but to be honest didn't have time... Thanks for your help

Thanks Skip but it needs a bit of debugging... nn - First it asked me to Do without Loop so I added in a loop at the end of the code but the macro had no control over the amount of sheets added and didn't copy the text. test - tells me Subject out of Range, or Object Required if I change the...

Thanks Golom, But its then asking me for a parameter - I've not come accross these before - how should I tackle it?

Probably two of the easiest questions ever, but how do I combine these two queries? UPDATE CWT_Room SET CWT_Room.cwfADB_RoomCode = CWT_Room.cwfRoomTypeTemplate; UPDATE CWT_Room SET CWT_Room.cwfExtRevCde = CWT_Room.cwfRoomTypeTemplate; I was thinking UPDATE CWT_Room SET...

The report is for several rooms within a department, the macro is to count how many rooms, add that amount of sheets, and each time it adds a sheet it should copy the room info into that sheet.

You may need to update service pack info. Downloadable from the Microsoft website...

The formatting of the report is not the issue, I need the macro to recognise the next room instance, add a sheet, copy that rooms data into that sheet and then continue doing so through the rest of the report. Hope this clarifies...

Trust me I would love to, but unfortunately this is on a massive scale and the report is for several external users whom aren't particularly IT savvy.

I agree, but the report is for several different rooms within a department that need to be on different sheets within the same xls file. 'Split' I suppose isn't the correct term - separate seems more suitable.

Hi, I have a report that I need to split down into several sheets within the same workbook. I've already developed the majority of the code, but am struggling to add the correct number of sheets and then copy info into the 'next sheet'?? Dim strDept As String Dim strGrp As String Dim...

Hi, I need to collate several similar reports (individual files) into one file. This can be done through MS Binder, or by pdf'ing and inserting files... however by adding a continuous page number to the bottom of the file, this knocks out the existing header created in the MS Word, or in...

Thanks anyway.

Unless I am mistaken it is impossible to select an image file (like a company logo) to be added to your header or footer through File/Page setup... (Microsoft Office 2000 Pro) But I'm sure it must be able to be done through VB, I've been playing around with some code for a hour or so now and I'm...

Thanks for your help so far Golom, but rather than NOT show any duplicated records in the two tables and only display records that are unique to one or the other of the tables - it is just showing that which matches. If you imagine you have two tables which have 10 identical records...

SELECT a.room_num, a.room_name, a.hce_code, a.item, a.quantity, b.room_num, b.room_name, b.hce_code, b.item, b.quantity FROM CWT_CdeB_HCE_DataTransfer AS a INNER JOIN CWT_CdeB_HCE_DataTransfer2 AS b ON a.room_num=b.room_num is the easy part of the query. What I need to display are fields that...

I want to write a SQL query that compares two tables and only shows the differences between them. The tables are large and predominantly the same so as a result of running this query I'd like to be left with a new table that only shows what is in table a and not in table b, and what is in table...