Search results for query: *

I have an Excel macro that I programmed in Visual Basic. I would like to keep it so people that have the macro can't go digging around in my code. Does anyone know how to put this sort of password protection on? Thanks.

Its been fixed- the problem is that what I was trying to do is actually impossible. I wanted to have a single macro output the results of two different but related calculations into two different cells. So your solution really wouldn't have done it. Thanks though. For those of you watching...

I have a finished macro but am now interested in making it an add in. Does anyone know how to do this?

ok, its that thing that means im out of luck. to get around this then do i have to have a second macro that is identical to the first but has the second bit as the inportant part? do i need to change varialbe names or anyhting?

I have made a VB macro that has more than one output but I am having trouble getting the two outputs into the correct cells. I have one cell whose formula is =Function(A, B). That one works fine but the Function also needs to put data into a cell that is two cells to the right (ie, Function is...

I have made a VB macro that has more than one output but I am having trouble getting the two outputs into the correct cells. I have one cell whose formula is =Function(A, B). That one works fine but the Function also needs to put data into a cell that is two cells to the right (ie, Function is...

Actually, with that last little detail everything is running smoothly. Jim- I'm actually glad you missed it too, I felt like a jackass sitting here by myself. Anyway, if anyone is interested, this is what the program should do (although, like I said I don't need anything else, this is just if...

It says that Option Explicit can't be used here. Only in procedures or something. This is not the complete code but it very nearly is. The variables are scanned in from Excel at the beginning and the output is... outputted back into Excel at the end. It looks something like: Dimming of...

I have a for next loop that is supposed to go from 1 to 4 but stops at 1.5. If anyone can see anything wrong I would appreciate hearing about it. Dim varOne(4) As Single Static A(4, 8) As Double Dim Total As Double Static varTwo(4, 8) As Double Dim Max As Double For D = 1 To 4 Step 1...

Thanks, yeah that worked. In the process it has, however, become clear that there is another problem. Again, foada, I have spent about 4 days trying everything under the sun to make that work. You have no idea how grateful I am.

That is pretty close to what I want to do. The cells aren't all nicely arranged though. One is in B20 the other is B18 etc. So, if I understand this (which is possible I suppose) what I want to do is use pretty much the lines you have but add some more of them. So it would look like: For iR...

I posted this before and I got some help but I think I wasn't really clear enough about the problem. I am trying to get about 6 cells worth of data from one sheet in excel, about 4 cells worth from another sheet, do some simple calculations with those numbers, and then put the results into a...

I posted this before and I got some help but I think I wasn't really clear enough about the problem. I am trying to get about 6 cells worth of data from one sheet in excel, about 4 cells worth from another sheet, do some simple calculations with those numbers, and then put the results into a...

OK. This is what I have (some old code was just 'ed and the dimming isn't included but I think you can figure out what this is. Its still not working though. It stops between the Set wkb line adn the Set wks line. Any suggestions? ' Create App,Book,Sheet objects Set objXL =...

I forgot to say what SolarLoadIntensity is although it should be somewhat self explanatory. This variable is dependent on the direction so that SolarLoadIntensity(1) is used with windim(1,1 ) to calculate the solar load coming in the front window when traveling north. Also, I won't need to...

OK, you guys really are helping me quite a bit. I haven't programmed anything for about three years and back then it was in C. Anyway, enough of me, more about my problem. Here is the code I have in there right now. I'm calculating heat flow into a car. Since the sun shines in a specific...

Well that is an unsettling though Stewart because I thought I understood your submission pretty well. Nikita- let me look at yours again and see if I can follow it.

Alright, so I`m dumber than I thought. I do need a bit more help. Let`s assume the file name is Greedo.xls and the worksheet is called Greedois(retarded). Also, later on I will need to get some more data out of a different worksheet in the same file. Do I need to do anything differently...

I am trying to get data from a spreadsheet into a VB file for a macro. There aren`t any manuals here in English so although I`m sure this is an easy question I have no way of looking it up. Anyway, I think I can do this using automation. I only need to get about 10 cells worth of data into the...