No announcements
Found 3639966 threads
-
1 VotesHow to update used range dynamically in excel sheet?
http://www.thespreadsheetguru.com/blog/2014/7/7/5-different-ways-to-find-the-last-row-or-last-column-using-vba Knowledge is the only thing that ...Answered | 3 Replies | 940 Views | Created by Animesh.Dash - Thursday, September 24, 2015 9:00 AM | Last reply by ryguy72 - Sunday, October 11, 2015 1:25 PM
-
0 Votes
VBA code for SQL query between two sheets
SQL in Excel = ADO To operate on Excel data using SQL syntax, use ADO (ActiveX Data Objects).Answered | 3 Replies | 9007 Views | Created by GuyZommer - Thursday, October 13, 2011 4:17 PM | Last reply by mogulman52 - Friday, October 14, 2011 2:05 PM -
2 Votes
Reading 500 columns in Excel sheet using SSIS
Hi, I have to transform 500 columns from an excel sheet to Sql Server.Answered | 9 Replies | 14029 Views | Created by Raj-hotmail - Wednesday, November 17, 2010 10:53 AM | Last reply by Pramadwara - Monday, June 22, 2015 12:10 PM -
0 Votes
comparing column headers using excel vba
Hi, This is the forum to discuss questions and feedback for Microsoft Excel, I'll move your question to the MSDN forum for ExcelAnswered | 2 Replies | 971 Views | Created by mrmsexcel - Monday, November 24, 2014 1:41 PM | Last reply by Starian chen - Wednesday, November 26, 2014 9:16 AM -
0 Votes
How to paste a row from one sheet onto the next available row in a second sheet in excel using VBA?
I am assuming that you are using a version of Excel from 2007 or later.Answered | 2 Replies | 628 Views | Created by jsb348 - Monday, December 7, 2015 5:31 AM | Last reply by jsb348 - Tuesday, December 8, 2015 2:55 AM -
0 Votes
link or update large excel sheets
This is an Excel file created by Oracle via the program Discoverer, and contains one tab [Sheet 1] with 14K rows and 32 ...Answered | 5 Replies | 1332 Views | Created by Mark Matzke - Thursday, November 6, 2014 1:03 PM | Last reply by Cliff Anderson - Wednesday, June 22, 2016 4:01 PM -
1 Votes
Is there a safer alternative to writing Connection Information in VBA in an Excel Sheet?
If you deploy the project using click-once, then you'd also have control of pushing updates to everyone.Answered | 3 Replies | 565 Views | Created by Leon Lai - Monday, November 19, 2018 12:48 PM | Last reply by Leon Lai - Tuesday, November 20, 2018 7:36 AM -
1 Votes
How to remove VBA from Excel 2010 sheet
VBA Projects cannot be saved in xlsx format so all macros will be lost.Answered | 2 Replies | 8653 Views | Created by Josje - Thursday, May 24, 2012 7:09 AM | Last reply by Josje - Monday, May 28, 2012 4:18 PM -
0 Votes
How to select entire column in Excel by custom column header using VBA.
Hello Sakti, The most easiest way is to try using the Excel Macro Recorder.Answered | 2 Replies | 2445 Views | Created by Sakti Sahoo - Monday, June 1, 2015 7:34 PM | Last reply by Cimjet - Tuesday, June 2, 2015 1:16 AM -
1 Votes
Add data to particular columns in Excel Sheet?
For example, the following site: http://forums.autodesk.com/ Also, you may be interested in some stuff for VBA programming in ...Answered | 4 Replies | 1742 Views | Created by ADeeven - Friday, November 16, 2012 5:25 AM | Last reply by Dummy yoyo - Thursday, November 22, 2012 3:04 AM -
0 Votes
Updating SQL Records in Excel
Hi Stanton, For this requirement, I suggest that you could capture data change by using Worksheet.Change event, then get the ...Answered | 3 Replies | 656 Views | Created by Stanton Daries II - Thursday, December 31, 2015 3:05 PM | Last reply by Starian chen - Monday, January 4, 2016 2:10 AM -
0 Votes
Excel Sheet Update Using Shell
(Excel)Output file: Column_3 Column_4 Column_5 Column_6 Column_7 ...Answered | 2 Replies | 1439 Views | Created by Rishabh_Jain28 - Monday, December 10, 2018 8:44 AM | Last reply by - Monday, December 10, 2018 10:28 AM -
4 Votes
SQL Codes in VBA for Excel
I’m afraid that your topic about VBA is unsuitable here.Answered | 6 Replies | 6945 Views | Created by Michael Andrew Lee - Friday, January 6, 2012 5:19 AM | Last reply by danishani - Friday, January 27, 2012 10:19 PM -
0 Votes
Insert selected column from multiple excel sheet ????
Dear Sir, I have idea of loading al the diffrent excel shee in diffrent table using foreach loop will explain or post me steps or any link where ...Answered | 8 Replies | 3038 Views | Created by Vipin jha - Thursday, July 5, 2012 8:48 AM | Last reply by Vipin jha - Friday, July 6, 2012 5:17 AM -
0 Votes
Write Query to update records from excel sheet
Hi Muhammad Based on my understanding, you want to update the table Department with the data in an excel sheet, right?Answered | 6 Replies | 1398 Views | Created by MM from AUS - Monday, November 10, 2014 3:23 AM | Last reply by Visakh16 - Monday, December 8, 2014 6:48 AM -
0 Votes
Excel VBA, Excel Sheet and Access table
Johnseito, please visit the link below will give you an example of import/export data from Excel to Access and Access to Excel using ...Answered | 1 Replies | 916 Views | Created by Johnseito - Sunday, July 10, 2016 2:25 PM | Last reply by Deepak Saradkumar Panchal - Monday, July 11, 2016 5:33 AM -
0 Votes
Excel formula/vba to search across multiple sheets?
Hi Sephiroth0327, You can use the Range.Find method inside a loop through all sheets using a For Next Loop.Answered | 1 Replies | 1172 Views | Created by Sephiroth0327 - Tuesday, August 11, 2015 8:52 PM | Last reply by ProcessIT - Tuesday, August 11, 2015 10:27 PM -
1 Votes
VBA code to recalculate values in Excel sheet
Hi GytasS, Here is a sample to caculate the data in the worksheet from A1: Sub calc() Dim targetSheet As Worksheet Set targetSheet = ...Answered | 3 Replies | 1722 Views | Created by GyTasS - Wednesday, December 17, 2014 8:07 AM | Last reply by Fei Xue - Friday, December 26, 2014 7:26 AM -
3 Votes
Protect Excel Columns With Powershell
In case anyone is looking for the Excel Protect parameters: Protect(Password, DrawingObjects, Contents, Scenarios, UserInterfaceOnly, ...Answered | 7 Replies | 4458 Views | Created by 4xfk3 - Wednesday, August 16, 2017 11:31 PM | Last reply by jrv - Friday, August 18, 2017 10:58 PM -
1 Votes
Excel to SQL via VBA
Hi FARAZ, Regarding your description, Your requirement is about some programing approach to export excel to SQL Server, which is out of the ...Answered | 2 Replies | 2875 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 - Items 1 to 20 of 3639966 Next ›
No announcements
