Search results for query: *

Hi I am printing a document in excel, but don't want the Printing Message box to appear, I have tried using Application.DisplayAlerts = false, but it still appears. Does anyone know how to disable this message? Cheers Ozzie

Cheers Ben, Worked perfectly. Have a star on me. Ozzie

Cheers Hugh. Works great now. Any idea how to send from a group email account rather than my personal one in Lotus Notes. Thanks Ozzie

Ben I am having the same problem, I tried setting the database as the group database, but it still seems to default to my personal database. If you find out how to do this, please let me know its done. Cheers Ozzie

Zygor, I have attempted to use your code in the first note and when I try to use the procedure in a routine, with the following code SendNotesMail("Test","C:\Test\Test.doc" ,"martin.lymn@ars.aon.co.uk","This is test of the automatic email procedure",false) When I type this code in I am...

Brilliant. Thanks Frink after a bit of tweaking to suit my application that works perfectly. Star on its way to you Many Thanks Ozzie

Help I need to populate a table from an action on a form, I am running VBA on exit of a field on a form, and need to update another table (not the one the form is linked to). I have the table set up, and all the values I need are stored as variables, I just need to know how to assing those to a...

I am new to Access VBA and am struggling with some code. I don;t know if this is possible or not, any help would be appreciated. I am triggering the code on exit of a field in a form, and I need to pick up the value of a field in another table, which is linked in via referneces, to the table...

Not totally sure if this is VBA, but here goes anyway. I have some VBA that assigns values to a pre formatted Pie Chart in Excel, however the numbe of pieces of pie will vary from time to time. I have sorted out how to set the number of pieces of pie, but the positioning of the data labels...

Hi I have some VBA code that references Crystal Reports 8 Library, some users are running older versions of Crystal Reports, and some are running newer versions of Crystal Reports, so I need to detect if a Reference for Crystal Reports 8 Library is MISSING or not so I can disable the routine if...

Sounds like a good Idea, I will give it a go. Cheers Ozzie

Thanks guys. I Appreciate the points raised. I think I might just state that the Document is best viewed with certain screen settings, then it is up to the user. Ozzie

Hi I have an Excel spreadsheet that is best viewed with Display Properties of 1024 x 768 pixels, is there anyway I can pick up what the users display settings are, then change them to 1024 x 768 when the spreadsheet is opened, then when the spreadsheet is closed set them back to the users...

I am having the same issue, but am exporting to Excel 2000, worked fine in excel 9. If you have any answers, please let me know. Cheers Ozzie

Not sure if anyone can help, but I am getting the following error message when running some VBA code in Excel 2000 Run-time error '-2147417848(80010108) Method 'Add' of object 'HPageBreaks' failed Then when I choose End or Debug I get the following Error Message The instruction at...

I need to set the status of a workbook to Read Only when it is opened, this is to stop users from overwriting existing Excel Document. Does anyone know how to do this? Cheers Ozzie

HELP!! I need to detect if autosave is enabled in Excel and if so disable it, does anyone knw how to code this. Any help greatfully received. Regards Ozzie

I'm not sure if this is possible, but here goes anyway. I have an Excel Spreadsheet that has data grouped, I need to be able to detect the group status, ie expanded or supressed, does anyone out there know how to pick up this in VBA. Cheers Ozzie

Thanks Mike, The restriction was a long shot anyway. But the prompting filename bit works perfectly. Cheers Ozzie

Help I am using the following code Application.Dialogs(xlDialogSaveAs).Show To give the user an option of where to save an excel workbook, however I need to be able to change the default filename, and if possible stop the user from changing it. Any help greatly appreciated [noevil]