Application not working

[Tarun]

Hi,

I have a application Excel(macros) which connect to unix box for FTP'ing the
file which i was running from from shared drive in Win 2000 Professional and
now we have upgraded to Vista Enterprise and now it is not running and gives
an error Pat/Access error "Run time error 75".

Pleae let me know how can I fix the issue. It urgent as I am not able to run
the my daily reports.

Thanks!

 

[alexB]

You have to give many more details for people to figure it out. Do you get
any errors? What does the app say when you try to run it, etc. etc. etc.

 

[pcourson]

I am trying to log into a state run (oregon) website called ORPIN. Vista/IE
says I need to have a valid session. What do I do now?

 

[Andrew McLaren]

I have a application Excel(macros) which connect to unix box for FTP'ing
the
file which i was running from from shared drive in Win 2000 Professional
and
now we have upgraded to Vista Enterprise and now it is not running and
gives
an error Pat/Access error "Run time error 75".

Have you opened ports 20 and 21 in Windows Firewall?

By default on Vista, the Windows Firewall is active and Ports 20 and 21 are
CLOSED.

Hope it helps,

 

[Tarun]

Hi,

Can you please let me know how to open that port 20 and 21.

But if i try to FTP rfom teh cmd prompt of my machine. I am able to connect
to the server and get the specified file from there but not able to connect
via Vista.

I dont have adminstrative rights on the machine.

 

[Tarun]

The application opens up and when i log into the application and click on the
execute button i get an error Path/Access error "Run time error 75" and the
application keeps running without doing nething .... Have to close the
application forcefully.

 

[Tarun]

The person who created has left and thats y i have come to the forum for help
.... this application is running fine on Win 2000 but now since my company is
moving to Vista i'll like to have your expertise to help me find the solution
to this problem.

 

[Andrew McLaren]

Actually I think the main clue is the error message, Error 75: "Path/File
Access Error".

This is a VBA error message, probably generated by the Excel VBA macro.
During a file- or disk-access operation (for example, Open, MkDir, ChDir, or
RmDir), the operating system could not make a connection between the path
and the file name. Make sure the file specification is formatted
correctly. A file name can contain a fully-qualified or relative path. A
fully-qualified path starts with the drive name (if the path is on another
drive) and lists the explicit path from the root to the file. Any path that
is not fully qualified is relative to the current drive and directory. This
error can also occur while attempting to save a file that would replace an
existing read-only file.

What directory is the macro trying to save the file in? Do you have
permissions to write to that directory?

If the macro is trying to write to a location under the "Documents and
Settings" directory, this could well fail - in Vista, "Documents and
Settings" is replaced by "Users"

You'll probably need to modify the Excel macro to suit the layout of the
file system on the new machine.