Programming
in [Excel]
|
SaveAs *.txt - Outputting with Text quantifiers Hello, I am trying to export a worksheet as a *.txt file but do not want the text quantifiers to appear (ie. the quotations around the text columns). Here is a snippet of my saveas code: ActiveWorkbook.SaveAs Filename:=mylocation , _ FileFormat:=xlText, CreateBackup:=False Do I either have to chang... 21 May 2010 19:28
launch instance of excel without loading personal.xls Anyone know how to launch excel from a command line with a /switch that will cause excel to NOT launce personal.xls? ... 27 May 2010 20:23
Running formulas with data from mulitple workbooks I need to create a summary report that uses various formulas (count, sum, datedif etc) that pull data from over 900 workbooks located in a single folder. All of the workbooks are formatted exactly the same with the same variables. I want this summary report to have each row represent one workbook with the col... 20 May 2010 16:08
DTPicker controls missing from userform I have a userform with about 20 microsoft date and time pickers. For some reason, I opended the file this morning and all the DTPickers are missing from my userform. I can't even find the control in my toolbox to redraw them. Am I missing a reference, if so, does Excel just delete them from your userform? W... 20 May 2010 22:41
Macro to copy subtotaled data Joel, Your code worked great last month , This month I get an "error 13 TypeMismatch" when I try to run my macro. here is my code the error occurs at "If InStr(UCase(.Range("b" & RowCount)), "Total") > 0 Then" '*********NOTE ADD "TOTAL" TO COLUMN "A" BEFORE EXPANDING AND RUNNING THIS MACRO*********************... 20 May 2010 17:14
Columns("C:C").Value = Columns("D:D").Value not working after addi What is the rest of your code? "Frank" wrote: I cannot figure this one out. I have a simple macro which adds 40 new worksheets and retrieves data on each of these new sheets in column C. Here is where the code fails Columns("C:C").Value = Columns("D:D").Value It works for 15 s... 1 Jun 2010 16:26
Columns("C:C").Value = Columns("D:D").Value not working after adding 16th page I cannot figure this one out. I have a simple macro which adds 40 new worksheets and retrieves data on each of these new sheets in column C. Here is where the code fails Columns("C:C").Value = Columns("D:D").Value It works for 15 sheets but on the 16th, I get the following error message: Run-time error... 20 May 2010 12:48
Reminder - Microsoft Responds to the Evolution of Community Microsoft Office Evolves Community as Part of Office 2010 Launch: As you know, this is a big year for Microsoft as we are launching the latest version of Office. Office 2010 is all about making it easy for you to get and use Office on your terms. Office 2010 lets you work from the office, from home, or at s... 22 May 2010 07:17
Reply to Steve Hi Steve, Thanks, Your suggestion worked for me. Regards pavan SteveDB wrote: Bob,If you're still having this issue, go to the office button at the upper 05-Jun-07 Bob, If you're still having this issue, go to the office button at the upper left corner of the Excel program window. Click on the "E... 20 May 2010 11:40
Setting a reference to the Ribbon I can get a reference to my customised ribbon and store it in a module level variable using the following callback: Public Sub rbxCustomUI_onLoad(ribbon As IRibbonUI) Set mrbxRibbon = ribbon However, if my code gets stopped (eg. due to a bug elsewhere) then the variable holding the pointer to the ribbon goe... 20 May 2010 10:34 |