Recent IT Questions

1 - 20 of 406
<<PREVIOUS 1|2|3|4|5|6|7|8|9|10 NEXT>>

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!

View Answer   |  Jun 30 2009  7:55 PM GMT
DTS, Microsoft Excel, DTS Import/Export Wizard
asked by Stan1001

  25 pts.

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.

View Answer   |  Jun 26 2009  11:31 AM GMT
AS/400 backup, AS/400 import/export, Microsoft Excel
asked by 1510

  15 pts.

Convet pf file to Excel

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

View Answer   |  Jun 25 2009  2:04 PM GMT
AS/400, PF, Microsoft Excel
asked by 1510

  15 pts.

Excel Page setup Landsacape

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

Answer Question   |  Jun 25 2009  9:20 AM GMT
VBScript, Microsoft Excel, Landscape
asked by Dha

  5 pts.

convert excel to oracle 9i?

how can i convert data excel to oracle 9i?

View Answer   |  Jun 25 2009  6:37 AM GMT
Oracle import/export, Oracle 9i, Microsoft Excel
asked by Binty

  5 pts.

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....

Answer Question   |  Jun 22 2009  11:33 PM GMT
Excel VBA, Visual Basic for Applications, VBA
asked by Gotovamsee

  5 pts.

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.

View Answer   |  Jun 19 2009  2:09 PM GMT
Excel macros, Excel 2007, Microsoft Excel
asked by Njasche

  5 pts.

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

asked by Sagardip

  10 pts.

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

asked by Leeanne45

  5 pts.

Access database table linked to Excel file question

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

View Answer   |  Jun 12 2009  7:38 PM GMT
Access 2007, Access Database, Microsoft Access
asked by SeenFresh

  25 pts.

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...

Answer Question   |  Jun 12 2009  6:18 AM GMT
VBA, Excel VBA, Visual Basic for Applications
asked by Sswcharlie

  5 pts.

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....

View Answer   |  Jun 11 2009  5:43 PM GMT
Excel 2003, Excel worksheets, Microsoft Excel
asked by Wiggetssis

  25 pts.

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??

asked by Souras

  5 pts.

Excel to Access conversion

Accounting came and asked me if a very complicated Excel spreadsheet that they are using for cash receipts could be "moved" into Access. I explained to them the difference between a spreadsheet and a database and that Access could definitely be used to better handle transactions etc. but it would...

View Answer   |  Jun 9 2009  3:20 PM GMT
Excel 2003, Data transfer, Microsoft Access
asked by KSoniat

  350 pts.

Oracle Form: export to Microsoft Excel

I have an oracle form,i need the code of a function that exports a given SQL query into Excel sheet on a button click action.

View Answer   |  Jun 8 2009  6:22 AM GMT
Oracle, Microsoft Excel, Oracle import/export
asked by Chetana04

  5 pts.

Change English numbers to Arabic numbers

change english numbers to arabic numbers

View Answer   |  Jun 7 2009  9:42 AM GMT
Microsoft Excel, Arabic numerals, English numerals
asked by Mark47

  5 pts.

AS/400 addon for Microsoft Excel

is there an addon that allows data to be sent back and forth excel to as400

asked by Glenc

  15 pts.

File Transfer to iSeries from Excel 2007

I am using the iSeries Client Access for V5R4, and trying to transfer an Excel 2007 (.xslx) file. There is no corresponding file type to choose from (only goes up to Excel 2003 (BIFF8). Is there any other way to do this using Client Access

View Answer   |  Jun 3 2009  8:23 PM GMT
Transfer Data To iSeries, Excel 2007, iSeries Access
asked by Badkarma

  40 pts.

Inventory work for storeroom using Excel VBA

Im supposed to do inventory for a store room at work using excel. Oraganizing and labeling all the items in there so that my boss can be able to find what he wants easily by simply for example if he wants a clock he looks for clock and he sees its at b1 and he looks for b1 and that specific item...

View Answer   |  Jun 2 2009  3:19 AM GMT
Excel VBA, Microsoft Excel
asked by Emozae

  15 pts.

email macro

create amacro to send an email with Excelattachment

View Answer   |  Jun 1 2009  5:19 PM GMT
Outlook, Microsoft Excel, Excel macros
asked by Jraleccolin99

  5 pts.


1 - 20 of 406
<<PREVIOUS 1|2|3|4|5|6|7|8|9|10 NEXT>>