Search results for query: *

Hello Can you please help. I have developed a macro enabled excel workbook with VBA code providing functionality. The code works fine on my laptop / desktop but does not seem to run from the same button for a user on another PC. When the user clicks the button they receive a warning message...

Hello Can you please help with the following, I have the following code to save an excel workbook with a defined name to a defined file path. The code works fine. However the file is saved with no visible evidence of it saving unless the user goes back to the destination folder to check. I...

Hi In an earlier thread it was suggested that I ensure that Reference Object Libraries for Outlook and Word are selected within Excel VBA This helped resolve some issues with the code I have a general question as follows Given that my excel workbook will go to multiple users with different...

To All Can anyone help. I have some code (pasted below) which opens outlook from excel and creates a calendar invite. It works fine for about 70% of the time. For the remaining 30% I receive an error message stating the Microsoft Outlook has stopped working. When I click debug the line is...

Hi Can anyone help with the following code which is triggered by a command button to save the excel file and create an email in outlook The saving of the excel works fine When the code then tries to create the email I get the following message Object Reference not set to an instance of the...

Hi Can anyone help. I have an issue with my excel sheet that loses the drop down data validation boxes when saving. I'm not sure what is causing it but wondered if it could be VB code or I could write some VB to stop it happening? Many Thanks

Hi Can anyone please help with the following I have the following code below to insert an object into selected Cells in excel When the object icon is inserted it's size is bigger than the cell. I would like to adjust the icon to a specific size or automatically fit the cell Is this possible...

Hi Can anyone help with the following. I have a User Form which I would like to centre (on opening) on one of my two monitors. I have found the following code (which runs on user form initialising) Private Sub UserForm_Initialize() With GenAvailInputForm Me.StartUpPosition = 0 Me.Left =...