icol

I have been using this function for some time to convert a column number to letters. It should take any number and return the correct letters, even double letters, e.g. AH etc. It works, but there is at least one number which causes it to fail - that number is 36. Here is the function: Public...

Hello, I have the following workbook macro that lists all files/folder names from a directory. I would like to exclude all folders from being listed (the only folders that would be in this directory would be .zip folders). Ideally I would not want any folders to be listed in the workbook...

Hi all The following is a multipart macro that is supposed to import various .txt files that are created through analyzing images in a software called Scion. I am having trouble running the macro in Excel 2016 in compatibility mode. When I run the macro part named CL_Air_1, the file dialog...

I have many different macros doing different actions within a spreadsheet by the user selecting the column first and the macro takes action on that column. Example: Sub CopyColumnOfData() Dim r As Range: Set r = Application.InputBox("Click in the column to filter by", Type:=8) Dim iCol...

My code below is functioning just as I'd hoped...almost! I'd like the files to be created in new workbooks rather than sheets. Can someone assist me with the necessary edit to accomplish said result? Thanks Sub parse_data()Dim lr As Long Dim ws As Worksheet Dim vcol, i As Integer Dim icol As...

Good morning, I have a routine that a co worker made that needs to be tweaked (shown below). I have a excel sheet that has 4 columns. The values for each row currently get placed into the word documents text fields. Once the row is completed, it saves the file and opens up a new word document...

Hello, I am trying to use a Do loop for the first time and having some difficulty I want to exit the Do loop when .Cells(irow, icol) = "" and advance to the next row My code only works for the irow = 2, it does not advance i.e. next irow does not seem to be read or executed The For loop is...

Hi all, I haver the following code that inserts a blank row into the data when the reference changes in column C Is there a way for this to work with ONLY visible data (ie there may be hidden data) Many thanks for any info Sub AddBlankRows() ' Dim iRow As Integer, iCol As Integer Dim oRng...

Hi. I'm trying to write a macro in excel 2013 to copy an access query (this is just a run query that does not create a table) and export the results into an excel sheet. I have researched and tried several variations of codes seen online but I keep getting an "object required" error. Any...

Hello all... I am creating a database spreadsheet for files I have on my hard drive. I found the script I want, and it works, but there are 2 functions I would like to have it do to smooth the process. What this code does is pulls all the files in 1 folder & gives me the data from the...