Search results for query: *

Sorry I just realised I haven't really said what my desired outcome is. I want no return/paragraph character at the top of the new page and the outline number to show in the document map. I've found a half fix. The section page break adds an extra paragraph character before the outline...

Hi I've got real problems in word 2003 trying to get the document map to show the outlined number when I place a pagebreak just before the numbered line. If I place a page break at the end of the previous line i get a line return on the new page then the numbered heading, or if I insert the...

I've avoided by problem by opening the template and copying the sheet I want across to the main file. xl doesn't crash when i try to save when doing this. C-H

The thing is with this is you stop all macros running and try to save the file as normal and excel still crashes. Is it a programming problem or a EXCEL problem? Claude-Henri

OK I've tried the second work around and I get another error when I trie to save. The reason I've come to my current problem is because I ran into the error caused by #2 work around (inserting a template) the thread i start for the work around problem is thread707-1007550 "object disconnected...

XL 2003 I have tried taking out the sheet that causes the error into another file and copying the sheet into the same file. I get a few more sheets to copy this way. Still end up with the same error though. C-H.

Excel help on the net says that number of sheets is limited only by available memory. When the error occured I insert this extra bit of code to see my memory usage Temp=Application.MemoryFree Temp=Application.MemoryUsed Temp=Application.MemoryTotal Temp values were 1. 1048576 2. 6548816 3...

There error "message" was slightly different this time Copy method of Worksheet class failed. C-H.

I have inserted a new sheet and copied the format from "Wave" across to the new sheet (Sheet5), I got passed where the problem was occuring before but it happened again, this time when there was a total of 65 sheets. There was nothing unusual about the sheet names this time. C-H.

Yeh I see something similar. Not with the sheet that is crashing the code ("Boom"). But with another sheet ("Wave") has which I have copied (t an earlier stage)in a similar fashion to "Boom" Sheet2112 (Wave 1) Sheet2113 (Fly Wave 5) Sheet2114 (Fly Wave 4) Sheet2115 (Fly Wave 3) Sheet2116 (Fly...

Hi I am copying a worksheet may time over into the same workbook. Once I reach 59 sheets (total) i get an error Run-time error '1004': Copy method of worksheet failed the line of code i am using is Worksheets("Boom").Copy After:=Worksheets(AfterSht) "boom" is the sheet i have already...

Sorry Harleyquinn Another case of not fully explaning myself. What I'm doing is setting up a form that lets you change all the headers and footers on all the sheets. Image1 is the image which is already in the header. I would like the user to see the current image in the header (even if the...

Thanks Harleyquinn O.K. this works if I have just inserted this picture into the header, during the session with the file. If i then save and close the file with the header, re-open and try to run this code I get Run-time error '53': File not found any further suggestions? My code is as...

Hi All I don't know if its possible, but what I would like to do is take the inserted header picture and show it in a Image control on a form. don't really know where to start. Claude-Henri

Thanks for the info, I haven't found a solution to the problem, so I'm working things another way, to avoid it. I will let you know if I get a solution. C-H. P.S. I'll give you a star just for answering, it has been fairly dry on help

If I add sheets just using this line of code SaveFile.Sheets.Add AfTer:=Worksheets("Geometry & Loads") i.e. just a blank sheet, the error doesn't occur. I have also tried the line of code below, and I get the same error. SaveFile.Sheets.Add AfTer:=Worksheets("Geometry & Loads")...

...lines of code after "SaveFile.Sheets.Add............" Temp = Application.GetSaveAsFilename(CraneProject, FileFilter:="Microsoft Excel Workbook (*.xls), *.xls", Title:="Save Data File") SaveFile.SaveAs Filename:=Temp, AddToMru:=True I get this error Run-Time Error '-2147417848...

Hi My real problem is why is my workbook "disconnecting"! I have been thinking. In Workbook_BeforeSave() event I use ThisWorkbook as the code that is running at the time is in the workbook I want to modify. Would this get confused with the Workbook actually used the .Save command Claude-Henri

Maybe i should tell you that I have an event macro SaveFile. The event is Workbook_BeforeSave(....) all I am doing on this event is formating headers and footers. C-H.

Sorry. SaveFile is declared Public as Object and this is how i have assigned SaveFile in another sub Workbooks.Open (ThisWorkbook.Path & "\SaveFile.xlt") Set SaveFile = ActiveWorkbook C-H.