Search:

Just checked, one of them is called Check Box 9

so it must be a forms control...?

Same message when I try that code

I can't remember whether I chose activeX or Form controls, but I am prompted to load ActiveX controls when I load the message...

Thanks for your reply, I've used your code to loop through the objects on my front sheet

When it gets to a drop down or checkbox it fails saying

Object does not support this property or method...

Also,

front is a worksheet within the workbook

I have tried looping through the shapes too, but it does not appear to acknowledge the existence of the checkboxes...

Thanks for your reply westconn1

This works on my personal PC with Office 2010, but not my work PC with Office 2010 and 2007.

I am looping through the checkbox collection, so I shouldn’t have to...

Hi,

I have the created the following procedure in Excel 2010, which should loop through each of the checkboxes on a given sheet and will expand of collapse depending on each checkbox's value

I...

Sorted it

Let me know what you think



Sub condf()
Dim selcell As Range
Dim cell As Range

You're right :p

Thats why I'm looking to automate it

I have two sheets identical in structure, one is Quarter 2 and the other Quarter 3

I want to compare quarter 3 with Q2 to see of there is...

sorry mate yeah office 2007

when you go in to conditional formatting

then format based on cell value (top option)

within there you can set traffic lights for red amber green

I'm looking to automate this process, but...

hi,

I've searched as mush as possible (google etc), but maybe my search terms aren't accurate enough

anyway I have 400+ cells that I am looking to apply conditional formatting to
...

Top man!

Still just learning SQL, was confusing myself with all kinds of joins etc

Thanks again!!

cheers Pradeep,

If I wanted to multiply x by a value from table b as well, that would work too yeah?

I have two tables (simplified below)

Table A
x desc
-----
1 xxx
2 xxx
3 xxx

Table B

My bad!

It says "SQL Syntax Error"

But I can't see what the problem could be! :(

new to this side of things!!

This is the string I've got when my code runs

can see you what the error is?

It's connects to an access database, my SQL isn't too hot!

Is there any where I could learn more advanced stuff...

Spot on Si!

Not in work till Thursday now, so I'll check it out then and will let you know!

Thanks!

Mitch

You have probably done this but,

rather than use the Calc Now option (F9)

Have you tried the Calc Sheet option in the Calculation tab in options?

Hi,

I am attempting to create a querytable, as soon as a workbook is opened.

I have had a bit of a nightmare with the Syntax for the SQL.

I am attempted to pull all records from a table,...

nope that didn't even register ha!

ah well, ignore me

Sid, I like it!

Using office 2007, i open my mp3

click the mute button and I receive

Object variable or With block variable not set

i'm guessing because the tool bars aren't created in...

FileCopy "C:\temp\Test1.xls", "C:\temp\backup\Test1_20090113.xls"

that's the basics of it, you can work the file names to allow you manipulate the strings instead of hardcoding them in to your...

whoops didnt read the last couple of posts haha!

I know this is an old post but...
what I have done in the past is:

Create a workbook, which contains your data (Don't have this as a shared workbook)

Have another workbook, where the user...

You've probably thought of this but...

Could you use Thisworkbook.path?

and do you need to use notepad?
Word can create .txt files, so if the user has excel installed surely they will have...

The only lines you'll need are

Open myfilepath & ".txt" For Output As #1
Print #1, mytext
Close #1

I use the attached code here to create a .txt file(which i then change to a batch file), and update it with certain items

You could modify this to suit your needs

Open...

Couldn't you use the Go To Special option in excel?(select your range and press F5, then click Special...)

the example below selected numbers and text in the selected range.
...

They'd still get round it, as they would just disable macros when opening the file

I tend to use an Index Match combination, will give you the same results as above
But thought it worth posting anyway

=INDEX(Sheet2!$D:$L,MATCH($A1,Sheet2!$A:$A,0),2)

0 in this formula again...

cheers mate, made the amendments as per your post

excel is falling over at wb.save, only after find and replace has been done

My security settings are ok, as I have allowed for programmatic...

still not working :(

modified code is below

Sub open_workbooks()
Dim cell As Range

For Each cell In Range("A2", Range("A2").End(xlDown))
Application.EnableEvents = False
...

i didn't read the full topic sorry, just posted the code to loop through all sheets

yeah all my file names are in column A

I can't see where the error occurs, as when i step through the code it works fine

it's when i set it off running on its own, its causes excel to crash

Sub sheet_loop()
Dim i As Integer

For i = 1 To Sheets.Count
Call CopyDupRows
Next i

End Sub

Excel keeps encountering an error when i set it off on its own

if i step through the code it works fine

any ideas?

Sub open_workbooks()
Dim cell As Range

For Each cell In Range("A2",...

wont let me leave you rep, says i need to spread it about a bit before giving it to you again ha!

Spot on mate, that works a treat

bit gutted the intellisense (sp) doesn't work on the find/replace/deletelines and insertlines functions you posted :(

will search for them now though

just to...

Hi,

I am looking for a way to update the same module in over 100 files.

All i need to do is update a variable value from 24 to 8.

I know you are able to update lines of code in modules, but...

just found this

here

Get Quick Access to File Properties by Using the VBA File Functions
You can quickly obtain file properties such as the created date, the last modified date, or the number...