No announcements
Found 2206385 threads
-
0 VotesGet only filename from entire path
DECLARE @st VARCHAR(100)='/FILE "\"L:\Packages\ABCDEFG.dtsx\"" /CHECKPOINTING OFF /REPORTING E' ---I need to get only ...Answered | 3 Replies | 445 Views | Created by Sai Prabhu - Thursday, September 15, 2016 10:45 AM | Last reply by Sai Prabhu - Thursday, September 15, 2016 12:06 PM
-
0 Votes
Date format problem Listobject Query table
Thanks for looking into this. I think I found a workaround. I have added autoFilter to query table to make it more like a listobject query ...Answered | 5 Replies | 1651 Views | Created by Arun123321 - Monday, December 21, 2015 2:27 PM | Last reply by Starian chen - Wednesday, December 30, 2015 1:14 AM -
0 Votes
get filename dynamically
From my observations, you don't have to delete the connectionstring. The system will pick up the expression value and use it even if there is a hardcoded valueAnswered | 1 Replies | 4682 Views | Created by arkiboys - Thursday, July 26, 2007 11:00 AM | Last reply by Eric Wisdahl - Thursday, July 26, 2007 12:06 PM -
0 Votes
Best way to keep parameters associated with Listobject query table?
I could somehow link to the table name, but that can be changed... Any ideas? Not sure if this will help or not but maybe a little ...Answered | 1 Replies | 409 Views | Created by jjjtttggg - Friday, February 27, 2015 3:49 AM | Last reply by OssieMac - Friday, February 27, 2015 6:42 AM -
0 Votes
Get Excel Filename into database.
I am reading the data from Excel into SQL Database. I want to get the excel filename also...Please help me.Answered | 2 Replies | 1886 Views | Created by kdinuk - Wednesday, July 4, 2012 1:55 PM | Last reply by irusul - Wednesday, July 4, 2012 2:10 PM -
0 Votes
ListObject binding Help
you can use an interface interface ISheet { ListObject MyListObject { ...Answered | 2 Replies | 4494 Views | Created by Simi Sreedharan - Friday, August 25, 2006 4:32 PM | Last reply by Simi Sreedharan - Monday, August 28, 2006 11:31 AM -
0 Votes
How to get filename from resource ID?
, HMODULE hInst) Forget the filename. The way to obtain the image from a ...Answered | 6 Replies | 907 Views | Created by Yan Yang - Tuesday, August 14, 2018 4:19 PM | Last reply by Darran Rowe - Tuesday, August 14, 2018 6:30 PM -
1 Votes
Get Worksheet Name from a closed Workbook
hi guys, is there a way to get worksheet names from a closed workbook using vb.net. a piece of code to start with using vb.net is greatly ...Answered | 5 Replies | 4323 Views | Created by cguan - Monday, November 7, 2011 3:36 AM | Last reply by cguan - Friday, November 11, 2011 9:25 AM -
4 Votes
ListObject (Table) - VBA to Delete multiple rows
The answer from Juliusz is best and fastest I guess. However I would enclose it into an error handler because if the table is already ...Answered | 11 Replies | 74553 Views | Created by Syswizard - Monday, August 13, 2012 5:19 PM | Last reply by Topgun13 - Tuesday, November 17, 2020 3:26 PM -
1 Votes
How to get the name of the currently selected table "ListObject"?
Hi Folks, I have worksheets with multiple Tables. How do I get the name of the currently selected Table (ListObject) via ...Answered | 1 Replies | 1230 Views | Created by Shane Devenshire - Tuesday, June 25, 2013 9:29 PM | Last reply by Peter Thornton (Excel MVP 2008-13) - Tuesday, June 25, 2013 11:03 PM -
0 Votes
ListObject binding
what kind of collection you want to use? view this, from msdn (data source for listobject): The following data sources are valid: AAnswered | 6 Replies | 4818 Views | Created by ssouki - Tuesday, September 19, 2006 6:51 AM | Last reply by ssouki - Tuesday, September 19, 2006 9:12 AM -
0 Votes
ListObject binding
Thank you for trying to help. As a start the listobject is bound to a collection not a datatale.Answered | 3 Replies | 3660 Views | Created by ssouki - Tuesday, December 5, 2006 11:55 AM | Last reply by Nikhil Khandelwal - MSFT - Tuesday, January 9, 2007 4:35 AM -
0 Votes
FileName from SpreadsheetDocument
add annotations to any part. One idea – immediately after opening, add the filename as an annotation on the spreadsheet workbook part. You can then check the ...Answered | 2 Replies | 5149 Views | Created by JenniferStites - Friday, October 23, 2009 3:36 PM | Last reply by JenniferStites - Thursday, October 29, 2009 3:13 PM -
1 Votes
Get Workbook close event...
are probably cases where a workbook can be closed when it is not active (for certain, a macro could do this) so you would never get the deactivate event. ...Answered | 6 Replies | 8939 Views | Created by koraykazgan - Thursday, August 27, 2009 11:03 PM | Last reply by Geoff Darst - MSFT - Friday, September 4, 2009 3:31 PM -
3 Votes
Get filename HttpWebRequest
I can't figure out how you managed to get the file name from the Headers of HttpWebResponse. It's a bunch of Keys, I can't get the filename ...Answered | 13 Replies | 34036 Views | Created by JobaDiniz - Friday, July 23, 2010 12:35 AM | Last reply by JohnJames55 - Thursday, April 30, 2015 10:37 AM -
0 Votes
Get Application Config FileName
.vshost.exe.Config" for example. But i think when i run the ConsoleApplication not from Visual Studio i will get the right ...Answered | 2 Replies | 2955 Views | Created by martin.doku - Thursday, November 12, 2009 2:59 PM | Last reply by martin.doku - Thursday, November 12, 2009 4:01 PM -
0 Votes
Get same filename from another folder
;nbsp;file from folder? let say: folder1 contains text1.txt, text2.txt folder2 contains text1.txt, text2.txt, ...Answered | 9 Replies | 3941 Views | Created by kokloong - Friday, June 3, 2011 2:19 AM | Last reply by kokloong - Sunday, June 5, 2011 9:33 AM -
0 Votes
ForEach Cont. Get FileName,CurrentFolder
Sql 2008 R2 Get the filename from a full file path: RIGHT( @[User::FileName], FINDSTRING( REVERSE( ...Answered | 10 Replies | 754 Views | Created by Pokemon_RIZA - Wednesday, May 27, 2015 7:54 AM | Last reply by Pokemon_RIZA - Wednesday, May 27, 2015 9:31 AM -
0 Votes
get attachment filename
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean) If Item.Attachments.Count > 0 ...Answered | 2 Replies | 5595 Views | Created by JS3 - Thursday, January 10, 2008 3:47 PM | Last reply by JS3 - Thursday, January 10, 2008 4:23 PM -
0 Votes
excelsheet without listobject
Hi, Actually as per my requirement I want to generate columns separately and fill data below that column separately. And this will not be possible with ...Answered | 3 Replies | 4067 Views | Created by Prashant_Rai - Friday, April 21, 2006 12:01 PM | Last reply by Darryn Lavery -- MSFT - Tuesday, April 25, 2006 5:10 PM
No announcements
