No announcements
Found 1255763 threads
-
0 VotesVBA - opening web connect file (.iqy)
I'm using vba to open a file (owssvr.iqy) with excel. This file is an export from SharePoint 2007. When excel starts up, I ...Answered | 3 Replies | 1669 Views | Created by Casey_M - Wednesday, July 22, 2015 4:16 PM | Last reply by Fei Xue - Monday, July 27, 2015 7:54 AM
-
0 Votes
Open iqy file from Sharepoint
Hi Probayes, Thanks for posting in the MSDN Forum. Would you please show you iqy file for further research? Have a good ...Unanswered | 1 Replies | 1496 Views | Created by Probayes - Thursday, January 24, 2013 8:11 AM | Last reply by 许阳(无锡) - Friday, January 25, 2013 1:48 AM -
0 Votes
IQY Help
In advance, thank you for any help you might provide. While searching MSDN, it appears that the majority of IQY questions come here, so I'll post. For various ...Unanswered | 1 Replies | 5171 Views | Created by Patrick Finnicum - Thursday, April 16, 2009 7:09 PM | Last reply by Mike Walsh FIN - Friday, April 17, 2009 5:01 AM -
0 Votes
Export into Excel \ IQY
You can construct your own .iqy file and double-click it to launch Excel and retrieve the data, but you can address one 'datasource' at a time. Excel talks to the list using a ...Answered | 1 Replies | 4486 Views | Created by e v e r n i t e - Friday, September 30, 2011 8:35 AM | Last reply by AbedKhooli - Friday, September 30, 2011 10:46 AM -
0 Votes
Sharepoint 2010 Export to Excel (IQY file)
internal site. When an external user trying to export to excel an InfoPath form, they get the Error from excel. Cannot connect to SharePoint List. If however you ...Answered | 1 Replies | 1401 Views | Created by Nsaneone - Friday, January 23, 2015 4:43 PM | Last reply by Paul stork, [MCM, MVP] - Friday, January 23, 2015 9:20 PM -
0 Votes
iqy possibilities ?
-9954-30AB4B5EC850} ExcelOperation=Chart Is there any other option we could use in the iqy file ? Is there any ...Answered | 3 Replies | 8478 Views | Created by Steve B_ - Friday, August 20, 2010 2:35 PM | Last reply by Jing Wa - MSFT - Monday, October 11, 2010 6:00 PM -
0 Votes
Webquery like iqy
Hello Is there a way to get a dataset or an sheet with the information from a iqy file. QueryTable i think is the one to use but i cant understand it. ... -
0 Votes
export to excel - edit iqy file
Hi, Tnx for the reply but this is not a solution. I don't have the column "name + firstname" So I can't add an ...Answered | 9 Replies | 21749 Views | Created by endeka - Friday, October 4, 2013 8:58 AM | Last reply by Mohammad Hawasli - Tuesday, October 20, 2015 7:04 AM -
1 Votes
Power Pivot vs Pivot Table - Microsoft Excel Web Query File (.iqy)
I can't figure out how to get a Microsoft Excel Web Query File (.iqy) into Power Pivot. All methods I have tried come up with errors? In ...Answered | 1 Replies | 3129 Views | Created by ihorwitz - Thursday, October 2, 2014 3:37 PM | Last reply by Avi Singh - PowerBIPro - Tuesday, October 7, 2014 2:43 AM -
0 Votes
How to import IQY file without "Import Data" Dialogue Box?
I've written a VBA code that gets an IQy file and save it as an .xlsx file. When I run it I get an Import Data prompt for every file and wanted to see if ...Unanswered | 1 Replies | 765 Views | Created by cheeks23 - Tuesday, August 28, 2018 7:06 PM | Last reply by mogulman52 - Wednesday, August 29, 2018 1:27 PM -
0 Votes
Project Server .iqy
Hello - I have seen this question asked the opposite way from what I am looking to do. Currently in Project Server 2013 - we can export to excel and it exports as .xlsx. Is there a way, either in ... -
1 Votes
Access (raw) response data from a web query (in my case: a SharePoint iqy file)
>>Access (raw) response data from a web query (in my case: a SharePoint iqy file) Base on my searching, I couldn't find that there is a ...Answered | 3 Replies | 561 Views | Created by P-B - Friday, September 4, 2015 12:43 PM | Last reply by Fei Xue - Tuesday, September 29, 2015 6:59 AM -
1 Votes
Intermittent opening SharePoint file from Excel VBA
Hi, You can try to use the following code to open excel file located in a SharePoint library folder using VBA: Dim SummaryWB As Workbook Dim ...Proposed | 1 Replies | 2261 Views | Created by RahlK - Monday, October 1, 2018 4:39 PM | Last reply by Jerry Zy - Tuesday, October 2, 2018 8:45 AM -
0 Votes
Using IQY files with SQL Server R2
retrieve the information directly into a Microsoft Excel worksheet. Based on the above description, .iqy file is used to retrieve data into ...Answered | 1 Replies | 5237 Views | Created by kdarres90 - Friday, June 28, 2013 12:20 PM | Last reply by Allen Li - MSFT - Sunday, June 30, 2013 2:46 AM -
0 Votes
Opening xlsm-file via VBA fails
repair the file. You only get the errors on an English version of Excel, which probably explains why opening the file using VBA causes a ...Answered | 13 Replies | 4505 Views | Created by Dirk Flakowski - Thursday, March 21, 2013 1:57 PM | Last reply by Dirk Flakowski - Thursday, March 21, 2013 3:31 PM -
0 Votes
Query files .iqy manipulation
a title ( string such as: Web-1, Web-2, etc.), at the top of the table retrieved data, to each query. If not possible at the top then at the bottom of the table ...Unanswered | 1 Replies | 395 Views | Created by ZigZagoo7 - Wednesday, March 15, 2017 10:23 AM | Last reply by croute1 - Wednesday, March 15, 2017 7:51 PM -
2 Votes
Opening a File Selection window from VBA
I am working on a vba sub-routine that will create a project file that we can send to our customers. The procedure will remove any confidenital information from the plan ...Answered | 5 Replies | 5903 Views | Created by CraigS99 - Monday, May 7, 2012 8:21 PM | Last reply by Dustin Ventin - Thursday, October 2, 2014 7:33 PM -
0 Votes
Opening af text file in VBA
file is "05MAY2006" which I want to have read as a data. I only have little experience in the mystic world of VBA and really advanced MS Office usage. I ...Answered | 1 Replies | 4421 Views | Created by epimp - Thursday, July 20, 2006 1:39 PM | Last reply by epimp - Thursday, July 20, 2006 2:08 PM -
2 Votes
Opening up another .ACCDB file in VBA
OpenDatabase only loads a database into memory for use by VBA, it does notopen the database into the Access interface. If you want to open another database, ...Proposed | 5 Replies | 3109 Views | Created by LoganAccess - Friday, June 30, 2017 6:32 PM | Last reply by Terry Xu - MSFT - Wednesday, August 2, 2017 7:03 AM -
0 Votes
SSIS Package to import from IQY
experience with personally) B) Exporting the table in a format other than IQY C) Reading the IQY data directly - is there an API for reading ...Answered | 2 Replies | 7052 Views | Created by Sami Halabi - Thursday, October 23, 2008 7:03 AM | Last reply by makeonebg - Thursday, October 23, 2008 8:07 AM - Items 1 to 20 of 1255763 Next ›
No announcements
