Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
OPen and close file
Hi!
Hope someone can help with a inputbox there shall contain a file name, when click i want to close the file I work with now, and open the other file there are written in the inputbox. Best regards alvin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
OPen and close file
Alvin,
Try the following code: Dim FName As Variant FName = Application.GetOpenFilename("Excel Files (*.xls),*.xls") If FName < False Then Workbooks.Open FName ThisWorkbook.Close End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Alvin Hansen" wrote in message ... Hi! Hope someone can help with a inputbox there shall contain a file name, when click i want to close the file I work with now, and open the other file there are written in the inputbox. Best regards alvin |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
OPen and close file
If the code is in the file you want to close, the code stops when the
workbook is closed Dim wkbkOld as Workbook, wkbk as Workbook set wkbkOld = ActiveWorkbook fname = Application.GetOpenfileName if fName < False then set wkbk = Workbooks.Open(fName) end if wkbk.Close Savechanges:=True -- Regards, Tom Ogilvy "Alvin Hansen" wrote in message ... Hi! Hope someone can help with a inputbox there shall contain a file name, when click i want to close the file I work with now, and open the other file there are written in the inputbox. Best regards alvin |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
OPen and close file
Hi
I very try this but i can't i have Application.GetOpenFilename ("excel files (*.xls)","c:\city breaks\priser\usa\order") but i can't get i to work , what i want is to look after the file in the place c:\city breaks\priser\usa\order how do i write this i can open in dokument and so on. Alvin "Chip Pearson" skrev: Alvin, Try the following code: Dim FName As Variant FName = Application.GetOpenFilename("Excel Files (*.xls),*.xls") If FName < False Then Workbooks.Open FName ThisWorkbook.Close End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Alvin Hansen" wrote in message ... Hi! Hope someone can help with a inputbox there shall contain a file name, when click i want to close the file I work with now, and open the other file there are written in the inputbox. Best regards alvin |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
OPen and close file
Dim FName As Variant
Dim sStr as String sStr = "c:\citybreaks\priser\usa\order" chdrive sStr chdir sStr FName = Application.GetOpenFilename("Excel Files (*.xls),*.xls") If FName < False Then Workbooks.Open FName ThisWorkbook.Close End If -- Regards, Tom Ogilvy "Alvin Hansen" wrote in message ... Hi I very try this but i can't i have Application.GetOpenFilename ("excel files (*.xls)","c:\city breaks\priser\usa\order") but i can't get i to work , what i want is to look after the file in the place c:\city breaks\priser\usa\order how do i write this i can open in dokument and so on. Alvin "Chip Pearson" skrev: Alvin, Try the following code: Dim FName As Variant FName = Application.GetOpenFilename("Excel Files (*.xls),*.xls") If FName < False Then Workbooks.Open FName ThisWorkbook.Close End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Alvin Hansen" wrote in message ... Hi! Hope someone can help with a inputbox there shall contain a file name, when click i want to close the file I work with now, and open the other file there are written in the inputbox. Best regards alvin |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
OPen and close file
Thanks for the help Tom
it's working but the first workbook dosn't close before i close all ?? I hav try many things but it dosn't close when i open the next workbook ?? Best regards alvin "Tom Ogilvy" skrev: Dim FName As Variant Dim sStr as String sStr = "c:\citybreaks\priser\usa\order" chdrive sStr chdir sStr FName = Application.GetOpenFilename("Excel Files (*.xls),*.xls") If FName < False Then Workbooks.Open FName ThisWorkbook.Close End If -- Regards, Tom Ogilvy "Alvin Hansen" wrote in message ... Hi I very try this but i can't i have Application.GetOpenFilename ("excel files (*.xls)","c:\city breaks\priser\usa\order") but i can't get i to work , what i want is to look after the file in the place c:\city breaks\priser\usa\order how do i write this i can open in dokument and so on. Alvin "Chip Pearson" skrev: Alvin, Try the following code: Dim FName As Variant FName = Application.GetOpenFilename("Excel Files (*.xls),*.xls") If FName < False Then Workbooks.Open FName ThisWorkbook.Close End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Alvin Hansen" wrote in message ... Hi! Hope someone can help with a inputbox there shall contain a file name, when click i want to close the file I work with now, and open the other file there are written in the inputbox. Best regards alvin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to Open, then Close another File | Excel Discussion (Misc queries) | |||
Delete/Close Excel file that is kept OPEN | New Users to Excel | |||
Text file open and close VBA | Excel Programming | |||
VBA - on a button event, open another closed file, post changes, close file | Excel Programming | |||
Automate open file, update links, run macro, close and save file | Excel Programming |