developer

I'm new at Excel programming, so sorry if the question is too basic. However, I've been messing around with it a while without finding a way: Is it possible to start the VS Developer Command Prompt and a specific command from an Excel macro? That is, have an Excel macro that starts the VS...

Hi All, I am unsure if this is possible so I will do my best to explain what I am looking for! I am trying to write a macro which can close a workbook after another macro has been ran. The first macro runs this unhides a selection of tabs, this is controlled through the click of a command...

Hello Excel friends, I have a form I've created in Excel that has multiple questions. Each question either has a set of answers in the form of either a drop-down (using data validation), check-boxes where one or more options can be selected (using Developer) or radio buttons (using Developer and...

I want to go through a list of dates, and insert new rows with the dates that are missing. For example, from a column of these dates: <tbody> 3/6/2015 3/6/2015 3/16/2015 3/16/2015 3/16/2015 3/17/2015 3/18/2015 3/19/2015 3/20/2015 3/20/2015 3/20/2015 3/21/2015 3/23/2015...

Hi all, Just looking for some macro/developer help for Excel 2007. Basically, I have one database workbook, and I want to disperse the data to various other workbooks as efficiently as possible. I’ve searched for an answer but all I can seem to find is "How to merge data from multiple Excel...

I have a table it has over 400 rows and 13 colums. Data contains history of equipment being rented to customers. Columns includes Id No., Client name, Clients address, Equipment, equipment type, date rented, date returned, delivery location, invoice no, remarks etc . There is search box, its...

Hello! I am an engineer. although my field is not properly the Informatics, I am pretty good in programming with Excel VBA. In the past I worked in a little company, where I developed a macro that made the company save a big amount of time and money (my macro did in 2 minutes what a person...

Hi all I want to protect my VBA code when the file is opened as read-only, such that the users will not even be able to click on the developer-visual basic or press Alt F11. In a word, the whole VBA will be locked, even they have their own files opened that have macro codes, they will need to...

Hi Guys, I have a word document with a table. I use the developer tools - drop down list to populate some fields. However there is a particular field where i need a data source as there are over one thousand companies to search through - i have a csv. I want users to click on this field ( with...

Afternoon all - I'm throwing my hat in the ring as an Excel developer and consultant and am wondering if anyone can give me advice on putting together printed marketing materials. I'll put together a website at some point, but for now I'd like to visit businesses in person and drop off...