No announcements
Found 274836 threads
-
0 Votes
VBA for pasting from clipboard (from Excel, to Excel)
What I need the code to do is take data that has been copied from another workbook all together, and paste all but that first row in the current ...Answered | 8 Replies | 6436 Views | Created by R.Shaw - Tuesday, June 26, 2012 7:31 PM | Last reply by R.Shaw - Saturday, June 30, 2012 10:00 PM -
4 Votes
Data connection ODC file and Excel Reports Templates
I open ODC from Server (read-only), paste my new query in there, get the same first message as you and confirmed.Answered | 8 Replies | 14744 Views | Created by WLID1966 - Saturday, April 9, 2011 11:27 AM | Last reply by WLID1966 - Sunday, April 10, 2011 1:24 PM -
4 Votes
script to list down values from an excel sheet and asks the user to select the values
Hi, I need to write a script that lists down values present in an excel sheet.The user need to select one or more values that are listed in the UI.Please ...Answered | 6 Replies | 5622 Views | Created by intern417 - Thursday, February 9, 2012 7:09 AM | Last reply by intern417 - Friday, February 10, 2012 5:13 AM -
3 Votes
Exporting Advanced Find results
If so, you can create a new Workbook, and use the Sheet Move or Copy command (right click on the sheet) and select ...Answered | 4 Replies | 2994 Views | Created by boo oinky - Friday, March 16, 2012 8:06 AM | Last reply by Scott Durow (MVP) - Friday, March 16, 2012 10:15 AM -
0 Votes
Import project level data only from excel into Project Server 2010
The data is only Project level, and I agree it would just be as fast to manually create each Project.Answered | 4 Replies | 1562 Views | Created by Miller_JR - Wednesday, December 3, 2014 2:58 PM | Last reply by Miller_JR - Wednesday, December 3, 2014 4:19 PM -
2 Votes
PowerShell Script to "load" a new Data Model Module?
Just a couple of follow-up questions: 1) I can delete a custom data model that was added using the powershell scripts, but would like to ...Answered | 7 Replies | 4630 Views | Created by Gump - Wednesday, February 8, 2012 4:46 PM | Last reply by Kalnemi - Wednesday, February 15, 2012 2:05 PM -
0 Votes
Removing 1st row in Excel using PowerShell
Works as expected for me, Excel 2016.Answered | 2 Replies | 4563 Views | Created by Tshindaye - Friday, November 18, 2016 8:41 PM | Last reply by Danny van Dam - Thursday, December 22, 2016 12:05 PM -
0 Votes
Power shell scripting | Schedule job | Excel VBA
Just create a task that seelcts to run only when the user account is logged in.Answered | 4 Replies | 1656 Views | Created by SrinivasChaitanya - Sunday, December 14, 2014 7:15 PM | Last reply by jrv - Sunday, December 14, 2014 8:08 PM -
0 Votes
Issue facing when excel 2003 sheet is open in excel 2007
So Excel isn't supported here.Answered | 1 Replies | 7866 Views | Created by Neeraj Dixit - Wednesday, November 2, 2011 11:04 AM | Last reply by Ed Price - MSFT - Wednesday, November 2, 2011 8:19 PM -
2 Votes
Creating a new Excel Instance for every project created in project server
See the steps to create a custom workspace template ...Answered | 3 Replies | 7795 Views | Created by Runngun - Wednesday, June 22, 2011 7:16 PM | Last reply by Andrei Chifu - Thursday, June 23, 2011 11:55 PM -
1 Votes
Excel addition across worksheets with exclusion of a row based on string
Since this forum is to discuss issues about Excel developement.In my opinion, it is an issue regarding to excel formula .Answered | 2 Replies | 1043 Views | Created by Kd01 - Wednesday, January 1, 2014 3:09 AM | Last reply by Marvin_Guo - Wednesday, January 8, 2014 8:01 AM -
2 Votes
Export Data to Excel in C# Plugin
http://social.msdn.microsoft.com/Forums/vstudio/en-US/ea02f8e8-edf5-4aca-8c74-ef3a94b5328d/export-dataset-into-excel-sheet-in-c?Answered | 2 Replies | 5580 Views | Created by kMAT1 - Wednesday, November 6, 2013 10:55 AM | Last reply by KashifZeeshan - Wednesday, November 6, 2013 11:36 AM -
0 Votes
Not able to read special characters from an excel sheet
Hi, I am using Oledb connection string to read data in dataSet from a .xls file but finding a very strange behavior.Answered | 1 Replies | 9114 Views | Created by priyanka_ag - Monday, June 15, 2009 7:11 AM | Last reply by ashawani_dubey - Thursday, June 18, 2009 1:54 PM -
0 Votes
Exported to Excel - Data disappears
Hi, I recommend you to after making changes into the file, Save File As Excel Workbook (*.xlsx) and then send this file via email.Answered | 1 Replies | 3528 Views | Created by DavidtMoore - Friday, July 22, 2011 1:54 PM | Last reply by Jehanzeb.Javeed - Friday, July 22, 2011 2:41 PM -
1 Votes
How to Filter Web Content When Export Gridview Data to Excel File
I need to export Gridview data to excel file and achieved the export function using attached code,everything is ok but the content of the excel file to ...Answered | 1 Replies | 1504 Views | Created by 怒放的生命 - Friday, July 18, 2014 6:19 AM | Last reply by Cor Ligthert - Friday, July 18, 2014 7:29 AM -
1 Votes
Sure Step Excel WBS sheet prefix
I'd ask in the Excel community on Microsoft Community forums.Answered | 1 Replies | 1891 Views | Created by Göran Barchan - Friday, October 18, 2013 1:54 PM | Last reply by Just Karl - Friday, October 18, 2013 2:40 PM -
0 Votes
Creating different filters for different clients
If SQL Express can you please prive ne with some code-block as I am also trying to do the same...Answered | 6 Replies | 14686 Views | Created by Archan Mukherjee - Thursday, July 9, 2009 9:48 AM | Last reply by Archan Mukherjee - Friday, October 9, 2009 10:34 AM -
0 Votes
Filter database server data
Eric, When you provision your table(s) within a scope, you specify a filter and filter key.Answered | 7 Replies | 9770 Views | Created by EricDelahaye - Tuesday, August 11, 2009 12:20 PM | Last reply by EricDelahaye - Thursday, August 27, 2009 6:59 PM -
2 Votes
Create 128 Barcodes within Excel
I got the fonts from ID automation Interestingly their VBA scripts only seem to work with their own font.Answered | 2 Replies | 1037 Views | Created by techelite1337 - Sunday, December 7, 2014 3:35 AM | Last reply by Rich Michaels, Word MVP - Sunday, December 7, 2014 11:57 PM -
5 Votes
Project GUIDs changed in Excel 2013 PowerPivot datamodel?
While we're at it: Don't use Excel 2016 for data refresh, it can/will drop decimal separators.Answered | 13 Replies | 3176 Views | Created by Erik van Hurck - Tuesday, January 14, 2014 3:51 PM | Last reply by Adrian Sauerbrey - Friday, February 5, 2016 3:02 PM
No announcements