$$Excel-Macros$$ VBA: Entering a Foldername in Collumn A should list me its Subfolders in B (comma seperated)

I have the following folder(or directory) structure: list_folders.xls (in ROOT) & /Folder01/Subfolder01 /Folder01/Subfolder02 /Folder02/Subfolder01 /Folder02/Subfolder02 I want the makro to read the foldernames in Column A, and as a result i would like to see the Subfolder Names in Column B (S

$$Excel-Macros$$ Re: Run-time error '-2147352571 (80020005) - Type Mismatch

Thats a great idea... Sorry, I didn't think of that... here is what the problem was: I was using a table named LookupLists to store values for different comboboxes on my userform. The table contained multiple columns for multiple comboboxes and each column had different no of rows. The UserId f

$$Excel-Macros$$ Value in Merged Cells

I am trying to access the contents in the merged cells E2:M2. This works: Merge_Value= Sheets("P2").Range("E2").Value Why doesn't this?: Merge_Value= Sheets("P2").Range("A2").Offset(0, 5).Value Is there a better way to try to get at the value? --~--~-~--~~~---~--~--

$$Excel-Macros$$ Macro: Tricky problem!! A1=name of folder >> B1= Subfolders,seperated by comma

I have the following folder structure: /Folder01/Subfolder01 /Folder01/Subfolder02 /Folder02/Subfolder01 /Folder02/Subfolder02 list_folders.xls should be in the ROOT I want the makro to read the foldernames in Column A, and as a result i would like to see the Subfolder Names in Column B (Seper

$$Excel-Macros$$ Re: Highlight present week with a border

The atttached WorkBook starts at L4 rather than A4. If you have any questions let me know. Tom On Mon, Feb 9, 2009 at 6:18 AM, Ometoon wrote: > > Hi Tom! > > Thank you very much for your file! I have only one small question: > Is it possible that the function starts in Cell L4 instead of A4? I

$$Excel-Macros$$ Using Application.Run on COM commands

I would like to know whether it is possible to use Application.Run on a COM command within VBA. I have a test architecture that takes advantage of the flexibility of Application.Run in its handling of an arbitrary number of arguments and have found that when the macro name is a COM (rather than p

$$Excel-Macros$$ Re: Run-time error '-2147352571 (80020005) - Type Mismatch

So why you don't want to share with group mates??? - Original Message - From: Alokeshwar Tiwary To: excel-macros@googlegroups.com Sent: Monday, February 09, 2009 2:46 PM Subject: $$Excel-Macros$$ Re: Run-time error '-2147352571 (80020005) - Type Mismatch Kindly ignore the

$$Excel-Macros$$ Re: Run-time error '-2147352571 (80020005) - Type Mismatch

Kindly ignore the request.. I figured it out myself..   _ "There are known knowns. These are things we know that we know. There are known unknowns. That is to say, there are things that we know we don'

$$Excel-Macros$$ Re: Highlight present week with a border

Hi Tom! Thank you very much for your file! I have only one small question: Is it possible that the function starts in Cell L4 instead of A4? I tried to adjust this in your Weeknum function but I did not succeed unfortunately. Like to hear from you. Regards, Anton On 31 jan, 03:25, Tom Jeffri