|
Monday, August 24, 2009 - 7 Posts by 4 People
I am trying to enter the following on an excel spread sheet from vb.net:
applic.activesheet.cells
and the send keystrokes to excel then you need to set the value or formula and i believe in order to send
the keys to excel it needs to have focus. sending keys is not something you can send as string as john
|
|
Wednesday, January 11, 2006 - 13 Posts by 9 People
Can Visual Basic 2005 read and write to an excel xls file? Can it do it without an addin
the Visual Basic 2005 Express Edition can read and write to an Excel spreadsheet. But if someone...
It most certainly can, has to be able to really since you script excel with VBA. Read
|
|
Thursday, September 28, 2006 - 5 Posts by 4 People
Something i have to do a macro using Visual Basic Editor.
is that true? is there any other way that i can ...
Hi
im using Excel for a project and i heard that is i want to pull a picture when i select
to be the appropriate tool to use. What does the project do. I would recommend using Visual Basic
|
|
Friday, December 14, 2007 - 13 Posts by 2 People
Are there VBA code examples for the U3 that are compatible back to Excel 97? If not, would
it be hard to make the example that is given for Excel 2000 compatible with Excel 97?
Also, since the U3
and reopen Excel.
* Need the "Control Toolbox" and "Visual Basic" toolbars.
1. Select "Command
|
|
Wednesday, May 16, 2007 - 10 Posts by 6 People
Trying to use the help tool within Excel and the Visual Basic Editor, but I am only getting Microsoft...
the Visual Basic Editor.
I found in the Microsoft Excel Help information about how to get Microsoft...
: Microsoft Excel". When you open help from the VBE it should read "Help Topics: Visual Basic
|
|
Tuesday, November 17, 2009 - 4 Posts by 4 People
Hi...so I have a problem with my visual basic program....it wont compute...and it keeps
particular reason for using VBA?
As a side note, I think you should also re-evaluate your variable
should give your variable a different name such as lngRow . Secondly, in VBA an Integer data type can
|
|
Friday, January 11, 2008 - 13 Posts
Pals
I want to write a VBA or a spreadsheet that calculates bar forces in a statically determinate
truss of any configuration. I do a lot of truss calculations and a spreadsheet would be handy
Anyone
to have a few Excel spreadsheets for truss and frame analysis using visual basic macros on his...
|
|
Friday, May 29, 2009 - 5 Posts by 5 People
_". I would like to list those table names in a listbox menu in an MS Excel 2002 spreadsheet. Any ideas
.
In Excel define a reference to the Microsoft Access object. Then stick something like this in a VBA
in the Visual Basic editor. This page should get you started on how to use ADO.
You might find
|
|
Thursday, August 27, 2009 - 28 Posts by 3 People
Worksheets accordingly, per type of project. The basic categories are Project Name, Job #, Address
it to populate a spreadsheet.
Id suggest you open the file, open the visual basic editor, select a...
for the given name) and concatenate the text to populate the spreadsheet.)
As far as possible, Ive used VBA...
|
|
Friday, October 30, 2009 - 11 Posts by 3 People
I need a spreadsheet program that can:
1. Operate cross platform (my IT guys PC, Im Mac)
2. Sort
capabilities to five, ideally six, levels
3. Capable of using macros
4. Can convert spreadsheets
-contained procedures in which the statements are written using VBA (Visual Basic for Applications)....
|
)