I have an excell spread sheet generated from Sequel, I can get it ot a folder on the 400 but would like it get it to a shared folder on my network. I have tried to copy it FTP it and nothing seems to work.
Answer Question | June 2, 2010 6:43 PM
file sharing, FTP, Microsoft Excel, SEQUEL, XLS
I created a macro and it is saved in personal.xls. How can I make this macro available to other users? I want to be able to give them the ability to run the macro – they do not need to modify it.
Answer Question | May 25, 2010 12:11 PM
Excel 2007, Microsoft Excel macros, User access, XLS
I need a little help! Is there anything out there that I can incorporate into a CL program that will download a database file to Excel with an xls extension so no further converting is necessary. I tried the CVTPFXLS but get Pointer not set for location referenced.
Answer Question | May 20, 2010 11:56 AM
CL Program, iSeries, iSeries programming commands, Microsoft Excel, XLS
I am using CPYTOPCD and emailing the resulting *.csv and *.txt files successfully. However, I am now trying to send the data as an XLS. Although the file is sent, the data does not appear in the different cells as I would expect, the whole string (although comma delimited) appears a whole string (ie. Dealer [...]
Answer Question | December 23, 2009 11:53 AM
CL Commands, CL programming, CPYTOPCD, File conversion tools, File formats, File Transfer Protocols, Microsoft Excel, XLS
I have created a New xls in my NSF (above specified in title). Now I want to extract that object from the Notes Document. How can I do this. I have used NSFItemInfo and NSFItemInfoNext with item_name as $File. Is it Ok or I need another extra information?
Answer Question | February 25, 2009 8:52 AM
.NSF files, C, Lotus Notes, Lotus Notes Developement, Microsoft Office Library template, NSFItemInfo, NSFItemInfoNext, OLEObject, XLS
after using Excel 2007 for several months with no problem, I had to reformat and reload windows xp professional. then I installed Excel 2007 and now I can’t open the xlsx files created by Excel 2007. I get the error in the above title box. Any help will be welcomed. Gervis.
Answer Question | December 31, 2008 3:50 AM
Excel 2007, Microsoft Excel, Microsoft Office File Extensions, XLS, XLSX
To enable our reporting software to correctly export to Excel 2007 (WXP SP2 operating system) we need to change the following Windows Explorer ‘File Types’ setting: Open windows explorer and navigate to the XLS file type and enable the “browse in same window” option, see path: ToolsFolder OptionsFile Typesselect XLS file typeselect Advancedenable “Browse in [...]
Answer Question | December 9, 2008 9:37 AM
ADM template, Excel 2007, File extensions, File Types, Group Policy, Microsoft Excel, Microsoft Excel 2007, Office 2007, Windows Explorer, Windows XP, XLS
All, After I have deleted a xls file using an ActiveX script the DTS Package fails because the file is not there. I then have to go into the properties of the task and go to the destination tab and click the create button. The I have go to the Transformation tab and then run [...]
Answer Question | January 10, 2008 5:11 PM
ActiveX, DTS, SQL, XLS