Replies

Again this works perfectly so thanks – only problem is it is bringing in tabs for Legal Pleadings, Letters and Faxes etc that I don’t want – I only want to show the templates in the folder I have set. Is there a way to do this.

thanks for your help

Again this works perfectly so thanks – only problem is it is bringing in tabs for Legal Pleadings, Letters and Faxes etc that I don’t want – I only want to show the templates in the folder I have set. Is there a way to do this.

thanks for your help

Thanks that worked a treat. Is there a similar command for File New. The scenario I am trying to create is a menu for the templates in the firm by department and I dont want anyone opening the templates I need it to be as if they had gone into File New and selected it. So basically they will click on a menu with a number of departments listed and when they click on the dept I want them to access the Files but as templates so they launch as a document and dont open as the selected template.

I hope that makes sense. Any help would be much appreciated

Thanks that worked a treat. Is there a similar command for File New. The scenario I am trying to create is a menu for the templates in the firm by department and I dont want anyone opening the templates I need it to be as if they had gone into File New and selected it. So basically they will click on a menu with a number of departments listed and when they click on the dept I want them to access the Files but as templates so they launch as a document and dont open as the selected template.

I hope that makes sense. Any help would be much appreciated

thanks for this – the problem is that it will be a brand new report everytime so I need something that will run each time the workbook is open. The program where the report is loaded from just creates a new report each time called the same thing (ie Report.xls) that overwrites the previous one. I need a report that will run with each new instance of the report.

thanks for this – the problem is that it will be a brand new report everytime so I need something that will run each time the workbook is open. The program where the report is loaded from just creates a new report each time called the same thing (ie Report.xls) that overwrites the previous one. I need a report that will run with each new instance of the report.

the report is launched from another system as part of a script that is running and I would not want the macro to be stored in report.xls

the report is launched from another system as part of a script that is running and I would not want the macro to be stored in report.xls

Where do I find this tab – on the hyperlink screen I get I dont see it?

Thanks for that – I think I am being really stupid but if I type the full path will it still not point to the document where it is stored at that point and not allow me to move it? For example if I was working with a document setting hyperlinks to go to another document all stored in a folder on my desktop called Theresa – if I transfer that folder onto CD rom will it not fail as it is looking for my desktop?

Hi there

I have had a look at the screen when setting up hyperlinks and there doesn’t seem to be an option for “use relative path in hyperlink”. I have attached a picture of the dialog box as it appears on my screen – am I missing something

thanks again that worked perfectly. As a point of interest – is there a way to get your own message box in this situation or is the fix you gave me the only solution?

Thanks for your help – I will play around with it, this is not the only piece of code behind the OK so it might be being affected by something else.

Thanks again

I made the changes you suggested but I am still getting the same error – if that should be working I am now wondering if it is giving me an error due to another problem . Any other thoughts?????

I got your last reply emailed to me but for some reason it cant find your last post

Here is the piece of code you were asking for

Dim clrec, clnum As String

If txtClientNum.Value “” And Not IsNull(txtClientNum.Value) Then
Open “s:eliteftpclient.txt” For Input As #2
Do While Not EOF(2) And clnum txtClientNum.Value ‘ Loop until end of file.
Input #2, clrec
clnum = Mid$(clrec, 1, 6)
Loop
If Not EOF(2) Then
Close #2 ‘ Close file.
Else
frmFileRequest2.Hide
MsgBox “Invalid Client Number. Please try again”
Close #2 ‘ Close file.
frmFileRequest2.Show
End
End If
End If