Thread
:
Open Workbook from VBA
View Single Post
#
2
Posted to microsoft.public.excel.programming
Chip Pearson
external usenet poster
Posts: 7,247
Open Workbook from VBA
Ricardo,
Try something like
Workbooks.Open "C:\folder\" & Format(Userform1.Calendar1.Value, "mm dd
yyyy") & ".xls"
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Ricardo" wrote in message
...
Hello,
I hope you guys can help me, I'm don't have much knowletch
about how to do this, I'm a beginer in the file and I
need to find a way to open a workbook using a calendar
from a userform, my workbooks are save as : "mm dd yyyy"
So I need for the calendar to open that especific
workbook as I enter the date in the calendar, plz. I need
help with this one.
I'll like to thank every one in at banse for eny kind of
idea that you can give me.
Reply With Quote
Chip Pearson
View Public Profile
Find all posts by Chip Pearson