| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Excel
Hi All
I was wondering if there is code that can open a new excel window that allows the file I have saved in the XLSTART folder. Jason Zischke |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open Excel
Try:-
Sub marine() Path = "C:\Program Files\Microsoft Office\OFFICE11\XLSTART\" Name = "Book1.xls" Workbooks.Open (Path & Name) End Sub Mike "Jason Zischke" wrote: Hi All I was wondering if there is code that can open a new excel window that allows the file I have saved in the XLSTART folder. Jason Zischke |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open Excel
Hi
Thanks for the responce but I found that would open in the same excel window what I'm looking for is a way open a file in a new excel window run its code then shutdown while I'm in the other excel window doing something else. Jason "Mike H" wrote: Try:- Sub marine() Path = "C:\Program Files\Microsoft Office\OFFICE11\XLSTART\" Name = "Book1.xls" Workbooks.Open (Path & Name) End Sub Mike "Jason Zischke" wrote: Hi All I was wondering if there is code that can open a new excel window that allows the file I have saved in the XLSTART folder. Jason Zischke |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open Excel
If that didn't work then I suspect it's an Explorer issue. Have a look here.
http://groups.google.co.uk/group/mic...64839d48a8fc50 Mike "Jason Zischke" wrote: Hi Thanks for the responce but I found that would open in the same excel window what I'm looking for is a way open a file in a new excel window run its code then shutdown while I'm in the other excel window doing something else. Jason "Mike H" wrote: Try:- Sub marine() Path = "C:\Program Files\Microsoft Office\OFFICE11\XLSTART\" Name = "Book1.xls" Workbooks.Open (Path & Name) End Sub Mike "Jason Zischke" wrote: Hi All I was wondering if there is code that can open a new excel window that allows the file I have saved in the XLSTART folder. Jason Zischke |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening Excel, Book1 opens, remains open with other workbook open | Excel Discussion (Misc queries) | |||
| excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
| EXCEL wont open from Explorer, must open EXCEL then find file | Excel Discussion (Misc queries) | |||
| workbooks.open function fails to open an existing excel file when used in ASP, but works in VB. | Excel Programming | |||
| Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed | Excel Programming | |||
Linear Mode
