Data transfer .XLS to iSeries
It’s worked the last 4 tries (tho had to tweak each time), but now I just get basically one long field coming in. The comma delimitors are treated as just another character byte. While setting up a “power user” to take over this function (so no .fdf or other residuals from prior successful uploads), I [...]

Answer Question   |  August 7, 2009  8:30 PM
Excel to iSeries, iSeries, Microsoft Excel, Transfer Data To iSeries

SAP export to Excel 2007
when exporting a spreadsheet to excel 2007, currencies show in the wrong format (ie. 1,882,456.96 shows as 1882456:96). I’ve tried to format the cell but this does nothing. Also I’ve verified switching the regional settings but no luck there neither. Help will be trully appreciatted, Max.

Answer Question   |  February 26, 2011  1:34 PM
Excel 2007, Microsoft Excel, SAP, SAP Export to Excel

Paste records in OLE Unbound Excel Object in Access Form
Ok so I have built a database that is used to house and manipulate records that I get from a monthly report that is posted online. Basically I work for the Army and we have over 50 units. Each unit has anywhere from 10 to 1000 soldiers in it. I initially had tried to build [...]

Answer Question   |  August 5, 2009  2:26 PM
Access forms, Microsoft Access, Microsoft Excel, OLE

UPK scripts/Excel Scripts and HP Quality Center
How time consuming is it to convert UPK Scripts into HP Quality Center and set them up for automated testing? What about test scripts in excel

Answer Question   |  August 3, 2009  8:25 PM
Automated Testing, Excel Scripts, HP Quality, Microsoft Excel, UPK

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

Answer Question   |  August 4, 2009  6:54 PM
AS/400, Microsoft Excel

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

Answer Question   |  September 4, 2009  7:45 AM
Microsoft Excel, Microsoft Excel import/export, Oracle 9i, Oracle 9i import/export

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 frequently I get something along the lines of [...]

Answer Question   |  August 12, 2009  12:21 AM
Excel VBA, Microsoft Excel, VBA, Visual Basic for Applications, VLOOKUP function

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 successfully when used in a Windows [...]

Answer Question   |  July 9, 2009  10:06 AM
.NET 2.0, ISAM, Microsfot Office 2007, Microsoft Excel, Microsoft Excel 2007, Microsoft Windows Vista, Web development

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

Answer Question   |  July 9, 2009  3:49 PM
AS/400, iSeries, Microsoft Excel, SQL

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

Answer Question   |  July 8, 2009  4:38 AM
ComboBox, Excel VBA, Microsoft Excel, VBA, Visual Basic for Applications

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

Answer Question   |  July 7, 2009  10:35 AM
Microsoft Excel, VB, VB Code, Visual Basic

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!

Answer Question   |  July 3, 2009  7:55 PM
ActiveX, DTS, DTS Import/Export Wizard, Microsoft Excel

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.

Answer Question   |  June 26, 2009  11:31 AM
AS/400 backup, AS/400 import/export, Microsoft Excel

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

Answer Question   |  June 29, 2009  2:04 PM
AS/400, Microsoft Excel, PF

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

Answer Question   |  February 22, 2010  9:20 AM
Landscape, Microsoft Excel, VBScript

convert excel to oracle 9i?
how can i convert data excel to oracle 9i?

Answer Question   |  June 25, 2009  6:37 AM
Microsoft Excel, Oracle 9i, Oracle import/export

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. <pernr> Verify: 1. [...]

Answer Question   |  June 23, 2009  11:33 PM
Excel VBA, Microsoft Excel, VBA, Visual Basic for Applications

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.

Answer Question   |  June 22, 2009  2:09 PM
Excel 2007, Excel macros, Microsoft Excel

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

Answer Question   |  June 28, 2009  12:45 PM
Group 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

Answer Question   |  May 19, 2011  12:20 PM
Crystal Reports, Crystal Reports 7, Crystal Reports error messages, Crystal Reports Export, Crystal Reports Export to Excel, Microsoft Excel, Microsoft Office, Windows XP