Search results

Hi The_Doc_Man Thanks for your reply - I have opened the new excel file and it opens fine, not in read only mode and saves fine without any problems, so that doesn't seem to be the problem

Thanks Minty! That has resolved the Error No.9 issue, but it is now asking me to save the updated file, as if when the excel file is opening it is in read only format perhaps? Is there a way around this? As well, normally when the module was run, a window would pop up saying "Downloading"...

Hi all, Last year I developed an access module that allowed me to open, refresh connections, save and close an excel file. I need to do the same again, with almost identical projects / workbooks, so thought it would be a simple case of copying and pasting the old access file, renaming it and...

Hi Everyone, I am a "copy and paste" with a bit of tinkering VBA user and have pinched a very useful piece of code to help with a program I have designed but I am hitting a snag that I really hope someone can help with. The below code allows me to open and excel document, refresh the...