Dear Matthew,
Use following function:-
=CELL("filename",a1)
Note:- A1 means reference to any of the cell in the spreadsheet.
This functin will get you the complete path and now you can use it as per
your needs.
Best regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 98109297
Option Explicit
''user can choose 1 or more file from open dialogue
''path will be displayed by bsgbox
'''for more help check out the link
http://groups.google.com/group/excel_vba
Sub UseFileDialogOpen()
Dim lngCount As Long
' Open the file dialog
With Application.FileDialog
Hey, does anyone know how to get a macro to insert a folder path into
a cell? I'm not talking about the whole filepath like in using
dim x as string
s = application.getopenfilename
I need only a folder, as I am then going to access that cell to
determine where to save a bunch of files later on i
