Search : in
By :

Open an Excel file from aform in VBA

Last answer on Jul 4, 2009 8:39:57 am BST NAcho111, on Jul 3, 2009 2:28:38 pm BST 
 Report this message to moderators

Hello,

I am having trobules trying to open an excel file from a form using VBA I can open a file using the next code:

Workbooks.Open Filename:="Z:\06 Elaboración\Prueba 3.0\Agua.xls"
ThisWorkbook.Close
Sheets("Agua").Select
Load Agua
Agua.Show



The problem is that the file that I need to open also have forms but it does not open automatically

I will apreciate your help a lot

Configuration: Windows XP Internet Explorer 7.0

Best answers for « Open an Excel file from aform in VBA » in :
Photoshop CS3 - How to open RAW files? ShowPhotoshop CS3 - How to open RAW files? Issue Solution Note Issue I have installed Photoshop CS3 and i'm using canon EOS 450D camera I am trying to edit RAW pictures using Photoshop CS3 but they can’t open And i also...
How to open file .ps (Postscript) ShowHow to open file .ps (Postscript) INTRO Using PDF Creator Using Ghostview INTRO PostScript (PS) is a page programming language used for desktop publishing. Below is a small tips on how to open .ps file. Using PDF...
[Ubuntu]Change default application to open a file Show[Ubuntu] default application to open a file When you double-click a file, a default action is executed. (For example, if you double-click a .jpg file, it is the image viewer "Eye of Gnome" which is launched). It is very easy to change...
Download Excel File Repair Show
Download Notepad++ ShowNotepad + + is an editor of source code , which supports several programming languages: This project, based on the Sparkled constituent (a very powerful editor of component)), is written in pure C + + with win32 api and STL (which insures the most...
Download Excel Password Recovery Master Show
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
Ask your question Reply

1

 Excelguru, on Jul 4, 2009 8:39:57 am BST
  • +5

Hi Nacho111

Change the sequesnce to this

Workbooks.Open Filename:="Z:\06 Elaboración\Prueba 3.0\Agua.xls"
Sheets("Agua").Select
Load Agua
Agua.Show
ThisWorkbook.Close Winners are losers who got up and gave it one more try. -Dennis DeYoung
My Interests are financial Modelling and custom excel development.

   
Reply to Excelguru
Ask your question Reply
They need your help