Search results

arnelgp you are a legend thank you.

this vba code combines multiple excel files into one spreadsheet how can i change it so it's merging files horizontally next to each other this is the code Sub simpleXlsMerger() Dim bookList As Workbook, bFirst As Boolean, ws As Worksheet, wsO As Worksheet Dim mergeObj As Object...

i found this answer in quora When i remove the commas inside the paragraphs the quotation disappear in the export text

i don't understand what do you mean by exporting the text file to another db.

I get the same problem in CSV , is there a VBA code to prevent quotation from appearing in the beginning of every paragraph.

Hi i'm using this vba code to convert excel sheets to txt file Sub ExportSheetsToText() Dim xWs As Worksheet Dim xTextFile As String For Each xWs In Application.ActiveWorkbook.Worksheets xWs.Copy xTextFile = CurDir...

i get this error in sPath =

this is my file

Doesn't work unfortunately i most forgot to add a reference or something thank you

please bare with me i'm a complete beginner this is what i did i created a module name it modFTP then i copy paste the first code then i created a class named it FTPlist and put the second (Function for getting the list..) code and the last one (the actual code for obtaining the list of...

yes but i didn't know how to implement it in access , i didn't understand what is the Main Windows API declarations for wininet.dll

i tried the answer in stackoverflow here but i get path not found error in Set baseFolder = fso.GetFolder(localRoot)

Hi as the title suggests i have an ftp server with pdfs inside, i want to retrieve the filenames of all the family tree inside the server and export as an excel sheet or txt file.

i'm asking is it possible to take a snapshot from phone camera and images will automatically imported to access this is the function that scans from the feeder. Public Function feederscan() 'Must include reference to Microsoft Windows Image Acquisition 2.0 dll On Error GoTo Handle_Err Dim...

Hi i use this app to scan and export to pdf from a scanner device but i want to scan with my phone this is my code for the feeder scan With wiaScanner.Items(1) wiaScanner.Properties("3088").Value = 1 .Properties("6146").Value = DLookup("[Colour]", "DPI") 'Colour intent (1 for...

Hi access programmers i have an app that i scans and attaches docs before i was naming my files like this is there a way that i can create a button to rename my attachement in access subform and desktop with Nin field thank you.

Hi @arnelgp if you have time can you answer this problem please using this application the conversion to pdf works great but after converting six or seven times it converts to empty pdfs (totaly blank) then i have to restart access app in order for it to convert normaly again i wonder if this is...

arnelgp i can't thank you enough brother god bless you.

Hi arnelgp is it possible if you could help me add a msgbox when there is only pdfs in the subform list and no jpgs. the message will tell the user that he can't convert to pdf cause there is no jpgs(images) i tried the InStrRev(![Path] & "", ".jpg") <> 0 Then that you give me but it didn't...

i did that Thank you for your help arnelgp