Recent content by Monkey Man

Can't you just rename the file to have the txt extension: strPth = "C:\Whatever.jps" strNewPth = Left(strPth,len(strPth)-3) & "txt" Name strPth As strNewPth then open it with: application.FollowHyperlink strNewPth then when done reverse the naming process Name strNewPth As...

You need to ReDim your array (not too sure on this myself, but I'll give it a try...) First, when you declare your array you musn't put in any bounds: Dim strRecTo() Then if you ever want to redimension your array you use the redim statement: Redim strRecTo(n,1) Note: I thought I read...

:D I like it....... :D I must admit I tend to jump on the API wagon far too quickly..... :rolleyes:

It's the path of the file. You don't need to put in the name of the application as the functions looks in the registry to see what application is associated with that file extension (so it works with any file - .doc, .bmp, .mp3, .pdf etc....) Jordan

Use ShellExecute API... It opens the file you specify with whatever default program is associated with it (whether it be Acro 4,5 or 6): Private Declare Sub ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal...

No real difference, Mile-o-phile's is neater (and looks more impressive from a coding point of view), Rich's is a bit longer but is probably easier to understand by someone new to vba. The only difference may be speed but with a single execution you won't notice a difference.

I don't think it's possible just through a macro. You could use the Output to command to export the table to a file in the temporary folder, then use a VBA procedure (which you can call from the macro after you have exported the file) to open up the file, set the password and then e-mail...

Change the timers interval to whatever blink rate you want, create a static variable to act as a counter. With each execution of the timer event you increment the counter by 1. Each execution would involve: 1) Checking to see if the update counter has reached the refresh value (say 60 if the...

I'm not 100% sure of what you want. Will the map need to be editable by the user (because you mention opening it in paint), else why not have a few image controls on the form, one for the main map & then create more at run-time & place them where needed over the map... You can (if accurate...

What do you mean..? You can view jpegs using an image box.