Search results for query: *

I would like to automate access to a linux web server to download excel spreadsheets. Another department places results in a spreadsheet and places the spreadsheets on a web server. They granted me permission with a logon and password, and through internet explorer, go to the web server click on...

I found one major flaw in my thinking. I just read on page 293 in "EXCEL 2000 VBA" by Bullen, Green, Bovey, & Rosenberg that "if you supply a key value for each memeber of the collection, the keys must be unique. You will get a run-time error when you attempt to add a new memeber to the...

I have used the following: MyString = "some where over the rainbow?" MyAnswer = InStr(1, MyString, "w") MyAnswer will equal 6 If I was looking for the letter "q" then MyAnswer will = 0 Hope this helps.

You are correct. I have several errors in my code that I need to clean up. Sorry for the bad code. As you can see I'm not very good at this. Thank you for pointing this out.

I'm trying something new. I want to learn how to use class modules, because I think it will take less time to process. Previously, I would read the data into table arrays and spit out the results in a results table. Here is an example of what I'm trying to accomplish. Here is my Data. 1 AIG...

Here is some code I cut from various projects that I thought would help you accomplish your goal. I didn't verify every variable name, so you have to be careful. Naturally, you will have to modify it to suit your needs. I included all the public variables names and modified others, but your a...

Thank you Tony for such a quick respone. Your code has proven to be an excellent lesson. I hope to call these objects and assign additional variables to them now. Before I had been using tables or arrays and looping through them to find the exact reference has always taken longer than I thought...

I was trying to learn something new. I wanted to take an example from my book, "Teach Yourself Excel in 21 Days", on page 457, was an example of a user defined class called electric heater. I want to be able to create multiple heaters and name each one something different. Here is an example of...

Thank you for your help, the "=T" worked.

I was trying to use the advanced filter under data/filter and my criteria was just one character such as the letter "T" but unfortunately it also gave other values which began with the letter "T" such as "TGT" or "TRP". I double checked and made sure I was filtering for only unique values, but...

Thank you. It works!

I'm trying to loop through shapes on a worksheet. These Shapes happen to be check boxes. I can call them by name as in this example. ActiveSheet.Shapes("CB20_DTS").Select But what I wanted to do is use the FOR LOOP but I can't seem to find the right wording. This example doesn't...

Purhaps the two file system might be good idea. What if your file on your desktop were upon change to a cell, try to open the master file and copy the information to the proposed cell. If file was in use, then the message could be file in use. Otherwise, if it found the corresponding cell not...

try selecting cell b1 and go to window/freeze panes you might also try window/split good luck

Another option Sub ShadeRowsGray() Dim Today As Date Dim MyRowCount As Integer Dim MyColumnCount As Integer Dim x As Double Range("a1").Select Set Table1 = ActiveCell.CurrentRegion MyRowCount = Table1.Rows.Count MyColumnCount =...

Here are simple examples of changing case Sub MakeUpper() MyValue = ActiveCell.Value MyNewValue = UCase(MyValue) ActiveCell.Value = MyNewValue End Sub Sub MakeLower() MyValue = ActiveCell.Value MyNewValue = LCase(MyValue) ActiveCell.Value = MyNewValue End Sub Changing to sentence case...

The correct way to write a SQL statement is as follows: sQuery = "SELECT * FROM master WHERE date = '17-jul-2003'" now try this. If it doesn't work, then it might be your connection to the database. Does other SQL statements work? Lets say that this works.

I see a lot of good stuff on this idea but I did it my way. I threw in a calendar of holidays, too. I checked to make sure it works - you can make it a function if you want. Enjoy! Sub dude() Dim newnum As Range Dim startday As Date Dim lastday As Date Dim count As Integer Dim dateItem(9) As...