I'm trying to paste some values in a column removing any blanks that are copied with the following code shown below. I figured I could using special cells with xlCellTypeConstants to do so, but keep receiving the error "Unable to get the SpecialCells property of the Range class"...
I have the following code to open up a csv file
I am trying to autofit all the columns and then save and close the file
However when opening up the file, the columns are not autofitted to the length of the largest item in each column
Kindly amend my code below so that the columns autofit...
I'm relatively new to VBA. Trying to use a script in Outlook that will save a specific excel attachment when it arrives, then open it and run a macro contained in the workbook. Here is the code I have now. It works but the problem is that it will not overwrite the file in the save...
My code aims to import a csv file and make certain modifications, but I keep getting a 'Sub or Function not Defined'-error.
Any ideas why?
Dim ws As Worksheet, strFile As String
Set ActiveSheet = ws
The code below imports csv files from a folder into an Excel worksheet and then moves the files to a different folder.
The csv's individually contains only two values seperated by a semicolon, Value1 and Value2 (e.g.: File1 = 773463;CT778884343, File2 = 544543;GH832539371)
The Excel sheet...
I seem to be having some difficulties getting a formula array to work in VBA. I'm not quite sure what I'm doing wrong, but could someone lend a hand? The way I currently have it set up it does nothing.
Thanks very much!
'Turn off warnings and popups