Stopping a macro to allow you to browse for a file
Stopping a macro to allow you to browse for a file
(OP)
What (if any ) Command is there that will allow a user that runs a macro to browse for a certain file and not use the one that was recorded in the macro intially.
Did you follow that question?
Thanks in advance!
Did you follow that question?
Thanks in advance!
Scott Baugh, CSWP 
3DVision Technologies
www.3dvisiontech.com
www.scottjbaugh.com
FAQ731-376






RE: Stopping a macro to allow you to browse for a file
Download and dissect the "Copy Custom Info" macro from my website at <http://www.esoxrepublic.com/freeware/>.
Review the FileNameToOpen function and its related calls. There are some comments referring to other web resources.
OT: 3rd time in 2 days I used this macro for an example!
RE: Stopping a macro to allow you to browse for a file
OT: Be glad you have it or you would be retyping this time and time again.
Best Regards,
Scott Baugh, CSWP
3DVision Technologies
www.3dvisiontech.com
www.scottjbaugh.com
FAQ731-376
RE: Stopping a macro to allow you to browse for a file
RE: Stopping a macro to allow you to browse for a file
You can also look at thread559-55331
Regards,
Regg
RE: Stopping a macro to allow you to browse for a file
workDir = InputBox("title1", "title2", "\\server\folder1\folder2\...\") 'the 3rd field is the default folder name
filename = InputBox("title1", "title2", "default file name")
filename = workDir & filename & ".extension"
ChDir (workDir)
Open filename For Output As 1
Print #1, "insert the the information"
Close #1
I hope that helps.
Regards