LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,514
Default Opening excel 2010 spreadsheet from Access

Sorry about the syntax issue. (I moved it from a normal variable inside
the procedure to a global constant at the top of the module, but forgot
to change the syntax. The declare should read...

Const sXLFileToOpen As String ...

instead of...

Const sXLFileToOpen$

...as type symbols are not allowed in constant declares or Type
structures. My bad!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
opening CSV file in Excel 2010 from VBA Sonnich Jensen Excel Discussion (Misc queries) 1 October 29th 11 04:34 PM
Excel 2010 (64 bit) External Data connection with Access Bill Carlson Excel Discussion (Misc queries) 0 June 2nd 11 12:10 AM
Excel 2010 not opening in maximized view racee Excel Discussion (Misc queries) 1 May 28th 10 05:39 PM
Opening an Excel Spreadsheet from Access with VBA Brad[_23_] Excel Programming 9 August 11th 06 08:31 AM
Opening linked spreadsheet file in Access Art Excel Programming 4 July 1st 05 06:15 PM


All times are GMT +1. The time now is 12:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"