First  |  Prev |  Next  |  Last
Pages: 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147
Hiding menu options
Ca anyone help me with hiding menus and options in xl. I managed this in a very early version of xl but can't seem to be able to do it in the version I have at the moment - which itself is a bit long in the tooth (2002) ... 25 Mar 2010 11:30
How can I check a collection (e.g. worksheets) collection to be empty?
I have a function that checks if a worksheet exists by For Next-ing through the Worksheets collection. Function fncSheetExist(SheetName As String) As Boolean Dim sh As Worksheet fncSheetExist = False For Each sh In Worksheets If sh.Name = SheetName Then fncSheetExist = True Next sh End Functio... 25 Mar 2010 10:19
Importing text file into Excel 2003 - C# - QueryTables.Add throws System.ArgumentException
Hi all, I am a newby in Excel programming so my question could be an easy one. I found lots of VB code snippets on this issue but almost none in C#. I want to import in a new Excel 2003 doc a character delimited text file. Here is my code: Excel.Workbook lWB = this.excelApp.Workbooks.Add(System.Reflection.Mis... 25 Mar 2010 10:19
merge all files in sub dirs
Hi I like to merge all data in all excel files in all sub dir''s to 1 big file. ( the data can be on scheet 1,2,3 ...... ) Can you help? Regards Rolf ... 25 Mar 2010 09:09
Savecopy and saveas locking up excel
Hi, The project is running on Excel 2003. The work machines are locked down and users don't have administration rights, so I cant look at permissions etc... The error is limited to only a few, but all seem to be on HP laptops, but not all HP laptops have the problem. The code is basically Workbook_open ... 25 Mar 2010 12:40
Excel 2007 ADO Connection Error
Hi, I'm having an intermittent fault with an Excel 2007 workbook (xlsm) connecting to a Access 2007 (accdb) database. The connection string I'm using is "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & gconTargetDbase & ";Jet OLEDB:Database Password=" & gconPass & ";" where gconTargetDbase is the data... 25 Mar 2010 06:53
Protecting macros
I have a protected sheet with buttons assigned to macros. Howver the buttons are not protected and can be reassigned by a user using the R mouse menu. Any ideas to help would be gratefully received ... 25 Mar 2010 11:30
UserForm Text Box to display worksheet cell text
I need a way to display the content of my worksheet cell text 'Site Data' B:1 on a UserForm named LocalizerRef. Thanks in advance for any assitance you may render (please try to not laugh too loudly) Bill ... 25 Mar 2010 05:46
Code to update links every 30 seconds
I have a Vacation Calendar which I maintain for a workgroup of about 180 people. Only a couple of people have access to the Vacation Calendar workbook itself. I have created a slave document which has formulas linking to each cell on the Master Document. This slave is accessible to all employees, on 3 computers... 25 Mar 2010 09:09
Array To View Specific Sheet(s)
Using a macro I need to view specific worksheets if they have content. I will always want my "Invoice" sheet and if on the Invoice sheet, cell B12 has a value I want to view the Invoice and Labour sheet. If cell B13 has a value I also want to view the Materials sheet. My macro, shown below, halts at the line... 25 Mar 2010 03:18
First  |  Prev |  Next  |  Last
Pages: 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147