Recent content by DylaBrion

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