Search results for query: *

Hi Combo Apologies for the long delay on my replying This worked so many thanks for your help

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

strongm Many thanks I have declared this as a Constant and it now works

Hi All Thanks for your help on this I have updated the code as suggested and now get a 'Variable not defined message on the following line With Application.FileDialog(msoFileDialogSaveAs) I'm not sure what to define the variable as, can you please help Thanks Option Explicit Sub...

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

Thanks Combo and skip. I will check this

Hi All I’m watching your conversation, eager to learn and code correctly. If I do not have access to earlier versions then I assume I cannot compile on an earlier version? Thanks

To All I've managed to work this out (I think) and declared constants in my code and it now works Thanks so much for your guidance and patience. I have pasted my code for reference and to ask if there is any other fine tuning / improvements I should make Thanks again as you have all been a...

I cannot seem to highlight the code where it stops - sorry

Hi I thought I would try the following. I have unticked the references to MS Object 15.0 Libraries for Office, Word and Outlook and have then run my code. I only seem to have an issue with one module which is below and highlighted where I hit the issue. I know you have told me what to do but I...

Okay thanks So if that is the case but I don't have access to excel 97 I guess it's not possible for me to compile? Thanks again

Thanks to all Unfortunately I do not have access to know which versions of office will be used Thanks

Many thanks macropod I will not always know what office versions are being used across different users so assume that the approach suggested by Combo is the one to take? Thanks

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

Hi Combo I applied most of your suggested changes and still had an issue. I then spent some time changing the sequence of actions within the code and I am very please to say that I have run the code many times with no issues Thanks so much for your patience and help It really is appreciated...

Thanks Combo I will check and let you know

Hi Combo I've now set Option Explicit on all code and declared variables. I think I have made the other changes you suggested and still having the issue The code stops at the highlighted line Also to mention my earlier comment It seems that there is no issue when I create the appointment and...

Hi Combo Thanks for your advice again which I will update and check I thought I'd mention the following as I'm sure it will be important as I have just noticed this If I minimize the appointment item after I have created it, I can create another appointment item with no issues. I have done...

Hi Combo I am using MS Office 2013 I have copied your code and now getting an error on the highlighted code The appointment is being created and then stops. Please note that this happens every second time I run the code Thanks for your continued help Dim oInspector As Object Dim oWordEditor...

Hi Combo Code is below with the highlighted line that generates the error The code does create the appointment item without pasted data Please note that the error seems to be generated every second time the code is run Thanks Sub option_explicit_CreateMeeting_Click() Dim ol As Object Dim...