Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Open an Excel file from VB6

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 26-03-2009
Member
 
Join Date: Aug 2006
Posts: 332
Open an Excel file from VB6
  

Hello,

I try to open an excel file to go write an application from VB6. The file name is contained in a variable and I can not open the file. For info, here is the code

Myshell = Shell ( "C: \ Program Files \ Microsoft Office \ Office12 \ EXCEL.exe file", 1)

File is defined earlier is the format c: \ folder \ un fichier.xls


Thank you for your help.

__________________
Do not email me asking for tech support. Any private support is billable at $50 an hour.
Reply With Quote
  #2  
Old 26-03-2009
Member
 
Join Date: May 2008
Posts: 1,805
Re: Open an Excel file from VB6

Hello,

Tests like this:

Myshell = Shell ( "C: \ Program Files \ Microsoft Office \ Office12 \ Excel.exe" & File, 1)
__________________
Darksiders: Wrath of War
Reply With Quote
  #3  
Old 26-03-2009
Member
 
Join Date: Aug 2006
Posts: 332
Re: Open an Excel file from VB6

Hi and thank you for the info. I tried and it does not work. He sends me the file is found. If I file by replacing the true path then it works.

In debug mode, the file is defined as "c: \ my folder \ my file.xls"

You think that was the quotes that put the bazaar, and if so, how can we remove them?

Thank you again
__________________
Do not email me asking for tech support. Any private support is billable at $50 an hour.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Open an Excel file from VB6"
Thread Thread Starter Forum Replies Last Post
How To Open .ods File in MS Excel? Aagman Windows Software 7 10-02-2012 08:06 AM
Excel 2007 file fails to get permission to open in Excel 2011 Raju Chacha Windows Software 6 13-01-2012 08:17 PM
can open my excel 2003 file in xp lyndon123 Windows Software 2 10-10-2011 12:33 PM
Configuring Internet Explorer 8 to open Excel file in to Microsoft Excel Aaghaz Technology & Internet 4 13-02-2011 09:37 AM
Pdf file open in Excel Clemens Windows Software 3 06-02-2009 06:40 AM


All times are GMT +5.5. The time now is 07:19 PM.