Jul 22, 2015 · I'm using vba to open a file (owssvr.iqy) with excel. This file is an export from SharePoint 2007. When excel starts up, I get this dialog box:

Jul 17, 2010 · - I have written a simple Macro in Excel 2003 which is able to open Matlab and communicate with it by means of a socket. Here is the relevant part of the code:

Dec 10, 2008 · I need something very urgent. I am creating a search function for a custom addin. My search function ritght now searches only text placeholders. Is there any way of searching …

Sep 2, 2011 · All replies 0 Sign in to vote Hi, search for WMI VBA – there are plenty sample using it to get computer details Alex "hrubesh" wrote in message

Jul 13, 2012 · Using VBA, I need to manipulate the content of a simple flat text file (.txt) which has been embedded in a Microsoft Office Excel document. I need to save it as a file and/or being …

Feb 9, 2017 · I want to trigger a VBA sub or function by an external (home made) program. I thought to use the windows messaging queue for this. Is there a way BVA code can monitor …

Aug 16, 2012 · 2. Delete the selected value For exemple I defined a list with the values that I named "animals" based on values in ranges A:1 to A:3 Let's say the values are A:1= dog, A:2= …

Jan 8, 2013 · What are the VBA objects/collection that control and can manipulate the numpages and pages fields. Also if I want to create a simple user form or code that allows the user …

Jul 29, 2008 · Your message was not delivered because the destination computer was not reachable within the allowed queue period. The amount of time a message is queued before it …

Oct 30, 2019 · Esse assunto de matrizes é novo para mim. Trabalho com arquivos com mais de 100 mil linhas, no qual o uso de um loop no objeto Range acaba sendo completamente …