I have created an excel workbook (A) that uses data from another, password protected, workbook (B). At the moment I need to open B, with the password, and then open A for it to be able to refresh. Can anyone help me with some VBA code so I don't have to open B, either by (i) asking for B's...
Is there any way the above code can be modified to do the conditional formatting using wildcards? eg. If the first few letters of a cell match in the case, something like what the # could do below:
Select Case oCell.Value
Case Is = "ARL###"...
Just wondering if anyone has any code to automate the merging of an access query with a Word template? I know it can be done manually using the Office links functionality, but I'm sure it can be automated. I would like it to use the current database (as the same database may be re-used and...
Paul
That sounds exactly like what I'm after. Would be ideal if the frontend was able to check for the network and, if not present, use the local backend, otherwise connect to the network backend and synch the local backend. I might run into problems in specifying which backend to connect to...
Thanks Paul, that does sound like what I need. The reason I have local backends is for users to work on laptops without network access, then replicate to the master backend when they return to the office and login to the network. Does yours replicate to the server each time a user logs in to...
I've created a frontend/backend system and want to be able to replicate local versions of the backend to the network version. Is there an easy way to enable replication of the backend through the frontend application, or does the backend have to be manually replicated?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.