start excel file on remote machine

Hello!
I would like to start excel file on remote machine through macro (VBA) run on Excel 2003. I've already searched the web and found this thread http://www.sqldrill.com/excel/progra...te-server.html, which serves me just fine except for the comments of urkec "Depending on what you need to do, you may have problems trying to make Excel
visible:" This is exactly what I am stuck with. Excel does open the file, keeps the process in TaskManager, but stays invisible whatever I do. I've read about dcomcnfg.exe and security settings for "Excel.Application" and add there even "Everyone" group with full access to everything, I add both machines (target and the one macro runs on to a domain and used the same domain account on both) -> still no luck, Excel still keeps invisible. I am pretty sure the thing is about user rights, I keep searching and trying different approaches to solve the problem including posting to this forum. Will report here if found any. Still hope someone could help!?
Thank you!

Originally Posted by Jack in the UK

Remote?

Ok so take it step by step

You have a laptop say at home connecting to works Excel, right?

How are you connecting?

jiuk

I have two machines in office which are both inside Microsoft 2003 domain. I run a code on machine named exceltest02 (192.168.91.52)

Please Login or Register  to view this content.

I have no firewall on 192.168.91.51 and after I run the code a new task appears on TaskManager of exceltest01 (Excel), the file c:\test.xls is being locked by that process, but excel never appears on the screen. This is what I would like to achieve. See actual Excel application on the screen.

Thank you!

Originally Posted by Jack in the UK

You will require both machines to have Excel insrtalled, tahts not totally true really only the viweing machine as the host machine will have the file saved on its hard drive so...
...

If you have the domain... can you not store in the fileserver? And poke that most prob be P drive or O drive etc then you both have access

Thank you, I would try your approach.
Meanwhile I noticed, while debugging, that this property Application.Visible just being ignored to be changed after the line xlApp.Visible = True of my code

Please Login or Register  to view this content.

In Object browser I have objWorkBook.Application.Visible=False after the line executed.
Would that hint someone for a possible solution?


Updated: keeping searching I found http://forums.iis.net/t/1173509.aspx this post and tried to change Console Root > Component Services > Computers > My Computer > DCOM Config > Microsoft Excel Application Properties\Identities to first line "Current user" ( I have Excel in Russian, in English could be smth simular). After I changed that setting and run the code once again, Excel started and xlApp.Visible was set to True.

Thank you!

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

And don't quote whole replies