Recent content by camiramzi

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...