Opening a file

[camjon]

I am learning how to program in VB right now, I just want to know what is the syntax for opening a file, I know how to do it in C++ but im confused on how to do it in VBA

 

[AnotherHiggins]

VB, or VBA? This is a VBA forum.

A great tool for learning VBA is to turn on your macro recorder and do whatever you want, then observe the generated code.

If you're in Excel, you can turn in on by going to Tools > Macro > Record New Macro.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[camjon]

Im am using vba, i apologize for the confusion....but thank you for the advice

 

[AnotherHiggins]

I should also mention that the code that is generated by the Macro Recorder is sometimes (if not often) bloated.

It's still a great way to see how things are done and learn syntax, but feel free to post what you come up with for tips on trimming it down.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[xlbo]

google
"file open vba"
returns a ridiculous number of hits, the 1st of which is:

http://www.mrexcel.com/td0009.html

or as John says, you can use Tools>Macro>Record New Macro



Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[camjon]

Ok, Thanks again....I will play with the macros