ExecuteExcel4Macro

**Ranjani** · 05-04-2009, 04:39 PM

Hi,

I am trying to read some values from a closed workbook.

I use the following code

Please Login or Register  to view this content.

But GetData always have this value 'C:\Program Files (x86)\Microsoft Office\Office12\LIBRARY[Upload.xla]Hidden'!R4C1

instead of getting the value from the address R4C1 in hidden sheet in Upload addin , it always has the as path to address which is "'C:\Program Files (x86)\Microsoft Office\Office12\LIBRARY[CostUpload.xla]Hidden'!R4C1"

Can u anyone tell me where I am going wrong??

**shg** · 05-04-2009, 04:47 PM

As a minimum, you're missing the backslash after LIBRARY in the path.

**Ranjani** · 05-04-2009, 04:56 PM

Hi SHg,

I did try that , i changed data to "'C:\Program Files (x86)\Microsoft Office\Office12\LIBRARY\[CostUpload.xla]Hidden'!R4C1"

and GetData still holds the value 'C:\Program Files (x86)\Microsoft Office\Office12\LIBRARY\[CostUpload.xla]Hidden'!R4C1.

Thanks

**Ranjani** · 05-04-2009, 05:11 PM

Hi Shg,

I removed the enclosing string in

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

and it worked !!

Thanks Shg,

**rockyw** · 10-25-2012, 01:21 PM

Can this be modified to find duplicates in the closed workbook and return a message (date taken) Thanks

**protonLeah** · 10-26-2012, 02:12 AM

rockyw,
Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.