properties

Hey everyone, I need to make my scroll bar move by 0.1 each time the arrows are clicked (I believe this is the 'small change' option) but when I go to enter it in it comes up with an error message saying "Invalid property Value". Also I've set the minimum to be -1 and the maximum to be 2 however...

Sub mac2() Dim Temp() As Variant With ActiveSheet.Shapes(1) If Not Not Temp Then ReDim Temp(UBound(Temp) + 1) Else ReDim Temp(0) Temp(UBound(Temp)) = Array("Top", "Left", "Height", "Width") For Each element In Temp(UBound(Temp)) .Properties(element) = 100 '.Top = 100...

Within VBA, I can easily download a file and then obtain properties from that file using URLDownloadtofile to download a file and .getdetailsof to obtain file properties from the file on disk. However, I want to avoid downloading the file if it does not meet certain criteria, so I want to find...

This may be a philosophical and/or best-practise question, but what is the difference between the usage of Get properties and functions within a VBA class? For example, a class holding information about people may store the Date of Birth with associated Let and Get properties. Should the...

Hi. I need to: - Import all files and file properties including but not limited to path and tags for a specific directory (including subdirectories) - Then I need to add tags to files manually on the tags column - And then add those tags back to the files.(excel or batch for csv file created...

Hello, I have managed to create a command button in excel 2007 that performs a macro upon a click. But, after re-opening the workbook, I am unable to right click on the button to recall the properties window. Any ideas?

What I'm trying to do is very simple - find all the formulas in a workbook that contain references for cells on sheets other than the current sheet and write the list of them to a sheet named "data". The basic logic of the code is also simple: find all the formulas containing "!" in the...

I have a table that I sort in a specific matter then "paste" it sorted just below the unsorted one. ... for i = 1 to lastRowfor j = 1 to 10 Set oldCell = Cells(sortedArr(i), j) Cells(i + lastRow, j) = oldCellnext j next i This works fine, but only transfers the .value from...

Learning Access or know somebody that wants to? This lesson focuses on building Tables and Relationships in Microsoft Access. Learn Access -4- Tables and Relationships (cc) 36:04 (music: JD Live) Learn Access -4- Tables and Relationships (cc -- coming!) 36:04 ~music: JD Live - YouTube The...

Hi there, Is it possible to create a macro that when run will show or export pivot table properties in a report? For example, if you right click on a pivot table cell then select 'Show Properties in Report' you can select items indiviudally. This can take a long time if you have a lot of...

Hi All Possibly a very simple question. In VB when I select a worksheet, I can amend the (Name) of the worksheet in the properties window. There is also the .Name property which is the same as the sheet tag name. I can use the (Name) in vb code to identify the sheet e.g...

Hi Mr. Excel, I'm using Excel 2007 and Windows XP. 1. General Question: How to create a madro to perform common "print set up" procedures. (Every time we print a "Checklist" we have to follow a series of steps... is it possible to have a macro do this?) 2. Background Info: a. To update...

Hi, Is there any way to get an excel workbook's updated properties information (that is, author, last date modified, file size etc) to appear on the first sheet in the workbook every time you open it up? Does anyone have a macro that can do this? Thanks for your help.

Hi, I cut and pasted an online survey from my website into an excel spreasheet. The page has a number of checkbox options which when one is selected, the others in the group are deselected, as expected. I can 'see' the checkboxes as "Control 1" to "Control 19" using the code below. What I...

Hi, Thoughts please... Note: To keep to forum rules, i am not asking how to crack passwords, nor specifics of methods on how to. I was wondering how strong the passwords which protect VBA projects are. I know things like protected sheets can be broken easily by running a piece of code...

Hey Mr/Mrs Excel guros: I have placed several OptionButtons on a worksheet, and am trying to write some VBA that will tell me which button is selected (the status or control value). I know on forms you use the “me.” format. Can anyone tell me how I can get VBA to recognize and access these...

Hi: I need to figure out the VBA---either run by a Word or Excel macro, it doesn't matter---that cycles through all PowerPoint, Excel, and Word documents in a folder and then updates the following property fields: Title, Subject, Author, Category, and Keywords. I can use Application.InputBox to...

How can I programatically find the path and file name for an embedded object? I know I can right click on the object and select Packager Shell Object and then Properties to find the information manually.

Hi, I have a very straight forward spreadsheet, which performs a currency conversion on the first sheet, with user defined currency codes and value. The Exchange rates are obtained through a macro button, which opens a text file, chosen by the user, named ***EXR.txt as a temporary workbook...

I've been asked to create a template for documents created in the company I work for. I was hoping to prompt the user when he/she uses the template to enter some of the document properties and then to use these in the Header & Footer. I have seen that I could use a built in Macro that uses the...