Open workbook, and get its name, and make it active window.

Hi guys

i had this code working.... now it seems to not work... :S

here is my code.

Please Login or Register  to view this content.

i know why the code stops, its because there is no sheet with that name in the active workbook.

but for the love of me when i open the new file, it should become the active window yes? and then i can store that name?

but i just can never get the opened files to become the active window

is it because im using a different method of opening the file instead of workbook.open that i cant grab the name?

cheers

Originally Posted by davesexcel

Try this,

Please Login or Register  to view this content.

this still stops on the selection of the sheet named "SignIQ Price Changes"

Originally Posted by davesexcel

Does the sheet name match the code name?

i thought about that after i posted on the forum, i checked the names, they are the same :S

its to large to attach for others to directly work on.

i have changed my code to this

Please Login or Register  to view this content.

Originally Posted by Norie

Where in the workbook is it located?

A standard module? A worksheet module? The ThisWorkbook module?

the code is in a button, on a userform.

Please Login or Register  to view this content.

i cant it's to large to upload.

https://www.dropbox.com/s/knkodsjdgd...0v2.0.exe?dl=0

here is a link to the file

i should note that if you open it, i have compiled it into a EXE file, if you click on the text on the bottom left corner that says "Version 2.0" 10 times with your mouse, it will make the application.visible = true code run and excel will come back from there, you will be able to access VB, the Sign IQ button on the main menu form, is where the code is.

hope this makes sense.

Originally Posted by Norie

Andrew

That file is blocked, probably because it's an exe.

you cant run exe's ?

i've found a old version that is not a EXE i just ran it, and it seems to work just fine, i dont know why the code works in it tho. I looked at the code and it seems pretty much exactly the same.

https://www.dropbox.com/s/l8j67lgrm6...1%29.xlsm?dl=0

old file version here

i can confirm, its the conversion to EXE that causes it to stop working

it seems when i had compiled it i had set it to EXCLUSIVE WINDOW which meant i could not reference other windows. iv tried a compiled version with out this option and it still worked after compling it to a EXE