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'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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.