Open File

amna77 · May 20th, 2002, 01:29 PM

Hi,
Actually I want to open power point files from Excel. I have like 100's of power point slides, and they are saved by numbers. like WI-1263, WI-5896, and so one.
I want to craete some kind of searh box, so when ever they enter that file name in the cell,then it should look in that C: drive and search for that file and open it up.

Is it possible to do it?
Any help?
Thanks in Advance

Marcus_Neto · May 20th, 2002, 01:44 PM

One way of doing what you are asking is to dedicate two cells to entering in the information that will lead you to the file in question. In other words make A2 = the path and B2 = the filename then just use

'Selecting directory in which file resides
Range("A2").Select
gblSourceDirectory = ActiveCell.Value

'selecting source file name
Range("B2").Select
strSourceFile = ActiveCell.Value

And

File.Open Filename:="" & (gblSourceDirectory & strSourceFile)

Should open the file.

HTH,
Marcus

amna77 · May 20th, 2002, 01:56 PM

Is is possible to copy the same above codes,a dn paste them in access database.
2 text fileds, one for qrive path name ans second file names and then open that file. is it possible in access as well, or not.

Marcus_Neto · May 20th, 2002, 02:02 PM

Quote:

On 2002-05-20 12:56, amna77 wrote:
Is is possible to copy the same above codes,and paste them in an access database.
2 text fields, one for drive path name and second file names and then open that file. is it possible in access as well, or not.

?? OK you have officially lost me. Why would you be trying to open PowerPoint slides using Excel or Access? Are you trying to build a front end to something else that I am not aware of. It seems to me that you are adding complexity that needn't be added....

amna77 · May 20th, 2002, 02:05 PM

No I was just asking about that.

its kind of front end sheet, only in one cell they can enter file name in order to open. My boss does not want any body to go in that folder. if they know the number, they can type that in, and open that slide. Thats what I am trying to do.

Marcus_Neto · May 20th, 2002, 02:13 PM

Sounds like you might want to rethink the direction in which you are heading. The only way to keep them out of a folder is to lock them out and if you do that then i am not sure that adding a Excel front end is going to allow them to open a file in a folder that they have access to. Have you ever thought of dedicating some server space to a small and easy web page. This would allow people to view the documents but not make any changes. Or you could simply lock them and allow them to open them. But the web page would be really easy and seems like it would be what you are looking for. Expecially since you can save PPT slides as web pages directly.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 20th, 2002, 01:29 PM	#1
amna77 Board Regular Join Date: May 2002 Posts: 251	Hi, Actually I want to open power point files from Excel. I have like 100's of power point slides, and they are saved by numbers. like WI-1263, WI-5896, and so one. I want to craete some kind of searh box, so when ever they enter that file name in the cell,then it should look in that C: drive and search for that file and open it up. Is it possible to do it? Any help? Thanks in Advance

May 20th, 2002, 01:44 PM	#2
Marcus_Neto New Member Join Date: May 2002 Location: Chantilly, VA Posts: 9	One way of doing what you are asking is to dedicate two cells to entering in the information that will lead you to the file in question. In other words make A2 = the path and B2 = the filename then just use 'Selecting directory in which file resides Range("A2").Select gblSourceDirectory = ActiveCell.Value 'selecting source file name Range("B2").Select strSourceFile = ActiveCell.Value And File.Open Filename:="" & (gblSourceDirectory & strSourceFile) Should open the file. HTH, Marcus

May 20th, 2002, 01:56 PM	#3
amna77 Board Regular Join Date: May 2002 Posts: 251	Is is possible to copy the same above codes,a dn paste them in access database. 2 text fileds, one for qrive path name ans second file names and then open that file. is it possible in access as well, or not.

May 20th, 2002, 02:05 PM	#5
amna77 Board Regular Join Date: May 2002 Posts: 251	No I was just asking about that. its kind of front end sheet, only in one cell they can enter file name in order to open. My boss does not want any body to go in that folder. if they know the number, they can type that in, and open that slide. Thats what I am trying to do.

May 20th, 2002, 02:13 PM	#6
Marcus_Neto New Member Join Date: May 2002 Location: Chantilly, VA Posts: 9	Sounds like you might want to rethink the direction in which you are heading. The only way to keep them out of a folder is to lock them out and if you do that then i am not sure that adding a Excel front end is going to allow them to open a file in a folder that they have access to. Have you ever thought of dedicating some server space to a small and easy web page. This would allow people to view the documents but not make any changes. Or you could simply lock them and allow them to open them. But the web page would be really easy and seems like it would be what you are looking for. Expecially since you can save PPT slides as web pages directly.