Archive for 'Functions'
Get Open or Save-As Filename
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.
GetOpenFilename and GetSaveAsFilename are useful dialogs to use within Excel VBA procedures when your procedure needs to know the filename of a file to open or save. I have encapsulated each into functions that add to their functionality, and make then simpler to use in my procedures.
Note that both GetXxxxFilename functions return file names. They [...]
Posted: Monday, June 30th, 2008 under Functions, VBA.
Comments: 1
File Name Functions
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.
Recently I posted several VBA procedures for exporting charts and other purposes. These make use of a number of procedures that I use when manipulating file names. I inadvertently left these out of the posts, so I am including them here.
The following shows what the functions return when passed a file name and path of [...]
Posted: Wednesday, June 11th, 2008 under Functions, VBA.
Comments: none





