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

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

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

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

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]

I have written some vba code that calls crystal a report, fills the Edit Select Formula runs and exports the results to Excel, it all works perfectly when run on a machine with Crystal 8 installed, but when I run it on a machie with Crystal 7, I keep getting "Unable to log into...

I have written some vba code that calls crystal a report, fills the Edit Select Formula runs and exports the results to Excel, it all works perfectly when run on a machine with Crystal 8 installed, but when I run it on a machie with Crystal 7, I keep getting "Unable to log into...

I have a VBA apllication that runs and exports crystal reports. When I run that application on a PC without Crystal installed, it obviously won't work. Does anyone know which Basic Components of Crystal I need to put onto the PC in order for the vba to run. Thanks Ozzie

I need to be able to use the Application.Quit command to exit an excel document but I don't want the option to save if any changes have been made, does anyone know how to disable this option through VBA ? Cheers Martin [upsidedown]

I am opening a series of files from a predefined list of files (could be around 200), I am opening the files one at a time, then copying and pasting some information across to the current worksheet, then I close the donor file down, and repaeat the process with the next file. My PC keeps hanging...

I am working in VBA for Excel I need to copy some from one sheet to another, but only on data that has been selected by an AutoFilter, does anyone know how to select only the rows that have been selected by the filters. Cheers Martin

Help, I have several excel workbooks completed by different people, I need to open all the files one by one from a specific directory, so I can combine selected parts of the workbooks. I have no problems getting the data I need, but I need help getting a file list from a directory. Does anyone...

I need to pick up the complete filepath of the open excel workbook. I need this as different users have different drive mappings, but i need to write information to the same place on the server. Any help greatly appreciated. Cheers Martin

Hi I am trying to get excel to open the SaveAs Dialog box through VBA, and so enable the user to select filepath & filename, but I am struggling with the syntax, any help greatly appreciated. Thanx Martin