Connectivity

Resolved · High Priority · Version 2010

Wed 23 May 2018, 16:54 Delegate Cristian said...

Cristian has attended:
Excel VBA Introduction course
Excel VBA Intermediate course
Excel VBA Advanced course

Connectivity

Which is running first, a dynamic query connection to another file or a macro?

Wed 23 May 2018, 20:04 Trainer Jens said...

RE: Connectivity

Hi Christian,

Thank you for the nice feedback and thank you for the forum question.

The dynamic query connection will execute immediately when you open the workbook the macro will wait until you enable the macro.

There is a rule about VBA vs Excel tools. The Excel tools are created in the language VB and are always faster than what we can do with VBA. Not much but for example if you want to find a text string in a worksheet using VBA, do not loop or other things. Call the Find function.

I have added a link below which show the refreshall options.

http://www.excelhowto.com/macros/refresh-all-data-connections-on-workbook-open/

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Conditional formatting for cells that return text , not picked up by Go to command

If you have tried to format all cells containing text even those that display text as a result of a formula you may have had difficulty. As Go to command with constant selected does not pick up formulas that result in text.

Then try this. Select the range the formula cells appear in on your sheet. Format, select Conditional Formatting menu. In the dialog box under Condition 1, select "Formula Is" from drop down. Next to it in the Formula Box, enter the formula =Istext(A1. Click Format button , choose desired formatting settings and click OK. To go ahead and apply the conditional formatting click OK to accept

View all Excel hints and tips