E
erick-flores
Hello all
I need to open an excel file from my access form. Everything is working
fine, here is the code that I am using:
Dim MyObject As Object
Set MyObject = GetObject("C:\MIS Inventory.xls")
MyObject.Application.Visible = True
MyObject.Parent.Windows(1).Visible = True
The problem is, I want to open a file that is on the network, this is
the path:
\\Dc-tfh\mis\MIS Misc\Inventory\Hardware Inventory.xls
It is working fine when the file is on my C: drive but not the one in
the network. Any ideas why? do I need to add something to my code?
Also I would like to open an specific worksheet, how do I do that?
I have been reading in this NG and try different codes w/o any luck.
Finally, Let say I have 100 records in the excel file...I am using
Access to navigate through all those records, I find a mistake (or want
to update) in the record number 45, is there a way to click an open the
excel file (that has all the records) and automatically place the
cursor in the record 45? so I can easily change it w/o having to look
through the entire file
Thank you in advance
I need to open an excel file from my access form. Everything is working
fine, here is the code that I am using:
Dim MyObject As Object
Set MyObject = GetObject("C:\MIS Inventory.xls")
MyObject.Application.Visible = True
MyObject.Parent.Windows(1).Visible = True
The problem is, I want to open a file that is on the network, this is
the path:
\\Dc-tfh\mis\MIS Misc\Inventory\Hardware Inventory.xls
It is working fine when the file is on my C: drive but not the one in
the network. Any ideas why? do I need to add something to my code?
Also I would like to open an specific worksheet, how do I do that?
I have been reading in this NG and try different codes w/o any luck.
Finally, Let say I have 100 records in the excel file...I am using
Access to navigate through all those records, I find a mistake (or want
to update) in the record number 45, is there a way to click an open the
excel file (that has all the records) and automatically place the
cursor in the record 45? so I can easily change it w/o having to look
through the entire file
Thank you in advance