Open Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Try:-

Sub marine()
Path = "C:\Program Files\Microsoft Office\OFFICE11\XLSTART\"
Name = "Book1.xls"
Workbooks.Open (Path & Name)
End Sub

Mike
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Workbook to Open a new excel Window 1
Screen Resolution 2
Error Checking 1
Load forms from another workbook 2
Toolbars 2
File won't Open 1
Setting columnwidths 5
Open and save blank workbook with Command Prompt 0

Back
Top