Recent content by PearlGI

Interesting….. Based on your suggestions, the issued is now fixed. Although I now understand how to fix the issue (if it arises again), I don’t understand why.:confused: The problem can be fixed by opening the Publisher on each pc which has the problem and then re-saving and closing the file...

Hi, Thanks for your reply. Both the Subscriber and Master are located on a network drive. If we refresh the Subscriber simultaneously on two pc’s (one working correctly and one not), they both return the results at the same time (visually, not measured) and the good/bad behaviour is always...

I have a spreadsheet with an External Data link to another spreadsheet, but the refresh behaves differently on some computers in the office. 1. On some, when you refresh the data, it runs a background refresh and returns the data – great :) 2. On others, when refreshing, it automatically opens...

Is there a way to detect if a user has chosen to refresh a pivottable? Ideally looking for something like a Before_Refresh Event. Trying to get some VBA to modify the connection string before the pivottable refreshes the data. [I don't need to know how to refresh a pivottable using a VBA.]...

I have a Word document that has links to multiple named ranges in a single Excel file. This all works fine and refreshes okay. However, if I wish to link the Word doc to a new Excel file (for instance, a new months worth of data) I have to manually tell Word to relink each link separately even...

Did you ever get a solution to this? I have the same problem and can't locate a solution.

Hi, thanks for the reply. Not quite the solution I was hoping for, but maybe I can change my approach. Maybe if I explain further what I was trying to do. In simple terms, all cells in the workbook have been resized to small squares and the VBA is controlling a 'ball' (aka a small cell) that...

Does anyone know if it's possible to determine whether a cell is currently displayed on the visiblle part of users screen?

I've adapted the following article to fix my problem and posted the code in case anyone else is interested. http://www.xtremevbtalk.com/archive/index.php/t-150302.html Private Declare Function FindWindow Lib "user32" Alias _ "FindWindowA" (ByVal lpClassName As String, _ ByVal lpWindowName As...

Thanks, but that article is about detecting if Excel and/or a workbook is already running. (Already have all those bases covered) I'm looking for something that detects is Excel is off doing something else which prevents another app from taking control. Mostly likely caused by an Excel dialog...

I have a database that manipulates data in an Excel workbook. Everything works okay, unless Excel is 'busy', for instance if a user has left up an open file dialog window and then everything hangs. Is it possible to identify if objExcel is 'busy' so that the user can be asked to rectify the...

Alisa / Banana Querying fld.Required in the immediate window did not cause any delay, so I've used Banana's suggestion of renaming Required to IsRequired and speeds have dramactically improved. So in summary the issue was not just the use of a reserved word as a fieldname, but one of using...

You need a assign the MsgBox response to a variable and test that. At the moment your line [If vbOKCancel = vbCancel] is just using two different verbs which will always result in a False. Try the following changes. bytAns=MsgBox("If you are NOT the Information Manager, then please click on...

try Forms("FormB").textbox1 but formB must be open, so trap for this event.

Banana, I'll give that a go. I had already thought of that and had tested by setting rsTemp!Required = True which ran with no speed issue, however it could be an ambiguity of using both !Required and .Required within the same line. Alisa, Will try the immediate window and advise back. But rest...