Search results for query: *

Hi All, I want to create a macro to create a pivot-like table. I dont want to do calculation, but only want to show the values. Here is the content of the Excel file: Column A Column B Column C Column D 16-05-2014 15:47 Machine1 Peter Not started 16-05-2014 15:47...

Hi All, I have a table with the following content: Datetime | StartStop | 21-03-2014 17:40 | Stop 21-03-2014 12:40 | Start I want to sum the hours a day. How can i realisze that. I want to have: Date - Hours worked 21-02-2014 - 5

Hi Friends, I have a huge spreadsheet (~20.000 rows each time). It looks like as follows: Column A B C D E F G H I J Test records 595 595 A 11-XXX-12 3522 A 4-11-2013 05:56:17 3,14 Test records 595 595 A 11-XXX-12 3522 A...

Hi all, Does anybody know how to extract a text till a space from the right? For examle 1234 DF DDDDD I want to extract only DDDDD

hi All, I have the following information: Date Name Code 20-11-2013 Mike KKT 20-11-2013 Mike HGK 20-11-2013 Mike MMK 20-11-2013 Michael HGK 21-11-2013 Edward ZZQ I want to put Group this...

Hi All, I have tried a couple of hours but i coulnt get realised it. I have a table with the following records: € 692,51 1a -€ 249,17 1b -€ 377,36 sub 1a -€ 39,74 sub 1b -€ 26,24 (empty) The content may change. E.g it is also possible to have the values: € 692,51 1b -€ 377,36 3c -€...

Hi all, I have really tried everything, but it looks like that i can not disable the address bar in Windows server 2008 for the internet explorer. I have a remoteapp application, which opens the internet explorer (help menu) en from there the users are able to browse the whole server and...

Hi All, I have setup an environment with SBS 2011. 5 Employees are working with RemoteApp on a bookkeeping application. The SQL database is on the SBS2011. Now for the external users (max 5), i want to use the second (old) server. On this server i want also to install the bookkeeping...

Hi, Im working in column E. In VBA i endup in an active cell, and i want to sum the values above the active cell. How can i arrange that? Let say column E contains the values, and on the position x i want to put the SUM: 10 2 3 4 5 x So x should be: 24. I can have a lot of values and i only...

Hi all, I want to search the value: Myword in column E and want to do an offset. I want to get the address of the cell, for example E8. And from here i want to do an offset (-4, 0), which is = A8. I have tried several things but without success, below an example: Cells.Find(What:="Myword"...

Hi, My vendor adds a red license text, which is automatically created, within the pages. I can overrule the basic CSS adding for example the following example: <style> td { color: #635D5A !important; font-weight:100 !important; } </style> I can change the background color of the text, but i...

Hi all, My friend has his own business with 5 employees. They have now a windows 2003 environment with xp clients. He wants to buy a new server and we will install windows 2008 r2. He has 3 applications which he wants to "host" with remoteApp functionality. His own employees (5) and 10 customers...

Does anybody know how i can create such screenshots? /0/]See here Can anybody give me a step by step instruction how to create this part. Do i need to have Adobe Photoshop or another tool?

Hi all, Is there anybody who can tell me of there are examples of macros which can convert html mail into Microsoft Word? I want to made contracts within word and the majority of the text of the contract is fixed. The extra fields (like names, contract details, addresses) will be send to me by...

Dear friends, I have got the Java code from the vendor to post a XML message with a JPG file to the webservice. Here you can find the Java code: import java.io.File; import javax.ws.rs.core.MediaType; import org.apache.commons.httpclient.HttpClient; import org.apache.commons.httpclient.URI...

Dear Friends, I have really tried everything but i cannot translate the JAVA code into VB.net. Could anybody translate this? A big golden star for the final solution: import java.io.File; import javax.ws.rs.core.MediaType; import org.apache.commons.httpclient.HttpClient; import...

Hi, Does anybody know how i can upload a Word document with a XML document to the webservice? I have really tried everything, but without success. It is bad VBA coding, but im testing and hope that you can give me some hints. The JAVA code works, but not in VBA -:) I will put both codes: Im...

Hi all, I have the following code as example: import org.apache.commons.httpclient.HttpClient; import org.apache.commons.httpclient.methods.PostMethod; public class TestLogin1 { public static void main(String[] args) { HttpClient httpClient = new HttpClient(); PostMethod...

Hi all, Is it possible to put the content of the site into different worksheets? The site is as follows: http://www.mysite.com/Default.aspx?app=1&page=Network%20add&comid=1 I need to have the content till http://www.mysite.com/Default.aspx?app=1&page=Network%20add&comid=500 How can i put...

Hi All, Our application works on SQL 2005. It can read information only from one database (restriction of the application of the vendor), lets call this MYDATABASE. Is it possible to create a view within this database, to get real time information about some other tables within an AS400...