Search results for query: *

Hello, i have a smartphone application that generates a XML file. this file contains a text field, a numeric field and a date field. i would like to link this file to an Excel. i have done this without any problem. however, i have a weird date field. in fact it is 18 characters long. when i...

Hello, i would like to know if there is a function in Excel that will allow me to calculate a cost based a $/min and a duration Actually, my data looks like this Duration(min:sec) Minute Cost Total Cost ----------------- ----------- ---------- 90:15 2...

hello, i would like to know if any one has already a populated date dimension in MS sql server 2000. with the different attributes( week #, day #, week_day, day_in month, etc...). if not, does any one knows how to populate this dimension? thank you Regards Adnane Micorosft North Africa...

Hi, i'm developing a small application using access 2003 to basically manage the inventory and sales of a shoes store. what i need this application is very basic: keep track of orders, purchases, sales, and generate some reports. does anyone know where i could find some useful...

Hi, i was wondering if there was any way to create a shortcut that would, whenever pressed, type a string in the active textbox. For instance to press Ctrl+Shift+Key would type "Hello" Thanks Adnane Micorosft North Africa http://www.microsoft.com/northafrica

Hi, what i'm trying to have is to get the customer's name (entered by the user in a form) ang save the workbook as "FileName_CustomerName.xls" where the FileName doesn't change and it's always saved in the same location. Regards, Adnane Micorosft North Africa...

Hi, what i'm actually trying to do is the following. i have an Excel product pricelist (containing the SKU, product name, Price,...). on the other side, i have a .doc template for propsals to customers that contain an embedded Excel sheet to put in the products the customers is interested in...

Hi, i'm using a macro to delete all sheets (except two named ones) before the rest of it gets executed. this is to avoid having a lot of sheets after a couple of executions. what i'm asking now is how to do it without having to confirm the deletion of each sheet manually. i tried the...

Hi, i have a sheet that have a constant number of cols but the varies in row numbers. actually what i need is to insert a bit of code in my macro that would detect the range of the database and create a pivot table based on this range. Thanks Adnane http://www.microsoft.com/northafrica

Hi, i would like to have a macro for Outlook that would allow me to go through all the mails within a specific folder and get all the sender's mail addresses, then put them in an Excel file. Do you think that this can be done? and if yes i would really appreciate some help on doing this...

Hi, does anyone know a keyboard shortcut to launch internet explorer except winkey+r then type iexplore. Regards Adnane

Hi, i have devolped a macro under Excel and i was wondering if there was a way to convert this macro to an add-in so that it'll much simpler for its users. otherwise, now they have to import the module each time before they can start using it. Regards, Adnane

Hi, please, i need to have a formula that counts within a cell the number of occurences of a specified character. for example if A1 contains Value1, Value2, Value3 and the specific character is "," the result cell B1 should contain 2 Thanks

Hi, i need to send a word document from an excel file based on a flag. an extract of the xl file would be: Customer Doc Mail_address Send Customer1 My_Doc address1@server.com yes Customer2 My_Doc1 address2@server.com No what i would like to end up with is to send my_doc to only...