Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I am trying to dynamically create a web query in an excel workbook project and am getting an error whenever I try to use a connection of type URL; Microsoft.Office.Interop.Excel.Range range = worksheet.get_Range("A1", "A1"); Microsoft.Office.Interop.Excel.QueryTable qTable = worksheet.QueryTables.Add(@"URL;http://localhost/SampleReport", range, null); qTable.Name = "Test Report"; I am used C# code and this works fine from a embedded VBA module. Why not from a .NET managed excel workbook? Any ideas? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() ps. I am getting an ArgumentException with a description of "The parameter is incorrect" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
R/T error 5 - invalid procedure or argument | Excel Programming | |||
ComboBox List - Invalid Argument???? | Excel Programming | |||
Not working... Why? ActiveSheet.QueryTables.Add(Connection:=ActiveCell.Offset(0, | Excel Programming | |||
QueryTables.Add Connection Parameter | Excel Programming | |||
help with ActiveSheet.QueryTables.Add Connection: | Excel Programming |