Search results

I download from a ftp server using winSCP, zip files into my local folder, which works fine. get *.zip C:\backupshare\2024\Reports\TCC\tcc\ The issue is the remote Archive folder has daily files zipped at the end of the day and named as 20240729, 20240730 ..... Currently it downloads all the...

Hi, I have a string which reads the date as 20240730 "C\backup\LReports" & "\Output\" & sFolderLocation & "\" & "Report_" & sDateTimeStamp & ".xlsm" sFolderLocation = CStr(Year(Now())) & Pad(CStr(Month(Now())), 2) sDateTimeStamp = CStr(Year(Now())) & _...

I modified my code and I am able to extract

it says Object variable or with variable not set Set shellApp = CreateObject("Shell.Application") ' Open the ZIP file 'Set zipFolder = shellApp.Namespace(zipFilePath) shellApp.NameSpace(zipFilePath).CopyHere shellApp.NameSpace(fileItem).Items

These two lines Set zipFolder = shellApp.Namespace(zipFilePath) If Not zipFolder Is Nothing Then The error is "the Zip file could not not be opened."

Hi, I am trying to extract the contents of a zip file into another folder while saving them as .txt files. But where the code is bold, it says "the Zip file could not not be opened." Function ExtractZipAndSaveAsTxt(zipFilePath As String, destinationFolder As String) Dim shellApp As...

Hi, I get a file loaded everyday into a folder in C named as in stock_distribution_20240726.xlsx. The format is stock_distribution_yyyymmdd.xlsx. I need to rename this file as stock_distribution.xlsx by stripping off the date before linking it to my table. Using FileSystemObject and...

Hi, I inherited a Access database and I need help to convert a SQL connection. What is the equivalent Access SQL? SELECT CONVERT(VARCHAR(8), GETDATE(),112) AS system_date, acct, acct_name, symbol, sym_no, hold_type, sec_name, asset_type, sec_type, cusip, sedol, isin, --country...

ughh..I missed that. Thanks

I am getting syntax error in the line shellCmd = strQuote & strSFTPDir & "winscp.exe" strQuote & " " & strQuote & strCommand & strQuote This is my complete code Dim strQuote As String Dim shellCmd As String Dim strCommand As String Dim strSFTPDir As String strQuote = Chr(34) strSFTPDir =...

I solved the winscp issue by running it manually. But one question. It ran when I put BAT file and the text script in the same location of the winscp.exe. Previously, I was trying to run from other directory, it did not run. That is weird. I am going to check this further and also try the Shell...

My issue now is, I get no error when the code runs. But when i open the linked table, it prompts me again for login credentials!

can you please share the delete and relink link?

I get no error but when I refresh the table, it brings up the SQL server connection gui

Database is a required parameter. My question is if I need to just go with the SQL server database = Reports or further parameters?

Hi All, To refresh the link of an Access Table to a specific table/view in SQL server, how would I do that? tdf.Connect = "ODBC;Driver={SQL SERVER};Server=xx.xxx.xx.xxx;Database= Reports;Trusted_Connection=no;UID=user;PWD=xxxxxx" do i give the the reference to the remote sql server table name...

you are right! I commented out the excel code and it works.

Hi All, I have this Excel VBA code which loops through the files in folder and saves them as .txt. How do I use it in a Access form without the workbook reference? Option Compare Text Sub CopySheetToClosedWB() LoopAllFolderAndSub ("C:\Users\PC\ Desktop\TEST\") End Sub Sub...

then how to make the call for winscp?

I'll change it to cd /ftphome/DeliveryOrders and call using winscp.com /ini=nul /script=dtccwinscpfile..txt