Opening workbooks with wildcard

[redmarko]

Hi

I am having an issue with this piece of code not working on my home pc (XP and excel 2010) whilst working with no issues on my work pc (win 7 and excel 2010).

Please Login or Register  to view this content.

Can someone suggest an alternative code and a reason as to why this is happening?

I dont want to have two different sets of code. This is madness.

[HaHoBe]

Hi, redmarko,

please wrap your procedure in Code-Tags and rethink the title of this thread: if you loop through the workbooks in an instance the workbook you search for must be opened, according to your code you want to activate it (why???).

Either Use

Please Login or Register  to view this content.

which will deliver > 0 if the string is incorporated in the name (position of first string of match) or

Please Login or Register  to view this content.

Ciao,
Holger

[redmarko]

Hahobe

The workbooks are indeed open. I want to activate these workbooks to copy worksheets from them into the main spreadsheet from which I am running the code.

None of your suggested codes worked.

The code I have is perfectly logical and runs good on my work pc.

Is there are problem with using wildcards or something??

[Solus Rankin]

Is there only one workbook named item report? Is the wildcard for the file extension? I think part of Holger's question is why loop through all of them if you're only trying to work with one of them?


e/
Please do not create duplicate posts for the same issue. http://www.excelforum.com/excel-prog...t-working.html

[redmarko]

Solus

There are multiple item reports. There could be anything up to 30.

This isnt a duplicate post. The first post was about searching and opening workbooks using wildcards.

This thread is about workbooks which are open and activation off.#

The two posts are kind of linked in that wildcards are my problem.
Wildcards that work on my pc at work but not at home.

[redmarko]

A difference that I have noticed between what is happening at work and at home is the way the workbooks are opening.
In work when I open multiple workbooks they open up under one session and show as one tab in the windows taskbar. At home the workbooks open in individual tabs.

[Solus Rankin]

Sounds like they are opening in multiple instances of Excel.

If I'm not mistaken. The workbooks collection is only the workbooks open in the current instance of the application.

[redmarko]

Yes it looks that way but they wont open any other way.

[HaHoBe]

Hi, redmarko,

if you open the files from the Windows Explorer or FileDialogue and have them opened in multiple instances please have a look for a checkmark next to

Please Login or Register  to view this content.

If it is checked please uncheck and try again.

Ciao,
Holger

[redmarko]

HaHoBe

It is unchecked already. I have googled and tried most other suggestions without success.
I am going to uninstall and re-install office.

[redmarko]

Ok I uninstalled and reinstalled office 2010 and my workbooks continue to open in seperate instances. My code is still not running correctly.

I then installed same version of excel on my daughters laptop (win 7) and when i open multiple excel files they open up in a single instance but the code still does not work.

Im totally baffled now. The only place my code works is on my work pc.

Please Login or Register  to view this content.

Can anyone suggest code to replace above code?

[Norie]

Use code to open the workbooks.

[redmarko]

Norie

Give us a clue!!

[redmarko]

I finally have an answer.

Got it in VBAexpress.com!!
I have no idea why it works but it does. The logic of vba, lol.

Please Login or Register  to view this content.

It seems that you have to write different code to suit slightly different pc setups.
So much for transferability. I bet the code above will probably cause a problem on my pc at work.