Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: SmallCraig
- Content: Threads
- Order by date
-
Variable 'fieldinfo' array in Excel opentext
This is a question I've considered for some time, but the need hasn't been so pressing until now. In Excel, the "opentext" method accepts an array of "fieldinfo", which tells the open method how to treat each column of data imported. I have the potential need to make that...- SmallCraig
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Acces Application updating linked ODBC database
A colleague has developed a solution for one of our users which involves the following: 1. An existing MS Access application; 2. A linked table within the Access database, using ODBC; 3. The link is to an HPe3000 IMAGE database, using Minisoft's ODBC driver. To add another level of complexity...- SmallCraig
- Thread
- Replies: 0
- Forum: Visual Basic (Classic)
-
VBS vs VBScript "Shell" issue
I have a VBA program (macro running in Outlook) which happily (i.e., successfully) executes the following code: Shell ("M:\Program Files\HPCOMMS\HPCOMMS hp;setyymm") However, when I attempt to run similar code from VBScript: set Shell =...- SmallCraig
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
