No announcements
Found 2454996 threads
-
0 VotesCan Excel 2007 read SQLexpress data by connection SQL command tied to Excel cells without VBA?
replace the 1 in the EXECUTE command on the left with the data in one or more cells in Excel. This would allow the reports to generate from ...Unanswered | 2 Replies | 6184 Views | Created by Douglas - Listener - Wednesday, May 11, 2011 1:36 PM | Last reply by Douglas - Listener - Wednesday, June 15, 2011 6:51 PM
-
1 Votes
Can Excel 2007 read SQLexpress data by connection SQL command tied to Excel cells without VBA?
Background: I have Excel 2007 and SQLexpress on my 64 bit Windows 7 laptop to analyze data from a third party program. The third party program used ...Answered | 2 Replies | 7481 Views | Created by Douglas - Listener - Tuesday, May 10, 2011 3:54 PM | Last reply by Douglas - Listener - Wednesday, May 11, 2011 1:43 PM -
0 Votes
Excel 2007 highlights multiple cells
Excel 2007 highlights multiple cells at random. I have googled and cant seem to find the answer anywhere. How can I fix this issue? This occurs on all ... -
0 Votes
Click dropdown list in Excel cells - vba
I use Excel "Data Validation" to create some dropdown lists in cells. When need to select an item in the list, I have to click in ...Answered | 1 Replies | 3258 Views | Created by Ian3 - Wednesday, February 18, 2015 3:34 AM | Last reply by Jan Karel Pieterse [MVP] - Wednesday, February 18, 2015 5:24 AM -
0 Votes
Excel 2007 VBA??
Hi Folks, On one of my computers when I open Excel 2007 VBA is not accessible? This machine is running Windows 7 and has both Office ...Answered | 1 Replies | 3193 Views | Created by SDevenshire - Friday, February 1, 2013 5:44 AM | Last reply by VBATools - Friday, February 1, 2013 11:48 PM -
0 Votes
Excel 2007 Pivot Tables VBA
looking at ways to move my data from Access to Excel for creating pivot tables purposes. I have a routine that takes data from an Access query ... -
0 Votes
connection to Excel 2007
I INSTALLED sql 2008 EXPRESS ADVANCED on my laptop so I could use the data mining functions in Excel 2007. I cannot conect to sql and get a ... -
1 Votes
Excel to SQL via VBA
; 'SELECT * from [testdata]'); to import from Excel 2003 as well as Excel 2007+ both, what command could help me ...Answered | 2 Replies | 2106 Views | Created by FARAZ A QURESHI - Monday, March 9, 2015 5:39 PM | Last reply by Eric__Zhang - Tuesday, March 10, 2015 7:55 AM -
0 Votes
SP 2010 list fields to Excel cells using VBA?
Hi clueless2013, In client, you can use web service to talk to SharePoint, like use List web service to get SharePoint list item data, ...Answered | 1 Replies | 889 Views | Created by clueless2013 - Monday, February 10, 2014 8:13 PM | Last reply by Qiao Wei - Tuesday, February 25, 2014 10:38 AM -
0 Votes
Read Excel Worksheet cells value programmatically c#
Hi sir, I want read Excel Sheet cells value And bind it with visual webpart in sharepoint 2013. and also ...Unanswered | 1 Replies | 1245 Views | Created by vijay Diametriks - Tuesday, September 30, 2014 7:32 AM | Last reply by T_Ray - Tuesday, September 30, 2014 9:14 AM -
0 Votes
Excel VBA
Hi all, Is there anyway that i can create a table automatically in shapoint excel sheet after i updated the data on a excel sheet which i saved ...Proposed | 1 Replies | 505 Views | Created by HESH_N - Friday, April 21, 2017 2:51 AM | Last reply by Ethan Hua - Monday, April 24, 2017 8:15 AM -
0 Votes
Merged cells in Excel 2007
The document is automaticly created from some macros, and it's lenght can change. Depending on the lenght of the document, a merge cell is sometime printed on 2 different pages. What could I ... -
0 Votes
SQL query in excel vba
://support.microsoft.com/kb/2817425Based I suggest you use PowerPivot or Power Query to get your result. And if you want to know how to use ...Answered | 1 Replies | 903 Views | Created by lukasz_r128 - Tuesday, December 1, 2015 2:25 PM | Last reply by Emi Zhang - Wednesday, December 2, 2015 7:38 AM -
0 Votes
Is Excel SQL connection read only?
Hi, I have setup a Data connection to SQL in Excel using authenticated user's account. Currently users has right to ...Proposed | 2 Replies | 1326 Views | Created by wkpli - Friday, September 15, 2017 2:03 PM | Last reply by Emi Zhang - Tuesday, September 19, 2017 9:27 AM -
0 Votes
Excel 2007 - Filtering data from SQL query
Excel 2007, when retrieving data frm 'existing connection' in this instance SQL, the window only allows one to dump the ... -
0 Votes
Excel to SQL connection
Hi, Is there a way to extract/import the output of a query made in SSMS (MS SQL Management Studio) into excel using ...Answered | 5 Replies | 1075 Views | Created by Pat C1 - Friday, August 22, 2014 9:01 PM | Last reply by Pat C1 - Tuesday, September 2, 2014 4:52 PM -
0 Votes
Excel VBA Macros - Hide/UnHide Cells
is developed by Microsoft Support teams. Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office programs.Unanswered | 4 Replies | 1869 Views | Created by ALS91 - Monday, August 11, 2014 3:21 AM | Last reply by Greta Ge - Thursday, August 21, 2014 5:31 AM -
0 Votes
Excel Data Connection Refresh
I have an Excel sheet with several sheets, each sheet is connected to a SharePoint list using the "Export as Data Feed" from the List library. I accomplished this ...Answered | 2 Replies | 1152 Views | Created by Erwabo - Thursday, November 5, 2015 3:27 PM | Last reply by Erwabo - Friday, November 6, 2015 12:30 PM -
0 Votes
Excel 2007 Database Connection
Hi All I am having a few issues linking queries from Access into Excel 2007 Once i have setup the connection only 6 of a total 18 ... -
0 Votes
VBA Excel 2007
Hi, I would like to learn Visual Basic in Excel 2007. Can you please suggest video tutorials and or classes that I can take? In terms of ...Answered | 1 Replies | 12840 Views | Created by DGalperin - Thursday, January 27, 2011 12:35 AM | Last reply by Naushad Hasan - Friday, April 1, 2011 8:48 PM - Items 1 to 20 of 2454996 Next ›
No announcements
