Search results for query: *

I have a spreadsheet with some columns that have a background color, lets say columns one and two. Columns three and four have no background, and when I put in a number or letter, the background immediately becomes the same as in columns one and two. If I set columns one and two to have no...

I have a macro that generates a multiple sheet report by first deleting the existing sheets and recreating them from cumulative data. Though the sheets are deleted, their numbers are not reused when new sheets are added. As a result, I have a template, cumulative data, and (currently) Sheet87...

Is there a way to deal with a failed Workbooks.Open without an On Error statement? For example, if the workbook is already open and changed, a dialog appears asking the user if she wants to reopen the workbook and lose the changes. If she clicks "No", the Open method throws an error...

When using Mozilla, if I follow a link to a video clip, I get Xine with the option (-q? Don't recall offhand) that closes Xine as soon as the video has completed playing. I find this annoying, and would like to remove this from the handler. Where do I find this behavior specified? Is it a...

Is it possible to get Excel to create .gifs of charts without Saving as HTML, reading the HTML for the image source, and grabbing the referenced gif? I would simply like to indicate which chart, what filename, and what location, and end up with the gif. I asked this question last week and got...

Publishing a non-interactive chart in Excel produces a .htm page with a link to a .gif representing the chart. Is it possible to get Excel to produce this .gif for me in a specified location without the .htm?

MS Excel will publish a chart in a web page. If you choose a non-interactive page, this takes the form of a .gif which represents your chart. Is there a way to have Excel produce -only- this .gif for me rather than the whole .htm page?

This is swiftly making me insane. Any suggestions are appreciated. I have a sub that I trigger with the BeforeSave event. This code reads certain cells in ThisWorkbook, then opens a second workbook, records these values, saves workbook 2, then ends, allowing ThisWorkbook to save. In effect...

The question came up recently about sorting arrays and I provided a simple bubble sort that is suitable for arrays up to about 500 elements in size. Noticing that VB's implementation of arrays is woefully lacking, and also that I have a number of functions that make arrays more useful, here is...

Could someone suggest an effective, free as in beer, feature filled IDE? I have used JBuilder, but it literally crawls on a PIII 450 with 384 megs of ram - not a barn burner of a machine, but it should reasonably run an IDE without the user waiting 3-5 seconds for every menu click. Also, I've...

Is it possible to get an outline border in an Excel header? This is necessary for a proprietary information label and management is picky about having a border. If that isn't possible, is there a way I can print an Excel file with a MSWord header? I'm currently playing around with the...

I'm pretty well versed in interacting with Excel through VBA, as some may know, however I haven't touched Word with VBA until today. I am having a terrible time figuring out how to read and process the text. For example, I want to write a macro that will turn VBA comments (' as the first...

Suppose I have Dim AllNumbers(50) As Double and I only use the first 15 doubles. If I pass this array to another method, is there a way to find out how many of these doubles have been initialized rather than just declared aside from iterating through them? If I have an array of strings, is...

I apologize in advance if this is a somewhat stupid question. Everything I do with Excel is done through VBA, as a result, I'm really not knowledgeable about what Excel can do on its own. I am working with two worksheets. The second sheet is an expansion of the data on the first sheet. For...

If this is considered an appropriate task, this will be my first foray into XML. I'm painfully new at this. The client should represent tiered data, much like a directory tree or how IE displays a plain XML file. The ability to directly edit the element contents will be a selling point if it...

What's the most stable and convenient way to split a string at arithmetic symbols? Ideally I'd like to use the split method, but once I split the string with one symbol ("+", for example) I have an array of strings which may or may not need to be split at "-", "*&quot...

I have an Excel file with macros intended to function as an electronic log book. When the "template" file is opened, it is immediately given a new number and saved using that number in an archive directory. When input is finished, a macro is executed to email a copy of the file to...

- first note that I'm extremely inexperienced with Linux. I had to look up the man page for ls yesterday, just as an example. I've managed to install Mandrake 7.0 with what I would guess is a permissions problem on my Win95 partition. I would like to be able to write/execute as a regular...

I have between approximately 1000-1500 lines of data which will be broken into as many as 75 charts. I have a macro which gets through about 50 or so charts and I get the very uninformative error message "Not enough memory." The error message is owned by Excel. I have moved the...