No announcements
Found 230495 threads
-
1 VotesImporting a excel 2007 binary (.xlsb) to a table in Access 2010
How to import Binary excel file (.xlsb) into MS Access.Answered | 9 Replies | 20890 Views | Created by Kevin T_Oberon - Wednesday, February 9, 2011 10:53 PM | Last reply by AjaySingh86 - Tuesday, January 24, 2017 6:14 PM
-
0 Votes
ADODB.Connection "Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb) Opens Workbook read-only in separate workbook
hmmmm....check this out...there are known issues with the excel driver and multiple instances i might have to move to moving the database either to another ...Answered | 3 Replies | 15210 Views | Created by ahermens - Thursday, February 14, 2013 10:39 AM | Last reply by ahermens - Thursday, February 14, 2013 2:14 PM -
4 Votes
Excel Binary Workbook .xlsb
Recent versions of Excel use a pretty strong encryption algorithm for password-protected workbooks, so unless you use a very simple password it won't be easy to break the encryption ...Answered | 5 Replies | 47712 Views | Created by Gazza101 - Friday, May 4, 2012 2:02 PM | Last reply by Hans Vogelaar MVP - Monday, March 16, 2015 8:42 PM -
0 Votes
VSTO to save a file as xlsb
The Excel.XlFileFormat.Excel12 enumeration member corresponds to the .xlsb format.Answered | 2 Replies | 7569 Views | Created by manish Mahajan - Sunday, June 14, 2009 7:02 PM | Last reply by manish Mahajan - Monday, June 15, 2009 3:18 AM -
0 Votes
Does the current SSRS version supports the xlsb excel file extension?
Hi zoldyk15, In Reporting Services 2012, it doesn’t support .xlsb render.Answered | 2 Replies | 2063 Views | Created by zoldyk15 - Thursday, April 16, 2015 8:34 AM | Last reply by Qiuyun Yu - Friday, April 17, 2015 3:02 AM -
1 Votes
Access VBA DoCmd.TransferSpreadsheet seems to only output an Excel Binary Worksheet
Tried this suggestion using Access 2013 and Excel 2013 and still wound up with an xlsb file.Answered | 5 Replies | 20100 Views | Created by kqke - Thursday, August 22, 2013 3:46 PM | Last reply by Hans Vogelaar MVP - Tuesday, October 27, 2015 4:25 AM -
0 Votes
Loading .xlsb file
Then go to properties and edit the path to change to your xslb ...Answered | 2 Replies | 2824 Views | Created by on7june - Wednesday, August 5, 2015 4:46 AM | Last reply by COZYROC - Wednesday, August 5, 2015 8:22 PM -
2 Votes
"Excel Services was unable to load the workbook that you requested"
-i had this problem before... you can try saving in .xlsb format; this took care of the issue for meAnswered | 6 Replies | 26855 Views | Created by IshaVB - Tuesday, October 7, 2008 12:44 PM | Last reply by Matt_Man_87 - Monday, August 27, 2012 6:32 PM -
2 Votes
Workaround for Excel 2010 workbooks getting corrupted when macro with arguments assigned to shape
*** This same issue is present in Excel 2007 as well (tested on different PC) and thus, it seems, from the time MS switched to the new .xlsb format.Answered | 11 Replies | 5544 Views | Created by 1ToExcel - Monday, August 5, 2013 5:40 AM | Last reply by oulenz - Wednesday, November 19, 2014 4:35 PM -
0 Votes
Open new Excel workbook
You can't just make a workbook Visiable/Invisible, but you can make the entire excel application Visible/Invisible (which also makes the workbook visible/Invisible).Answered | 4 Replies | 4802 Views | Created by ams16 - Wednesday, March 28, 2012 12:20 PM | Last reply by Joel Engineer - Tuesday, April 3, 2012 8:54 AM -
1 Votes
Combine Excel workbook into one workbook
What I want is that, it should merge the data of all the 50 excel files with 7 worksheets in one consolidated workbook but 7 different worksheets.Answered | 8 Replies | 1467 Views | Created by Namit13 - Sunday, June 21, 2015 6:10 PM | Last reply by RichLocus - Tuesday, June 23, 2015 3:37 PM -
0 Votes
Compare two excel workbook
There are a few different ...Answered | 1 Replies | 3125 Views | Created by Mathew McKay - Monday, March 19, 2012 11:47 AM | Last reply by Rogge - Monday, March 19, 2012 8:50 PM -
0 Votes
share excel workbook 2007
Excel IT Pro Discussions forum.Answered | 2 Replies | 853 Views | Created by VassilisTr - Wednesday, August 6, 2014 9:35 AM | Last reply by Fei Xue - Thursday, August 7, 2014 2:15 AM -
0 Votes
Excel Binary Workbook vs.
I reviewed discussion thread under Excel Binary Workbook .xlsb and I have question regarding the size of spreadsheet that would be optimal to save as .xlsb ... -
2 Votes
Share workbook excel functionality
ViviSP suggested, you need to use Excel Web Apps.Answered | 3 Replies | 1190 Views | Created by PedroJA - Wednesday, April 20, 2016 10:47 AM | Last reply by Lisa Chen1226 - Tuesday, April 26, 2016 12:05 PM -
0 Votes
Excel workbook won't open as .xslx format in Excel Web Access Web Part
I saved it in Excel and then loaded it into the site.Answered | 4 Replies | 11343 Views | Created by rstorm1 - Friday, November 2, 2012 7:43 PM | Last reply by mydata77 - Wednesday, November 7, 2012 12:29 AM -
11 Votes
Is it possible to update linked data in a "second" Excel workbook from a "primary" Excel Workbook, without opening it?
Thanks Jim I was not aware about the limitations in shared Excel workbooks.Answered | 22 Replies | 847 Views | Created by ForssPeterNova - Saturday, December 10, 2016 4:20 PM | Last reply by MainSleuth - Tuesday, December 13, 2016 9:10 PM -
1 Votes
Problem to open Excel file with ‘.xlsb’ or ‘xlsx’ extension using C#.NET
Topic: Connection strings for Excel 2007 Link: http://www.connectionstrings.com/excel-2007 Sid (A good ...Answered | 2 Replies | 8258 Views | Created by WantToBe_JediOfIT - Wednesday, August 31, 2011 4:25 PM | Last reply by Liliane Teng - Tuesday, September 6, 2011 9:12 AM -
0 Votes
Incorporate an Excel workbook in a VSTO Excel Add-In
where as Addin work on Application level so that your customization can work for any workbook that you open in Excel.Answered | 3 Replies | 1138 Views | Created by ColinBurrows - Thursday, July 14, 2016 9:55 PM | Last reply by Deepak Saradkumar Panchal - Saturday, July 16, 2016 1:55 AM -
0 Votes
Excel Workbook + Convert To Number - AFTER exporting to Excel,
Yep, I agree with James, one of the many reasons I stopped outputting to Excel was because the connectors are so flakey, I ended up creating a macro which I had to run after every output, ...Answered | 3 Replies | 4097 Views | Created by I.W Coetzer - Monday, July 12, 2010 6:46 AM | Last reply by StraNGeLaD - Monday, July 12, 2010 10:18 AM - Items 1 to 20 of 230495 Next ›
No announcements
