Hi,
I would like to use CopyFromRecordset Excel method to export data to Excel by avoiding looping through the records.
I have SqlDataReader populated with data.
Would it be possible to implement?
Many thanks
vladk
Hi everyone,
How it would be possible to fix the exception in this procedure? Any help will be appreciated. Thank you!
Public Sub LoadEmailAddress()
Dim strRecipient As String
Dim dicRecipients As New Dictionary(Of String, String)
Dim dicCopyGroups As New...
Hi,
I am not sure if this is right forum to ask since I am not a javascript developer.
Can anybody please help me to find example of the link in the web form, which would start a desktop application.
The catch is that the desktop application accepts command line arguments, and the arguments...
Hi,
I am not sure to center this table:
<fo:table text-align="center" border-color="black" border-width="0.25px" border-style="solid" margin="0.1in" table-layout="auto">
<fo:table-column column-width="12pt" />
...
<fo:table-body>
<fo:table-row>
<fo:table-cell...
Hi,
Can anybody help me with "IN" clause parameters in a stored query?
My insert qryMyAmts query contains such a clause:
WHERE MY_AMTKEY IN ('1','2','3')
It runs fine.
I want to call it from VBA in Access and I changed the clause to
WHERE MY_AMTKEY IN ([MyAdmKeyList])
My VBA code is like...
Hi guys,
I built VB.NET (VS 2012) application that works with Excel. Compiled exe and saved it on shared network drive. Works fine if I just locate the file and start it in Windows Explorer. Throws the exception (InteropServices, method not found) in Citrix.
Found it happens when code deals...
Hi,
I built simple Windows Forms VB.NET application. It reads text files (like for Notepad) and creates another text files. At the end, it displayes a conformation message. The program works just fine from VS2012. Howevere when I run it's executable from bin/release (I built it for release)...
Hi,
I am trying to build join query on Bank_Fees, Unit_Lookup, and Fee_Lookup tables:
Bank_Fees
Invoice_Mnth Invoice_Yr Unit_Name Fee_Type Amt
1 2013 Unit-1 A 12
1 2013 Unit-1 A 18
1 2013 Unit-1 B 13
1 2013 Unit-1 B 15
1 2013 Unit-2 A 10
1 2013 Unit-2 B 11
2 2013 Unit-3 A 5
2 2013 Unit-3 A...
Hello everyone
This code breaks on line 1 with that error
Private Sub HideExtrapolatingLines(ByRef ioobjWsht As Worksheet)
Const METHOD_NAME As String = "HideExtrapolatingLines"
On Error GoTo MethodExit
1 ioobjWsht.Rows("307:310").EntireRow.Hidden = True
2...
Hi,
Is it possible to create a workbook with a pivot table, which is connected to a large, say ACCESS, table (may be 400MB), and still have a very light book? And if its possible, how it can be implemented?
Thank you
vladk
Can somebody help me with update query?
I have two tables: T and S. Both tables have fields F1,F2,F3,F4. These fields identify common records on the tables. Table S has [Calendar Year] and [Calendar Month]fields. Also, for each (F1,F2,F3,F4) record, table S has some numeric parameter in field...
I need to copy content of, say, Module1 in Excel Book1 to Module2 in Book2. And before I need to delete Module2, then create it and assign it a name.
And also, copy not just a content, but entire Module1, but first delete Module2 in Book2, then copy Module1 from Book1, and then rename Module2...
Hi,
When I try to retrieve column names from the ACCESS table using ADOX, I get them in the alphabetical order.
And I need them in the order they are defined in the table.
Can anybody help me with this?
Thank you!
The error is "Operation is not allowed when the object is closed.
This error occures ONLY when I run code right after I opened my VB6 project. The code runs just fine when I repeat runs during the same session.... I have no clue...
This is the code:
Dim objRcrdstFromExcel As New...
Hi,
I try to do the following one, using VBA:
1. Insert object (select Bitmap Image) into Powerpoint slide
2. Copy range in Excel workbook.
3. Paste this range INTO the bitmap image object in PowerPoint.
So far, I was able to add an empty image to a slide and activate it to prepare for...
Hi,
If I use a composite index, say Field1, Field2, Field3, the order in which these fields are listed in WHERE clause will be important? And if yes, then how should I list them: from top to bottom or from bottom to top?
This is ACCESS database.
Thank you!
vladk
I run this code:
Dim objWbk As Workbook
Dim objExcel As New Excel.Application
Set objWbk = objExcel.Workbooks.Open("C:\Projects\2008 RateBase\PageMaker2008\RataBaseTemplates\AL\176_AL_PREM_LIMIT_FCTR.xls")
The workbook exists, I hardcoded it. The location exists also, it's on...
Hi,
I have some VBA code inside Excel.
This is the piece of code that does work on the network, but not on the sharepoint:
Set ioobjConn = New ADODB.Connection
Set ioobjCmnd = New ADODB.Command
Dim strCnctn As String
strCnctn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.