Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open file on a specified Worksheet
Hello.
How can i open a file on a certain worksheet? Thanks Luis |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open file on a specified Worksheet
What does that mean?
Do you want to import a text file into an existing sheet? -- Regards, Tom Ogilvy "Luis" wrote in message ... Hello. How can i open a file on a certain worksheet? Thanks Luis |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open file on a specified Worksheet
No. I have a xls file with 2 sheets and i i have 2 options to open the same
file, and i want that when the user chooses one option the file opens and displays the corresponding sheet. Tom, maybe you could help me on another question. I want to open a txt file on an FTP location. That FTP location has Username and password. Can i pass these parameters on the opening command? The problem is that i need to put the username and password everytime i open the file. The site is allready added to Excel. "Tom Ogilvy" wrote: What does that mean? Do you want to import a text file into an existing sheet? -- Regards, Tom Ogilvy "Luis" wrote in message ... Hello. How can i open a file on a certain worksheet? Thanks Luis |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open file on a specified Worksheet
Private Sub Cmd_Sheet1_Click()
Dim bk as Workbook Set bk = workbooks.Open(Filename:="MyFile.xls") bk.Worksheets(1).Activate end Sub Private Sub Cmd_Sheet2_Click() Dim bk as Workbook Set bk = workbooks.Open(Filename:="MyFile.xls") bk.Worksheets(2).Activate end Sub you can try the URL You might look at this thread for other considerations (internet transfer control, for example) http://groups.google.com/groups?thre... icrosoft.com -- Regards, Tom Ogilvy "Luis" wrote in message ... No. I have a xls file with 2 sheets and i i have 2 options to open the same file, and i want that when the user chooses one option the file opens and displays the corresponding sheet. Tom, maybe you could help me on another question. I want to open a txt file on an FTP location. That FTP location has Username and password. Can i pass these parameters on the opening command? The problem is that i need to put the username and password everytime i open the file. The site is allready added to Excel. "Tom Ogilvy" wrote: What does that mean? Do you want to import a text file into an existing sheet? -- Regards, Tom Ogilvy "Luis" wrote in message ... Hello. How can i open a file on a certain worksheet? Thanks Luis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open Worksheet with exel file | Excel Discussion (Misc queries) | |||
Is there a way to open an excel file to a specific worksheet? | Excel Discussion (Misc queries) | |||
Any way to open an excel file directly to a worksheet? | Excel Discussion (Misc queries) | |||
How do I open a .wks file (worksheet) in an Office XP product? | Excel Discussion (Misc queries) | |||
open file dialog-select file-import worksheet | Excel Programming |