Search results for query: *

I have a folder that has 100s of subfolders. I want a list of all the folder names exported to a Excel column. so, my input should be the main folder path. My output should be the list of all the folder names written to a spreadsheet from Cell A1 downwords. any help will be appreciated

I have 2 tables for a library. Table1: has the book details with the book-number being the primary key Table2: has the details of borrowed books. This table also has the column book-number- linked to Table1, using the same column. I need to make an SQL query that gives the list of AVAILABLE...

I have a folder full of text files. Each of these file has a phrase that needs replacing by another phrase (same phrase for each file).It will take me ages to open each of these text files and do a replace function. Is there a way to create an excel file with macro set up such that 1) in Column...

I need an acurate way of reading off an intersection point from a chart (intersection between 2 curves). Is there way of reading off the X and Y co-ordinates of the intersection as you hover the curser over the intersection point. (it is impossible to solve the 2 equations analytically)Has...

I need an acurate way of reading off an intersection point from a chart (intersection between 2 curves). Is there way of reading off the X and Y co-ordinates of the intersection as you hover the curser over the intersection point. (it is impossible to solve the 2 equations analytically)Has...

I have an incredibly large text files that take ages to open. All I'm interested in seeing is the first 20 lines of each of these text files. Is there are clever way of seeing the first 20 lines, without having to open the entire file- in VBA?

is there a way to find the last cell in, say, Column B. The thing is, column B has some empty cells here and there. I want to be able to extract the row-index (eg, 17th row) that has no data whatsoever below it

I have an excel file that has some macros here and there. Pretty basic macros. Worksheet_change() event etc. I'm encountering a problem when I try to save and open the file again. It totally ruins the file. It says error occured, but Excel made the following repairs. Then below it says damage...

I’m looking to activate some VB code when the user changes the font colour in a cell. Worksheet_Change doesn’t seem to work. Any ideas?

Hello there, I’m trying to colour some excel cells in a unique way. In column A, I have some names of people. Each person has a unique colour associated with his/her name. So, when I write that persons name in (lets say, cell A5) I want D5:F5 (3 cells) to go blue (or whatever the colour...

I’m trying to colour some excel cells in a unique way. In column A, I have some names of people. Each person has a unique colour associated with his/her name. So, when I write that persons name in (lets say, cell A5) I want D5:F5 (3 cells) to go blue (or whatever the colour associated with that...

I have a large text file to download in excel... impossible to download directly cos it's more than 65000+ lines. This file contains about 20 chunks of data..Ideally I would somehow like to download each chunk into sepate sheet in the same excel workbook. Each of these chunk of data has a...