PDA

View Full Version : Problems opening files



Clarky2
05-24-2010, 05:46 AM
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

Clarky2
05-24-2010, 08:36 AM
Has anyone ever came across this?

Thanks.

Aussiebear
05-24-2010, 03:54 PM
Have a look at this http://www.fontstuff.com/ebooks/free/fsMessageBoxes.pdf
then respond with your issue.

Clarky2
05-25-2010, 12:52 AM
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

Aussiebear
05-25-2010, 02:03 AM
Please post your workbook so we can see what is occurring

To attach a workbook, use Go Advanced | Manage Attachments and upload the file