Hi Folks,
Just new to writing VBA Macros' and having a spot of bother.
I am trying to open a file which has a message box appear as soon as i open it. I can not find a command to ok the message box so it will open the file.
Can anyone help?
Thanks,
Darren
Has anyone ever came across this?
Thanks.
Have a look at this http://www.fontstuff.com/ebooks/free/fsMessageBoxes.pdf
then respond with your issue.
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
I have looked through the attached. But still can not figure this out.
I have created a vba to open a file, but when i open the file (With or Without vba) a message comes up saying "some information missing, do you still wish to open this file". I would like to write a command that will automatically say yes to this.
many thanks,
Darren
Please post your workbook so we can see what is occurring
To attach a workbook, use Go Advanced | Manage Attachments and upload the file
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Posting Permissions
Reply With Quote
