Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
VB still on L plates
Name: Greenteeth Date: October 8, 2003 at 04:57:11 Pacific OS: windows 2000 CPU/Ram: P3
Comment:
Hi there, I am trying to learn VB by writing small macros within Excell.
But I keep getting stuck on syntax. I am looking for a command line that opens the "File Open" dialog box. Is this possible?
Name: BaBa Date: October 9, 2003 at 16:26:25 Pacific
Reply:
Hi, Doing macros in Excell is VBA. I'm not too good in VBA. However, I think you can use the macro recorder to write the code for you. Then look through the code to see how the macro recorder does it.
The macro recorder records everything you do and writes the code for you automatically. Then you go to "edit macro" to see the code. Baba, have fun!
0
Response Number 2
Name: Global Date: October 10, 2003 at 01:50:30 Pacific
Reply:
That is certainly the easiest way to get the required code that you are after and then manipulate it to do whatever you want.
You can also use the code directly in VB providing the reference to Excel is loaded to give you a little more flexibility as well.
I think the VBA help is also pretty good for Excel too.
Summary: Unfortunately, VB is especially bad at interacting with DOS. Many things that can be done in DOS are fairly easy to do in VB, though. On thing you can do is run .BAT files using VB's Shell() function:...
Summary: Hi, Basic was created with the intent to be easy. It was created to teach students and beginners how to program, so it was very easy. The reason is it hides the complications of programming from the u...
Summary: still doesnt work IVO.. could it be because the first part of the search is from the root of Marie and targets are at marie1 and marie2? the source would be on a sub-folder of Marie and targets would ...
0 
