Background: Have a VBA script which runs in Excel 97
It creates a Worksheet and then fills the cells
with text. The size of the VBA script(approx 28 pages
printed) soon exceeded the resource of EX...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10082640.html
Zones:
Visual BasicDate Answered: 09/21/1998 Grade: A Views: 0
I am a new VBA programmer. I am having trouble getting Application.OnTime to work in VB for Excel. The code seems to work sometimes but not others (without changing anything but the time stamp). ...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10128423.html
Zones:
Visual BasicDate Answered: 02/16/1999 Grade: B Views: 9
I've created a Word7 template which has a VB label control on it. The Labels caption property is a serial number which is generated by the Document.New event.
I want to set the title of the new do...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_101...
We're running NT and I've got an Access database that has ODBC/linked tables to multiple SQL Servers. I set up the Machine DSN's through 'ODBC Data Sources' in Control Panel, and they work great.....
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20437784.html
Zones:
MS AccessDate Answered: 01/03/2003 Grade: A Views: 0
Two quick questions:
1. What is the format for adding SQL statements within VBA code??? Specifically the characters needed to signify the start and end of the sql statement.
Do you have to writ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20960284.html
Zones:
MS AccessDate Answered: 06/18/2004 Grade: A Views: 0
G'day
I have a VBA app that runs within Excel. I want to be able to export the userforms and code across to VB to make a standalone app.
The app needs to run both in the Excel environment and...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Controls/Q_23074943....
I always SET object = nothing at the end of a procedure.
Should I do the same with variants, given that they occupy lots of memory?
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_23139598.html
I am creating an "application" in MS Access 2003. I want a user to be able to drag a device independent bitmap (DIB) onto a treeview and have it automatically save that DIB as a file.
I know I c...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_235...
I'm reading through a text file using Line Input (VBA from Excel), and when I get to the end, I need to go back to the top and start again, looking for different pieces of data.
Is there somethi...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
I have created an O(n^2) algorithm, but like it to be more robust and quicker if possible as it might be used repeatedly on fairly large data sets. It should also be able to adjust the ouput array ...
http://www.experts-exchange.com/Programming/Algorithms/Q_23811694.html
