Search:

Thanks, it works 100%

I'm receiving a file with a column with alpha numerical text. I need to add to the left of the value zero's to make it 12 digits. An example is 1A becomes 0000000001A and 124ABC should be...

Error was in the formula. Thanks

A colleague is trying to do a vlookup on Excel 2007 in column 257 and based on values on another column 257 in another spreadsheet and the result is #value. Are there a work around except splitting...

Thanks Hans

How do I show the next page's number on the current page. I would like to end the page with ..../2 on page 1

TIA

So Hans there is no id for separate Excel "Sessions" on a server if the users uses an generic log on?

I have the following problem. I receive Excel Spreadsheets via email and then upload via a web page to a server. Excel process does not successfully close. Is there a way of identifying a Excel...

I have a spreadsheet where the spreadsheet is flipped. Cell A1 is in the rigth top cornor and the row numbers runs on the right side of the spreadsheet. The scroll bar is also on the left side. I...

Thanks it work great

I've written the following code but keeps getting an #name error

Public Function INSTRING(TextSearch, TextFind)

Dim LPosition As Integer

LPosition = InStr(1, TextSearch,...

Thanks the second solution work.

I have a document with only 1 page of writing. I can't get rid of the 2nd page. Refer attached.

TIA

Thanks Hans. The other alternative is to use Macro's. I know that there is a way of using a specific naming convention for the macro, then SAP performs this macro in Excel before it finalise the...

Thanks Jan
Thanks Hans

I will try and explain Hans. Inside SAP (Access is the same) you have the option to open your current view with Excel and the SAP Report changes to an excel worksheet. ...

I want to open a Excel File from within SAP. When Excel opens it reads the fields and queses the field type. In this file I'm opening it has a credit card number. Excel then changes it to a...

I currently have couple of forms in access with a button that triggers the import of files into an Access table using docmd.transfer and a saved spec. I want to trigger this event from a .net front...

Thanks Hans. I will try it

To be honest I'm to lazy to click forward and then selecting the right address. I will be "saving" 1 click.

Can someone maybe help me with a macro to send a message out. I would like to setup an icon that will send the open message out to another address. I know it would be better to create a rule but I...

Thanks Hans.

No I don't. What is the right method/code

TIA

After your statement about spaces not allowed I realized that I am showing the name as it appears on our company's address book. I will change the email address the RAM's@shop as it appears under...

I would like to send an email to the following address (WC RAM's@shop) with code. I'm having problems with the 's and or space and when the email goes out it goes to WC. How do I change the code to...

Hans I don't understand it. We've changed the code and created the template. If I take that template to the Excel 2000 I can't edit the range. If I then unprotect the worksheet and go to Format...