Can this vbscript be modified to run in Excel VBA?
Option Explicit
Dim oJet 'As DAO.DBEngine
Dim oDB 'As DAO.Database
Dim oTDef 'As DAO.TableDef
Dim blTExists 'As Boolean
Dim strSQL 'As...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_22897113.ht...
Hello,
I have thousands of word files in weekly folders in a root directory. They are all named DCC55675432 FIRSTNAME LASTNAME.doc. They all have a common setup template and the first two paragr...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_23085073.ht...
The code below is fantastic for my use for files in one location. However, is there a way to utilize an array name origPathArray with, say these items in it:
C:\PDF Copy Test\Orig\
C:\PDF Copy Te...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_23201771.ht...
I need help working with arrays.
the following:
Set rg = objXL.worksheets(1).Range("a1:AD117")
Call RangeToArray(rg, arr)
ListBox1.List = arr
What I would like to do is once a selection is...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_23546875.html
Hi,
I'm presently completing an automation task in VBScript, (I'm fairly well versed in VBA but very new to VBScript), and want to open several Excel files as well as various other folder location...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
I would like to know if its possible to do OCR in VBScript or VBA .. I basically want to take an image of black/white text and parse it out into a document.. there is no interference.. just black/w...
http://www.experts-exchange.com/Software/Office_Productivity/OCR/Q_23457255.html
How can I create a truly global variable using Outlook macros? By truly global I mean that it is instantiated when Outlook loads (or the first time any Outlook macro is called) and it lives until O...
http://www.experts-exchange.com/Software/Office_Productivity/Groupware/Outlook/Q_23073832....
What's the best way to look up a contact using an email address when there are multiple contact folders under Contacts? The use case I'm looking at is one where I'd like to have a simple shortcut t...
http://www.experts-exchange.com/Software/Office_Productivity/Groupware/Outlook/Q_23077530....