Search results for query: *

I have just had Office 2007 installed and am wondering if protection arrangements have changed in Excel2007 (vs 2003). I set the 'protect project from viewing' to yes and add a password and save. Then when I reopen the spreadsheet and select view code I expect to be asked for a password, yet I...

I have imported what is effectively a duplicate set of tables etc. from one db to another. All the imported objects (where duplicate names) are suffixed with a 1 as expected. How can I delete all tables whose names end in a 1, via code. Thanks for looking.

I have the following data: A1:Limit B1:Time c1:Value D1:Factor A2:5:51 4:07 46 0 4:22 66 1 A4:total 4:37 86 1 A5: ?370 4:52 103 1 5:07 115 1 5:22 124 0 5:37 131 0 5:52 135 1 6:07 137 1 6:22 138 1...

I have written some data into say Cell AA12 now I want to write to AB12. How do I code this move to the next column? (I write to the first cell correctly becuase I have previously stored its location (ActiveCell) whilst I fetch the result from a sheet elsewhere; the second write will also get...

When I click a button on sheet wk0, I go to a calc sheet where I eventually click a submit button to return to the original sheet (Wk0) and cell, setting the calculated value in the cell. This works OK with a single sheet because I hard code the sheetname (Wk0) for the return path, but I now...

I have an excel spreadsheet which contains 3 lists on the same page, side by side. I have selected any one of the lists and clicked on Data ... Form .. and I am able to add or delete entries in the correctly selected list. I want to be able to just click on one of 3 buttons (one per list) and...

(1)When I extract the fileinfo (by code) from a set of files in a directory, the date format on the extracted list changes from dd/mm/yyyy (as shown in explorer) to mm/dd/yyyy when I write the fileinfo data into my spreadsheet. (2)'Date accessed' is only ever shown as a date plus 12:00, even in...

Is it possible to set some sort of time/date limitation on a spreadsheet, after which time access would be barred (unless a password is entered to restart the period)? Thanks for looking....

I have a command button on one sheet of a workbook which causes some sorting and other activities when clicked. I need to get the code to run once when I first load/open the workbook. I have tried setting the AutoLoad property of the command button to true, but this does not seem to do...

I have used some sliders in my spreadsheet and want to protect most of the spreadsheet from manual change. The spreadsheet includes a linked graph, some sliders for setting parameters and the usual mix of formulae and text. Even when I set the slider property to 'not locked', setting the...

If I want to refer to a button on a particular sheet from a module, how do I preface a:- If CommandButton2.Caption = "Hello" then ...statement? 1) If sheet name is say Sheet1 2) if sheet name is say a variable like WeekEndingDate 3) or do i use say ... Sheet33(WeekEnding12Jul2009).. (this is...

I have an Excel workbook with several sheets. Each sheet has a button on it to hide (all but the next 6) or show (all) sheets within the workbook. I have added code to each button to do this, but I thought I could simplify my maintenance if I stored the code just once (on the master sheet...

I have dates in the format of 200804; 200712 etc meaning year 2008 month04; year 2007 month 12 etc. How can i get these to read as Apr 2008; Dec 2007? I need to do the conversion in sql, but if you can help me in access I might be able to tranlate the solution?

I create a new worksheet based on the currently active sheet's name eg wc08Dec08 plus 28 days gives wc05Jan09 etc. If the new name already exists, I get a warning message, the macro fails and a new sheet called eg Sheet 1 is created. How can I write an 'if exists statement' to capture this...

I create a new worksheet based on the currently active sheet's name eg wc08Dec08 plus 28 days gives wc05Jan09 etc. If the new name already exists, I get a warning message, the macro fails and a new sheet called eg Sheet 1 is created. How can I write an 'if exists statement' to capture this...

I have a spreadsheet with sheets named wc14jul08 then wc11aug08, etc These are a 4-weekly timesheet series with carry-over between sheets. I would like to generate a new sheet automatically with the new period name as in this case 11aug08 + 28 days ie wc08sep08. I have some incorrect code to...

I have 3 spreadsheets, YTD Jun08.xls, YTD May08.xls and ONLYJun08.xls. I need to subtract YTD May08 from YTD Jun08 to get ONLYJun08 for each of the cells in the spreadsheet. This I can do. Howvwer next month I will need to do the same thing with YTD July08 and YTD Jun08 to generate ONLYJuly08...

W98SE. I open windows explorer. I select (any), say the F: drive and right click to get the menu up, where I choose either Properties or Sharing (all other options are unaffected). .. Then I get a message saying that explorer has encountered a problem and is closing. Happens consistently, been...

Excel 2003 again.... I paste some dat into a blank spreadsheet. The data looks like 6s3 g7w 6e4 etc It get shown as 6s3 g7w 6e+4.00000! Another example .. I paste in 0914 5678 and 914 I get 914 5678 and 914! Excel 2003 does this never had it before with 2000/97. It seems to be trying...

In Excel 2003... I have some numbers in cell a1-a10 say, and some numbers in cells B1 - b10 say. I have a formula in c1 - c10 which compare the two numbers in pairs ie a1 vs b1 etc. C1 = a1-b1 etc. Well that seems easy enough.... Now I paste into b1-b10 some new data and recalc to get the new...