Microsoft Excel

Creating a .xls text field from AS400 file with dd/mm/yy field

I am using client access to create a spreadsheet from an AS400 file. Although a date field is defined as alpha in AS400 DDS specs, the field is populated as dd/mm/yy in the AS400 file. When the spreadsheet is created using client access, the field does not come across as text. I need the field...

import from excel to oracle 9i

how can i import data from excel to oracle 9i?

Vlookup Worksheet Function

I develop and maintain pricing models that involve a lot of looping through cells and applying assumptions. For some reason I never seem to be able to get the vlookup worksheet function to work when looping through cells. It either says 'application-defined or object-defined error' or more...

How do I overcome the "Could not find installable ISAM. Excel 2007" Error? Ex

I got the "Could Not find installable ISAM error" while uploading an Excel file in my application.This seems to be happening at the "connection.Open()" code line. -- Web Application -- .Net 2.0 -- Testing using IIS 7.0 on Vista Ultimate -- Office 2007 Enterprise Installed on machine. Code works...

Create a file with formulas on the iSeries and send to Excel.

I can create a file in SQL that has formulas in it (i.e. '=A1*B1') and I can send them to my PC and open them in Excel. However, the formulas are showing instead of the results. If I click inside the cell and hit Enter, I get the value instead of the formula. BUT, I want this automated and don't...

Combobox Intro. Question

Hi! I'm extremely new at using combobox in Excel and I have 2 questions about how to incorporate them into my files. 1.) Is there software that I can use to "produce" the VB code I need to set my comboboxes over my Data Validation cells? Not used to actual programing. 2.) I wanted to know if...

put excel password in VB coding

i had two workbook name workbook1 & workbook2 they are interlinked with each other and i put one password to that workbook 1. by default workbook2 ask for password i dont want to put password every time so shall i put my password in VB code

DTS: Export to Excel

I'm exporting a simple table to Excel but my problem is that the table columns will change every month since the column names will list month names (ex. May2009). Can I use ActiveX to dynamically create the transformation source? Please help!

generating excel on server

I want to generate excle on server and store. I had copied spl file to pf but how can i generate excle on server.

Convet pf file to Excel

I had copyed spool file to pf and i want that should be copied to execl format.

Excel Page setup Landsacape

How to write a VB script to change the Excel file page orientation to Landsacpe.

convert excel to oracle 9i?

how can i convert data excel to oracle 9i?

Extract all instances of a search between two symbols

Dear Friends, I have created the following code to search entire C Column from WrkBk1 with "<*>" string so as to extract all the matched words into Wrkbk2. for eg a single cell data in Col-C is given below maintaining similar pattern in other cells too. [Cell C1 Data] Enter Pers No....

Run a Macro in Excel 2007 spreadsheet located on a file server

When I run the macro located on the local drive it works, but when I put the document out on a shared file server I get an error. The server folder is in my trusted locations.

Managing Restriction for users with Windows group policy

Dear Friends, pls guide me how to restrict users form password protacting excle sheets using group policy or other method.Please note my email id for further communication patil_dipak2@yahoo.com

Crystal Reports file error: data may have been lost

using CR7 xp sp 3 office sp 3 when I do a export from CR7 to excel I receive the following message file error data may have been lost

Access database table linked to Excel file question

Can multiple instances of the same access database be open when linked to same excel file?

Excel VBA cell.find

I have this code recorded by XL. Works ok. ** Cells.Find(What:="dd", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _ xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False) _ .Activate End Sub ** In the first part - (What="dd", I want the macro to read Cell...

Copy Data from an entire row in Excel 2003 Sheet to another sheet in the same workbook automatically

I have an excel workbook that has a Year To Date summary in it. People enter new data into the YTD summary (along a row there are 15 columns of data to be entered). One of the criteria for the entries is report date. I would like to have other sheets in this workbook (Each named a month, ie....

SSRS Excel Reports

Hi, I have exported my ssrs report to excel.Everything seems to be fine regarding the alginment of columns etc. However, additional row or two appears colored below the complete table of the report. Can u please help me on removing this??