Search results for query: *

Hi all, I'm having a weird issue with my breadcrumbs. When I use the server name on the URL e.g. http://servename/default.aspx, the breadcrumbs work fine. However, when I use the actual name of the portal e.g. http://myportal/default.aspx, my breadcrumbs only work for certain pages and don't...

Hi, I'm using Javascript and CSS to create some drop down menus for a site. Everything works fine in IE7+ but it doesn't work in IE6. Some of the site's users still use IE6. Any suggestion on how to fix that issue? Below is my HTML, css and JavaScript code: HTML ---- <ul id="menu"> <li><a...

Hi all, I’m trying to open the Navigation panel from SharePoint Designer 2007 to modify my global navigation (Site -> Navigation) but I’m getting the following error message: “the navigation view cannot be displayed for this web site” although I have owner permissions to the website. In...

Skip, My code is working fine when the number of columns is less than 256. The problem is the limits on the number of columns in Excel 2003. I just want to be able to copy the extra columns (255+) to a new sheet. Below is where the code fails: While Not rsDesk.EOF...

Hi Skip, Below are my answers: 1. We are importing the data from MS Access to create an Excel report for the legal team. 2. The legal group wants to see the data in a specific format which is why the columns have to be in that manner. Like I said above, everything is fine if they use Excel...

Hi all, I have posted here before and most of the time, I have gotten the help that I needed. We have the following macro that creates a report. The macro: 1) Open a template (Excel file) and copy the same (4) columns from one sheet named “Sheet 1” to another one named “Table 1” multiple times...

Hi Skip, I finally identified the issue. My macro is trying to return 274 columns while Excel 2003's limit is 256 Columns. To fix this issue, I must use Excel 2007. Thanks for your help. I really do appreciate the time and effort. B.

Hi, The macro also extracts data from an Access DB and copy the data to an excel file. The problem is that there are 69 distinct records (strSQL = "SELECT DISTINCT Summit.Desk FROM Summit"); but the macro only copies 63 (instead of 69) and then it returns the error message above. Any...

The macro is collecting feeds from some systems. The extracts are file-based and the macro reads the files, parses them and collects statistics about modifications made to trades in these systems. To summarize, it pretty much copies data and pastes it to a template. Apparently, the macro used...

Thanks Skip! This VBA macro was actually created by someone who no longer works for my company. I have some basic knowledge but I'm not really an expert on VBA; I'm just trying to find a way to make it work.

Hi all, I have a VBA macro which had been working fine until recently. Now I'm getting the following error message: "Run time error 1004: "The information cannot be pasted because the copy area and paste area are not the same size or shape...". Can you help me? Below is my code: Sub...

Thanks! I will try your suggestions.

I forgot this line at the top: string principal = this.Context.User.Identity.Name;

Hi all, I have the following code to read user information (email address) from Active Directory in ASP.net. However, I'm getting this error message: System.Runtime.InteropServices.COMException: The server is not operational. Has anybody gotten the same error? I need your help. string filter =...

Thanks for your feedback. The application that I created is a web form. Every time a user submits the form, the application will send an email to my manager. Thus, the "Mail From" should be the email address of the user.

Hi all, I have the following code to send an email from a web interface and it works fine. However, I want to know if it's possible to replace the email address specified in "Mail.From" by the default client email address. If yes, how do I do that? SmtpMail.SmtpServer = "localhost"...

Thanks! It works fine now!

Thanks guys for your help! but how do I make sure that it highlights the entire column instead of just the cell?

Hi all, I would like to create a macro that highlights multiple columns in Excel when the first row of the column is equal to "1". I was able to find the solution for one column but I would like to do the same for 50 or more columns and I don't want to copy and paste my code. Is there any...

Thanks guys!!