attribute

Can someone help me please. I am trying map out my hard drive – which files are in which folder, folder sizes etc.. This requires that I access folders. The problem is that if the folder attribute is not normal i.e. folder.attribute is not =0 then when the procedure runs I get: Run-time error...

I have a list of data made up of four columns, Element, Feature, Attribute, Life Expectancy, an example would be fire access & security systems(Element)>cctv system(Feature)>recorded(Attribute)>25(Life Expectancy). Each one of the columns is related to the previous one, so if I was to select...

Hi! Whenever I dim an attribute to "shape" it makes it captialize weird. Say I type "dim shp as shape" it returns this "Dim shp as sHape" Anyone know why it would capitalize the "H"?

Hello, i have a book full of item numbers for an ecommerce site. The template requires me to segregate the upload data. I need to Index RAW DATA on sheet10 and place into Sheet4. Step 1 is to find the matching Item# (Key data) and then read across that entire row to find the matching attribute...

Hello all, I am trying to match 2 cells and post result of another cell. here is where I am now. I have 100 attribute labels and attribute values in one workbook. Need to extract the matching Item number I lookup and then find and match all attribute labels and values that are relevant to...

Hello all, So, I'm trying to gather several properties for a number of workbooks in a folder: Original Author Creation Date File Size File Type i have been using the .BuiltinDocumentProperties property to gather the author and creation date but I'm having difficulty getting the last two...

Hi Team, Columns("C2:" & ColumnLetter & rwMax).Select I am trying to select from C2:G16 But Not able to do so with Dynamic values.

I am trying to line up columns of data that are all jumbled. Example. length x width x height are in my sheet in a row. But are in different columns. I've tried to Index and match to no avail. How can I search for a cell label marked WIDTH in a row and then get the next cell to the right with...

Hi, in another thread I outlined problems running version 2007. To resolve tehm I dexcided to buy Office 2010 hoping that would fix things. I've installed it but trouble straight away... e.g. The code in this project must be updated for use on 64-bit systems. Please review and update Declare...

I need to move a series of cells from various sheets to a new "master" sheet. Some are text, some are numbers, some are percents and two are dates. Is there a method or cell attribute assignment that will do this for me? Thanks

Hello, I have a WB with 2 sheets. Sheet1, column "O" is filled with almost identical statements but at the beginning of each statement has a different number pattern. Here's an example. 17849 - 20140469 REPL CLI-UNIT ALREADY TRADED 17849 - 20140237 REPL CLI-UNIT ALREADY TRADED 17849 - 20140193...

Apologies in advance for the ambiguous title. I am creating a sheet to automatically generate SKU's by combining product attributes. <tbody> Product Name Size Color Type Material Shape Quantity SKU 2mm Aqua Glass Rhinestone Round 2mm Aqua Rhinestone Glass Round 3k 2m-aq-rhresrd-3k </tbody>...

Dear All, I've created a file, loaded with macros, userforms and so on The file opening becomes gradually slower over the time (usually takes a few weeks), until it becomes impossible to open it. When this happens, I found a remedy: 1, open it with Excel Online 2, edit it with Excel Online...