I am writing a vb.net app which instanciates an instance of Excel and creates a pivottable and then wishes to group the pivottable by date.
The code for this is
Dim iArr(0 To 6) As Object
iArr(0) = False
iArr(1) = False
iArr(2) = False
[code].....
Which is the list you would get if you manually performed this operation in Excel.
I'm trying to build a Pivottable on a webform in vb.net 2005 using OWC. I have added the Pivottable item to the toolbox, but it is grayed out and so I cant use it. If I develop a Winform instead of a Webform then the toolbox items are there and work correctly.
View 1 RepliesI have 2 workbooks( Book1 and Book2) with multiple sheets.I am only interested in one of the worksheets in the workbooks(both the worksheets names are the same).The thing is that the data is in the form of pivot tables, so each time i have to filter according to specific categories, copy and paste into another new workbook.The thing is column headings in both the worksheets are different,BUT BOTH the worksheets data must be combined into 1 single worksheet( row after row).
Meaning in Book1, my columns are in the form of Cost, revenue,margin and in book2, the columns are in the form of Cost,Revenue, Profit Margin %.... That means i must add a profit margin % column in Book1 and a Margin column in Book2 before I combine the data into a single worksheet. Each week, new data gets added into Book1 and Book2, so I wish to automate this by creating a code, so that when the source data changes, my new workbook's data also changes.
I am looking to produce an Excel report from an Access database table. The data contains numerous records with fields for Site, Country, Region, Type and a Resolution Time. My problem is that each month the Sites change so I need to be able to write VB code within Access to read the database table and output 'Site' records for that month, grouped together along with the incident details for that site, e.g. The report would have the following headings:
'SITE' 'COUNTRY' 'REGION' 'TYPE' 'TOTAL' 'RESOLVED<3DAYS' 'RESOLVED>3DAYS' 'NOT RESOLVED'
MEL AUS APAC TECHNICAL 78 40 31 7
MEL AUS APAC HARDWARE 49 40 8 1
LON GBR EURO HARDWARE 90 40 40 10
As I will have over 30 different sites and these may change each month how do I loop through the data identifying each site and its associated field values? I have used the following code to open the data and loop through records printing to excel, but am stuck at grouping by site:
Set rst = db.OpenRecordset(sqlStat)
row=10.......
..... Do While Not rst.EOF
.cells(row, 1).Value = rst.Fields(0)
.cells(row, 1).Value = rst.Fields(1)
.cells(row, 1).Value = rst.Fields(2)...
I'm trying to match up a specific group name and see if it exists for the currently logged in user using Active Directory roles. If the Group Name exists for the Current User, I want that group name to be displayed in a drop down list. Example: If current user is in BIG Group, display BIG in drop down list.Problem: All I am getting is SIDs and I'm not able to get anything to match up to the group name and nothing will show up in the drop down list.I also get the following Error:Error: Object variable or WIth block variable not set.How do I fix this?? here is the code I am using:
Private Sub GetMarketingCompanies()
' code to populate marketing company drop down list based on the current logged in users active directory group that
[code].....
Enumerate if an Active Directory group's member is user or another group
View 1 RepliesI need to understand if I can integrate two applications... one which I purchase, and one which I will write in VB. What my application needs to do is to retrieve data from the purchased application form and then update back to the purchased form fields.
View 2 RepliesI was wondering if it is possible to bundle a .net framework client runtime (.net framework 4 to be exact). Because not many computers have .net framework 4 Installed and i don't want them to download from the microsoft site. As i checked the program itself is a redistributable package <link>. Now the problem comes how do i integrate this into my own installer so that instead of asking for a download it would just ask to install the framework and then install from the setup that will be included in the package. I am using a standard setup project. Using VS 2010 Pro.
View 1 RepliesI would like to integrate our SIP VOIP FreePBX phone system with our VB .NET app. Especially Caller ID. I want the customer's caller ID to show up in my app.
View 6 RepliesI have a VB6 app migrated to VB.NET / VS2010 currently under test. Issue is with integration between the app and Outlook (2003). In summary the app opens an Outlook Explorer window to let the user view a calendar and update appointment items, any changes made are validated and if OK written to a db.
There are two methods here, one handles event Item_Change and does the validation / updates, the other handles Explorer_Close and tidies up all the Outlook objects. There is a condition in the Item_Change method ("If rs.RecordCount = 0 Then") which if detected needs the Outlook Explorer to be closed programmatically.
[Code]....
Does the Visual Studio .NET Help Integration Kit exist for VS 2008?Tim Alvord
View 3 RepliesI have developed an ASP.NET 1.1 Application. I have also writen a help file in html format. how to integrate the help file into the ASP.NET application.
View 4 RepliesI am a student at the University of Findlay in Ohio. In our software engineering class we were given an assignment to make a database of 2 tables in Access. Simple enough. We then had to integrate that database in to VS. Again, quite simple. Along with that we are to make 4 reports that can be displayed to the user.
The problem comes here. I can not figure out how to allow the user to select say a Recruiter Number and show all the Clients who that recruiter is in charge of as well as the amount of money they owe and what they have paid already. Also I need to total those two values.
[Code]...
I have the following script that works just fine if I run it as a VBS script.
Const Enabled = 1
Const Disabled = 0
Set objUser = GetObject("LDAP://CN=wiles, anthony,OU=JOI
[Code].....
I've read up on MSScriptControl.ScriptControlClass, though that would work on a windows XP computer, but seeing as i'm using all windows 7 X64 bit machines in my domain, thats not really an option.
the project is about this:there's a user interface(ASP.net web application) which is connected to a client / server program written in c (this program has to be in c).the c program works like this:the server has to be running, and its done by:
./server 1234
the the client tries to connect to the server by:
./client localhost 1234
when two modules are connected, different messages can be sent from the client to the server.now what i want to achieve is to send the command from the web application to the c program... so by a button click the c program would run and send the command...
Does anyone know if this is possible:
1. Create VB9 application that monitors an Outlook Inbox.
2. When an email from a particular recipient is received, open the attachment (Excel.xls)
3. When the attachment opens, a macro is executed and the sheet is re-formatted (have already coded this bit in VBA).
4. Save the re-formatted sheet, re-attach to an email and send.
As mentioned, I have already done 3 and I have done 4 in other applications. What I am unsure how to tackle are points 1 and 2.
Has anyone had any experience with something along these lines?
i have windowsdeskopintegration.dll and i want codes for progressbar, jumplist, takslist, taskbar buttons but in visual basic forms applications.
View 3 RepliesI am writing an application and I do not know how to reference a group of controls inside a group box. I will include the code I have written so far and a picture with a detailed explanation as to what I am trying to do. Feel free to comment on any discrepancies that you may notice in my code.
Code:
Public Class Form1
' The following class-level constants are used
' to calculate the price of the model
Const decCOUPE As Decimal = 18000
[code].....
I want to remove a group (include all items in this group) in ListView, but unsuccessful, the code is below, why?
ListView1.Groups("GroupName").Items.Clear()
ListView1.Groups.Remove(ListView1.Groups("GroupName"))
anyone have some quick code on how to do this?
wmi is not a option.
send data collected from a asp.net web page using vb.net that has a bunch of text boxes for first name, last name, address... item price, quantity, total price... to paypal for processing and settlement?i have never worked with paypal so i am assuming paypal will get this info and generate a bill to send the user.
View 1 RepliesIve been asked to integrate a windows form application with SagePay to take payments directly from the application. The SagePay documentation talks about ASP.NET so Im not sure whether this is possible. Has anyone integrated a WinForm application with SagePay before?
View 3 RepliesI am planning to create an import/export package using SQL Server Business Intelligence Development Studio, however, when I reach step 3 as shown below, I cant find Integration Services project (template section). i.e., Business Intelligence Projects is not available as a Project type.
View 7 Repliesdoes VB.NET include the Mathematical Integration/Derivation functions in the Library? If so where are
they, I couldn't find them? If not, any third-party libraries you would recommend?
I am trying to use the background worker to keep my application responsive during the calculations it does. All I need is one to calculate and the other to count time which I use a timer for. But when I try to use a progress bar as well as I want to see the progress it gives me an InvalidOperationException: Cross-thread operation not valid: Control 'ProgressBar1' accessed from a thread other than the thread it was created on. I need this to work, how could I use a component from outside the background worker? This is the background worker bit:
[Code]....
I don't get this to work! I've 'added' the Bookmarks of the FAVORITES folder to a menu on a MenuStrip in a Windows Form - however, whatever I try, they do not open in my Webbrowser Control. Instead they 'open as a download' and then open a new IE Window with the correct site.
[code...]
Is there a simple way?Listing SPEC's is not a review.
hook up the edmx generated classes such that we can include them on the uml models? This would be great if we could because when we do support we could reverse engineer the database, generate the objects and then directly use them in our sequence diagrams and in our workflow services. Also if we could generate code, and or link code back to the model from the UML model classes that would be great as this would let us graphically show our applications at any point.
View 1 RepliesAs the topic says, I am having an error on integrate an Admob Ad on an app that I am developing for WP7, with Visual Studio 2010 .NET Language. This is the error:Quote:
Originally Posted by Error Message
System.Windows.Markup.XamlParseException occurred
LineNumber=52
LinePosition=180
[Code]...
In my Application, I have a Windows Media Player App integrated. Is their anyway I can have it so If a checkbox is checked, Then it will automatically start playing, And if the checkbox is NOT checked, then the user has to manually press the play button?
View 1 RepliesA client encounters an error while opening a form with a crystal report viewer. The error is persistent even though I've installed the crystal report 20008 runtime redistributable at the client. The error reads:
[Code]...