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!
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!
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.
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.
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.
How to write a VB script to change the Excel file page orientation to Landsacpe.
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....
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.
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
View Answer
| Jun 17 2009 12:45 AM GMT
Group Policy, Microsoft Excel, Microsoft Excel password protection
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
View Answer
| Jun 17 2009 12:45 AM GMTGroup Policy, Microsoft Excel, Microsoft Excel password protection
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
View Answer
| Jun 17 2009 12:20 AM GMT
Crystal Reports 7, Crystal Reports error messages, Crystal Reports Export
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
View Answer
| Jun 17 2009 12:20 AM GMTCrystal Reports 7, Crystal Reports error messages, Crystal Reports Export
Access database table linked to Excel file question
Can multiple instances of the same access database be open when linked to same excel file?
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...
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....
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??
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??
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...
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...
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.
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.
AS/400 addon for Microsoft Excel
is there an addon that allows data to be sent back and forth excel to as400
is there an addon that allows data to be sent back and forth excel to as400
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
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
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...
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...
