Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Workbook from VBA
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
Opening Excel, Book1 opens, remains open with other workbook open | Excel Discussion (Misc queries) | |||
how do i open a data workbook when i open a timesheet workbook | Excel Discussion (Misc queries) | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
Search open sheets in workbook and insert into open sheet | Excel Discussion (Misc queries) |