Programming

How can I set up an excel file to auto import data from a CSV fil
I have a program that sends information into a .csv file. Unfortunately I can not use formatting options with this file (ex. formatting cells as currancy) So, I want to create an excel file that will automatically update every 1 minute or so. The only problem I'm having is that everytime it goes to import excel a... 17 Jul 2008 15:49

VBA IDE Settings
Hi Does anybody know where the IDE Options setting are stored. Specifically the Editor Format ones. I've looked in the Registry but can't find it. Any ideas? Cheers Dave F. ... 17 Jul 2008 13:44

Protecting a worksheet
Hi all I have a worksheet that contains aprox 8 buttons that each run a macro to complete certain tasks from displaying userforms to moving to another worksheet. Rather than adding code into each macro, is there a way to protect the worksheet, unprotect whilst any macro is run then protect it again once the... 17 Jul 2008 15:49

AutoUptade an Image from the Web in a Worksheet
Hello, I would like to know If there is a Macro I can create to autoupdate a Image on an Object/Shape/Etc. but the image is not stored locally it's on a Web Page, I know that If I add the code to the "Auto_Open" Macro it will do it on open but I need the code to update the image from a web source. Any and A... 17 Jul 2008 13:44

Copying multiple worksheets to a template using vb.net
I am really new to programming Excel with vb.net. I have created a template that has 4 features on it. Basically they are 4 different tables with the same headings. I generate the worksheets that will populate the data on the template. The first cell on the worksheet is feature name, the next row starts the dat... 17 Jul 2008 12:42

INDEX, MATCH, AND OFFSET... OH MY!
I have text data in cells (A1:A10) In (B1:B10) I have the following formula... =IF(A1>0,A1,"") In C1 I have the following array formula... {=INDEX(B1:B10,MATCH(TRUE,B1:B10<>"",0))} That gives me the first cell in Column B with text in it, which changes as I remove data from Column A And here's my qu... 17 Jul 2008 16:51

Unable to change security setting from "High" after reinstalli
Hi, Charlie, I'll give this SELFCERT.EXE/MAKECERT.EXE thing a go and let you know what happens. Thanks for pointing me in its direction! :-) Pete "Charlie" wrote: Others have asked about this. It has been a nuisance to me too. In fact, we had another update pushed out on Monday that seemed to ... 17 Jul 2008 12:42

adding a page number in a cell
How could you get it to work if some worksheets are larger than 1 printed page in size? "Bill Renaud" wrote: Anyway, maybe you mean to use something like the following. It puts a page number in cell I7 on each of the selected worksheets starting at (page) 1. This assumes that each worksheet is only 1 ... 17 Jul 2008 12:42

if then insert and add
I am trying to put together a bill of materials for requesting hardware quotes. My worksheet has drop down validation for getting the part numbers and descriptions. What i need to happed is that when I a certain part number is selected it automatically inserts a row below with another part numer and quantity. T... 17 Jul 2008 13:44

Delete first line From CSV file from excel
I am modifying a csv file from VBA and am adding a line to the beginning of file which is working well. However, I'd like to delete teh first line of the csv file before adding the line. I have many files so it is not efficient to open them from excel. I'd like to use the VBA Put, Print, Write statements e... 17 Jul 2008 12:42