Search results for query: *

Have you looked into DoEvents.

Is this error with any Excel file or just this one? Have you looked at the references, it should indicate which one it can't find. You indicate you are using 64 bit operating system. Does that mean you are using Windows 7 AND Excel 2000?

I only have office 2007 but what about oExcel.Activeworkbook.visible=false?

What happens if you save to a different location the unzipped file first?

I have used this method in the past. This is 'a' way. Duane's suggestion is better. I have not given you everything so some of this won't make sense. Dim strName As String Dim db As DAO.Database Dim rst As DAO.Recordset Dim RST1 As DAO.Recordset Dim RSRepAud As DAO.Recordset Dim RSOnRoad As...

Clive, you could use a query that returns the detail for the record id from the first query. The contents of a table are a recordset, the results of a query are a recordset. You have already created a recordset to pull the email address and the account name. Now create a second recordeset...

This works for my needs. I would give proper credit to the person who wrote this if I knew who did. Wasn't me. Put this in a module and call it (fRefreshLinks). Option Compare Database Option Explicit '***************** Code Start *************** Function fRefreshLinks() As Boolean Dim...

Every time I have to deal with data from an outside source in Excel I first run the following. 'Remove pesky spaces Dim rCell As Range Dim rText As Range Set rText = Cells.SpecialCells( _ xlCellTypeConstants, _ xlTextValues) For Each rCell In rText rCell.Value = Trim(rCell) If...

Shouldn't matter the location of the Application. The Access Application that has opened the db is the one that is compacting it. Is the backend data only? If so you might not save much by compacting it.

You might try xlApp.Application.Run "formatDepAllow12Months"

What about the shortcut key Ctrl'

I have noticed when Access links to SQL tables manual searching takes much longer than with a query. I have no experience with SQL 2008. I would then suggest that you use a query. You could set the shortcut CtlF to open your own small form that "looks" very similar but uses a query to find...

James have you looked at http://allenbrowne.com/Access2007.html Plus are you running the most current version of 2007, are you current on all the updates?

Then it sounds like the USER has a permissions limitation to the folder(s) that contain your database.

Under Format>Cell>Number what is the setting for offending cells? Just a guess it might be Text.

When the code fails move the cursor over Workbookname it should give the file name you are trying to open. Does it? Have you compared the References between the machines?

If your file is hidden Gavin is correct. There are shortcut keys to hide the current window (the active file) Ctrl-W-H while shortcut Ctrl-W-U unhides. Maybe two or three times a year I get a frantic call "my file is gone". Somehow they hide it. Hopefully this will take care of you.

You state that when you try and open the file it does nothing. Does that mean Excel does nothing- it just sits there or it does nothing and opened a blank Excel screen that is gray. Try opening Excel first then create a new blank workbook. If you can, then with the blank workbook open either...

How about helping us out, can you show what you have to this point? FYI- there are several Access forums, this one is used mostly for all except Access, but sense you asked here we will try and answer here.

To look at the data in Excel that is contained in an Access db try using MSQuery.