I have an Excel 2003 workbook that contains a macro to copy certain of its sheets across to a new workbook, then save and close the new workbook. It does this several dozen times, with slightly different sheet selections each time. I would like to add an extra step to the macro to export the secondary workbooks' spreadsheets to PDF. T...
Let's say there is a report to compare charges with adjustments that outputs to excel, such that each row has the following fields: Account Number charge date Original item number Adjusted Item number Original Qty Adjusted Qty Original amount Adjusted amount Original Post date Adjusted Post date I need to help a user create a view in...
I have a procedure that is run for a lot of items, skipping over certain items who don't meet a criterion. However, I then go back and run it for some of the individuals who were missed in the first pass. I currently do this by manually re-running the procedure for each individual person, but would ideally like a solution a little more...
I am creating a C# windows application to create an Excel 2003 sheet. There is a requirement to add to the footer: Page 1 of 4. I currently have it so it puts "Page: &[Page] of &[Pages]" into the footer of the excel sheet. When I open up the created document and look at the footer I see "Page: Page] of Pages]" I can click on the tex...
Hi I am trying to copy website data to XL 2003 I was told about using "send keys" but it doesn't work. Please could someone help me. [code] Sub CopyInternetDoc() Dim IntApp As Object Set IntApp = CreateObject("InternetExplorer.Application") With IntApp ' Change file name to suit .Visible = True .Navigate "http://tes...
I would like to know that i have an excel file with 18 sheets and it should be opend with any other versions. for example if i right click on the file and select open with open office the same is being opened. i would like to lock this. ...
I'm trying to use an Excel Macro to reformat a spreadsheet exported using OLE-Automation The following code works OK: Application.FindFormat.NumberFormat = "#,##0.0000000" Application.ReplaceFormat.NumberFormat = "#,##0.00" Cells.Replace What:="", Replacement:="", LookAt:=xlPart, SearchOrder:= _ xlByRows, MatchCase:=False, SearchFo...
I use following class to generate icon for custom toolbar in Excel 2003 from my C# code: public class ImageConverter : System.Windows.Forms.AxHost { public ImageConverter() : base("59EE46BA-677D-4d20-BF10-8D8067CB8B33") { } public static stdole.IPictureDisp ImageToIpicture(System.Drawing.Image image) { ...
When the perl code is run the program generates some warnings and terminates. The output is as below: D:\Perl\bin\search tool>perl testa.pl UTF-16 surrogate 0xdb79 at D:/Perl/site/lib/Spreadsheet/ParseExcel/FmtDefault.pm line 81. UTF-16 surrogate 0xdbb1 at D:/Perl/site/lib/Spreadsheet/ParseExcel/FmtDefault.pm line 81. UTF-16 surrogat...
In Excel 2003, when I change Series.Interior.ColorIndex to a value I need, it has no effect. It has an effect only when I first manually change color and then run the macro. Apparently this triggers some update mechanism. Does anyone have an explanation for this? Is there a way to somehow trigger this in the chart?.. I.e. make sure that ...
Earlier I was reading excel file located on file system through Microsoft.Jet.OLEDB.4.0, and that was working fine, But now my client has told me that place excel file into a database table as BLOB column and read that file from that column and hide one workbook by manipulating that memory string directly. Please help me out from this p...
I have an Excel spreadsheet featuring a macro that updates the connection string for a couple of query tables, refreshes them, and then saves a copy of the file. (i.e., "Extract the data for x client into this table, and this one, then save the file so I can send it.") I'd like to expand its capabilities so that it can do this a series...
I''m looking for a vba macro that will make a copy of the current Excel 2007 macro-enabled workbook with the name I specify as an Excel 2003 macro-free document. It should also keep the current workbook open and in the Excel 2007 format (so save-as wouldn't work). I can't figure out how to do the copy operation... ...
I am trying to capture worksheets being copied in to a workbook from another workbook. Workbook_NewSheet event does not trigger when the sheets are copied from another workbook. It is triggered only if the user manually inserts them through (Insert->Worksheet menu option), or when you add a new sheet through VBA as ThisWorkbook.Workshee...
Hello everyone, its a bit confusing to write my idea but ill give it a try. Here is what i was able to do. I have a drop down on my vertical cells, so i have a list of names to pick from which is linked by [name]-> [define] and [data] -> [validation]. what i would like is another vertical cell to populate another drop down depending on t...
Hey all I have a workbook that has a number of cover sheets and then a bunch of sheets at the back that are contain a few graphs. The graph pages are created by copy-pasting one sheet ("MasterFormat") over and over again, changing a few key values each time. The macro originally used to conk out fairly rapidly with a Copy Method of Wo...
I am working with an API that has a report URL call. The report has an "Excel 2003 XML" format option. When that is selected they deliver it as: Content-Type: application/vnd.ms-excel content-disposition: inline; filename="report-name.xls" OpenOffice.org up to 3.0 tries to bring this in as a text import and I'm concerned that Office 2...
I have a formula in a range of cells in a worksheet which evaluate to numerical values. How do I get the numerical values in VBA from a range passed into a function? Let's say the first 10 rows of column A in a worksheet contain rand() and I am passing that as an argument to my function... public Function X(data as Range) as double ...
Is it possible to set a rows height in a formula in Excel? For Microsoft Office 2003. ...
I have an Excel document that has a single column of strings (around 400 rows). I also have a Word document that may or may not have those strings in the Excel document. How can I have Excel do a Find in that Word document for each row in that single column and retrieve the number of times the given string appears? I only have Office 2...