Hi all!
First, thank you every one here who spent so much time trying to help
me with the first time trying to do this. That means everyone!
I used a combination of all of your suggestions and research that we
did together.
I finally succeded to:
-Transfer a file that the client can use to update their calendar on
their website.
-To do that, I used WinSCP. I realize many people use it but the
documentation that I had to search for on the web was confusing. Not
documentation that I would release to the public for sure!
-So now I am going to have the client install winSCP and walk them
through it our do it myself using a remote software.
-They or myself will have to create the batch file using winSCP. Not
what my goal was!
-The batch file that winSCP is invalid. It wants to create a log in a
directory that does not exist and into a file that doe not exist. No
matter if that option is unchecked in the crazy interface, it will
still do it when generating code for a batch file!
-After many errors running it, it finally dawned on me that I had to
delete the line that created it in a directory that does not exist and
a file that does not exist. And it worked!!
-I was able to do the whole thing via MS Access! I struggled with all
the suggestions here to run a batch file until I finally stumblled
upon this guys website. I was ready to quit but check it out:
Option Compare Database
'---------------------------------------------------------------------------------------
' Procedure : RunFile
' Author : CARDA Consultants Inc.
' Website :
http://www.cardaconsultants.com
' Purpose : Run/Execute files from vba (bat, vbs,…)
' Copyright : The following may be altered and reused as you wish so
long as the
' copyright notice is left unchanged (including Author,
Website and
' Copyright). It may not be sold/resold or reposted on
other sites (links
' back to this site are allowed).
' Input Variables:
' ~~~~~~~~~~~~~~~~
' strFile - full path including filename and extension
' strWndStyle - style of the window in which the program is to be run
' value can be vbHide,vbNormalFocus,vbMinimizedFocus
' vbMaximizedFocus,vbNormalNoFocus or vbMinimizedNoFocus
' Usage Example:
' ~~~~~~~~~~~~~~~~
' RunFile("c:\test.bat", vbNormalFocus)
' Revision History:
' ~~~~~~~~~~~~~~~~
' Rev Date(yyyy/mm/dd) Description
'
**************************************************************************************
' 1 2010-Feb-05 Initial Release
'---------------------------------------------------------------------------------------
Function RunFile(strFile As String, strWndStyle As String)
On Error GoTo Error_Handler
Shell "cmd /k """ & strFile & """", strWndStyle
Error_Handler_Exit:
On Error Resume Next
Exit Function
Error_Handler:
MsgBox "MS Access has generated the following error" & vbCrLf &
vbCrLf & "Error Number: " & _
Err.Number & vbCrLf & "Error Source: RunFile" & vbCrLf & "Error
Description: " & _
Err.Description, vbCritical, "An Error has Occured!"
Resume Error_Handler_Exit
End Function
*---
Now I can transfer a encrypted file to the client's website, have the
DOS window not appear and also I can connect to a website to say that
it was updated using the HyperlinkkAddress in Access that will open in
the default browser.
But, of course, things can change in a day or so!! :-)
My wife is trying to get them on AWS -i.e. the could. May not work,
but it was a frustrating but rewarding process!!!
Yes, we are a husband and wife team!! Imagine that!
Thank you all! I will start another thread soon when what I did no
longer works! LOL!
-paulw