excel template Results


Page 3 of 31.
Results 41...60 of 619

Sponsored Links:



Hi All,

Before I go and possibly re-invent the wheel here, I have to look into replacing a couple of network printers and I was wondering if any of you had every done that and if you had developed an excel spreadsheet to do a cost comparison.




background:
Words default template is Normal.dot
Powerpoints default template is Blank.dot

We renamed our powerpoint template to Microsoft Offices powerpoint template ie "Blank.dot "
Now each time powerpoint opens our template is displayed.

I'm wanting to achieve the same thing in excel to display our workbook template.

I did a search on the local disk and I couldnt find a Microsoft Office default Excel template. eg named
Workbook.xlt or Blank Workbook.
except for the excel tGeneral emplates located in C:Program filesMicrosoft OfficeOffice101033

I have a feeling the excels default template works differently to Word or Powerpoint
or do I go about it another way?

diana




What we are trying to figure out is how Excel takes different templates under "C:Program FilesMicrosoft OfficeOffice1033" and organize them into different groups (tabs) on the File|New dialog. We know we can place folders containing Excel templates under the user template folder and the folder will appear as a tab but how does Excel separate the templates contained under "C:Program FilesMicrosoft OfficeOffice1033" into different groups?




I tried searching for this, but I cannot find it in this site. My searching is either too broad or too restrictive.

I want to open a document using an Excel template. The only way I find to do it is to use File New, then go to the sidebar that opens up and choose template.

Is there a command button that will open the templates directly? I think I have gone through the standard commands, but after a while my eyes start to glaze over.

Or, is there a macro that I can use to do the same thing?




Does anyone know how to simulate Word's .AttachedTemplate.Path property for Excel? When an Excel Template is run (eg. through File | New) I want to find out the path to the actual Template file.

Thanks




We are using a VB program to open an Excel template and then using Send Keys to open the VB editor, access the modules, etc. One problem we have run into is that upon first opring the Excel template using the Add method, there is a COM addin the template is trying to find and the COM addin is not there and we are getting a dialog stating that the Addin did not load and the dialog has an OK button. This is preventing our VB code from continuing. We have tried setting DisplayAlerts to False but this does not help. How should this be handled?




Okay, I am close to going crazy. I'm attaching code here that I want to have in an Excel template (a template for an expense report).

The macro (PrintActive) works fine when called from the Tools|Macros menu. I'm trying to set up the template so that each time the template is launched it creates a CommandBar called "Expense Toolbar" that has a button that calls that macro. I tried to do that in the "AddBar()" sub. I added the bar and then added the button to the bar.

Then, I need the toolbar to be deleted when the worksheet is closed.

Grr. This code is a combination of codes, some taken from other WOPR threads and some from a book I have (Microsoft Excel 2000 Power Programming with VBA0.

Any thoughts would be appreciated...it is bothering me, tremendously, that I can't have a toolbar in a template the same way I can in Word!

---------------------------------------------
Private Sub Workbook_Open()
Call AddBar
'calls the AddBar feature to add the toolbar
End Sub
-----------------------------------
Private Sub WorkBook_BeforeClose(Cancel As Boolean)
Call DeleteBar
End Sub
--------------------------------------------------------
Private Sub DeleteBar()

On Error Resume Next
CommandBars("ExpenseToolbar").Delete

End Sub
--------------------------------------
Private Sub AddBar()

Dim Bar As CommandBar

Set Bar = CommandBars.Add("ExpenseToolbar", msoBarTop)
'this puts the toolbar above the workbook

Set btn = CommandBars("ExpenseToolbar").Controls.Add(Type:=m soControlButton)
With btn
.OnAction = "PrintActive"
.Style = msoButtonCaption
.Caption = "Print Active Pages"
End With

With Bar
.Visible = True
.Protection = msoBarNoCustomize
End With

End Sub
------------------------------------------

Sub PrintActive()

Dim oSheet As Worksheet
For Each oSheet In Worksheets

If oSheet.Range("H39") > 0 Then oSheet.PrintOut

Next oSheet
End Sub
----------------------------------------

All of this code is in the "ThisWorkBook" area of the VBAProject for my template.

Thanks in advance...

klyjen




HIya - I code in word & am just beginning to code in excel.
I've have code & modules in an excel template.
In excel in the menu >File
I would like to add a button & my code behind this button.

In ms-word I would goto Tools>Customise>Commands>Macros - displays a list of code >than I would find my code than drag onto the desired location.

However when I do the same in excel - when I click on Macros - no code is displayed.

Is it a different process in excel to create a button & have custom code behind the button.
Please explain how I can do this?
tia - regards Diana




how to I attach excel macro code to an excel button?

the code is in my workbook.

Ive created a new toolbar.

In Word i goto the menu Tools, Customise, Macros - a list of code displays. I drag and drop the code onto my button by design.

In Excel this isnt available or do-able.

Can I have code in an excelbook or does the code need to be embedded in an excel template?

any ideas?

many thanks

diana




I am a weaver who just created an Excel template to calculate yardage (weft and warp) for weaving projects. I also used Excel to create the schematic of the treading drafts (the order in which the combination of loom shafts are used to produce a given design) and the tie up draft (which shows which shaft or combination of shafts are to be tied up to which treadle).

Could Excel also be used to produce the drawdown - the diagram that shows how warp and weft threads intersect in a woven pattern, where to begin/end threading and treadling to create a pattern? If so, can an Excel macro be created that says "if block x has a mark, then fill in another block with blue?" Or using an IF function?




Dear all

I need help with a spread sheet. Please can you help me, I am running office outlook 2010 and 2003.

If you open the excel spread sheet , you will see that I have highlighted some cells in Yellow on the ‘Master’ workbook and some cells in orange.

The information as you can see is ‘test’ apart from the drop down boxes and the number cells. If you want to test it you can insert anything, apart from the drop down boxes.

What happens is that when you type in the information like I have done and click on the ‘Save’ button this transfers all the submitted information in to the ‘Database’ workbook. That process is fine, but when you go back to the ‘Master workbook’ to type in another entry the cell titles in yellow disappear, and the cells in orange stay. What I would like to do is that when you click on save, the data gets transferred to the ‘Database’ and when you go back to the ‘Master’ workbook the cell titles remain ( Yellow ) and the (orange) cells remove the information.

Macro settings need to be set to low, you might need to download the original excel from woodys as when you click on the save button it removes the titles. The titles can be found on the example workbook.

If you can help , that would be great.

Thanks a million.




I am trying to modify the current VBA for an excel template. What I need the code to do is following:

(1) I need it to look in a range of cells (Column E) for a range of account numbers, if the account number is found highlight the cell and provide a message if not found provide message no assets found.
(2) I need it to look in Column D for a range of branch numbers if branch numbers 7450 - 8049 are found, I then need it to look in column E for accounts 500000- 699999. If these combinations are found I need it to highlight the cell and provide an error message. If the combination is not found, It provide a message " No need to check Manufacturing Accounts". Below is my code.

Sub FixedAssets()
Dim msg As Variant
Dim NaturalCell As Range
Dim BranchCell As Range
Range("d18").Select
Range(ActiveCell, "e2000").Select
ActiveSheet.Unprotect

For Each NaturalCell In Selection
If NaturalCell.Value > 160000 And NaturalCell.Value 7449 And BranchCell.Value 499999 And NaturalCell.Value




Hi,

I have a client who is using Exponenciel's Excel Templates in Sage's Act! database. He uses the templates to open up 2 spreadsheets, part filled with data from the database. He then fills in some more details on one of the spreadsheets which he then wants to copy and paste into the second spreadsheet. At the moment, he does this manually but wants to be able to do this automatically via pressing a button.

All very easy, yes? A spot of VBA and Bob's your uncle! Well, no, as the Excel Templates open each spreadsheet in a separate instance of Excel (and Exponenciel tell me that it has to be this way), so they can't communicate with each other via VBA - or can they?

Short of saving the second sheet, then picking it up in the instance with the first sheet (rather messy - much rather NOT save the second one until completed), I can't think how I'm going to do this. Does anyone have any suggestions?

TIA

Keith




I have a computer that will open Excel just fine, but it treats Excel like it is opening it for the very first time, and the CD informational box comes up, as though it would request the CD to finish, but it doesn't...it continues to load some files and it works just fine and opens. What file could be missing for this to occur? Also, when I go to http://office.microsoft.com to download excel templates, it says (when I try to download) that Excel is not on the computer. Could this still be the offending missing file from above?
Thanks,
Nannette




I've got data in a parameter query that I want to export to an existing Excel file so that I can run a macro on the data in Excel. What is the best way to get my data from the query to the Excel file so that I can run my macro? Would an Excel template work? Do I need to go from Access to Excel? Or should I pull the data from Access to Excel? Please help.




I have created a database that populates data into an excel template then e-mails the file to various recipients. This template has multiple tabs and the tab the data is written to is the active tab that the recipient sees when they open the spreadsheet. However, I'd like for the recipient to see a different tab when they open the spreadsheet. It seems simple to change this, but I'm at a loss :-(




May I have some advice, please. I have an Access 2000 database data entry form and report for producing client proposals (a report will be printed as the proposal). For each record being input into the table form there is a corresponding Excel workbook that was created from an Excel template with many static worksheets, formulas, functions, etc., for which much analytical work is done in producing figures for a proposal. The workbooks' spreadsheet named "Cost" has the final figures for three of the database table/form fields.

Would it be possible to write a macro program in Access whereby the user is prompted to open the relevant Excel workbook and then the code automatically goes to the spreadsheet named "Cost" and picks up the values in 3 different static cells, F100, G100, and H100 and transfers the data from these three cells to the relevant database fields called, say, COST1, COST2, COST3, respectively?

I've used "frmCommon" before in a Microsoft Word program to open an Excel workbook and was wondering if it can be used in Access code (I've not done any programming in Access!):

On Error GoTo ErrorHandler
Dim strDatabaseName As String
'strDatabaseName = InputBox("Enter the full path name of your data source file, e.g., C:My Documentsdata.doc.")
frmCommon.comdialogSave.DialogTitle = "Open Your Estimate Spreadsheet"
frmCommon.comdialogSave.ShowOpen
strDatabaseName = frmCommon.comdialogSave.FileName

If strDatabaseName = "" Then
End
End If

Any advice on how one would approach this task would be much appreciated. Many thanks!




I have created a template in Excel for a form to be completed on line. I have created several macros and have placed them as a button on a customized toolbar. The macros have been saved in the current template workbook. However, when I try to send this template, via e-mail, to another computer, the customized toolbar is not included when the document is opened. Is there any way to accomplish this?




Start Excel and go to Page Setup and create the Header or Footer the way you want it. Do a File/SaveAs and in the "Save as type" box select Excel template (.xlt). Save the file as Book.xlt (not Book1). Now, any time you create a new workbook, the header and/or footer should be the way you set them up in the template. If you want this to happen for just some workbooks, then save the workbook as a template by whatever name you want in your Excel templates directory. Now, you can do a File/New and select this template to get these headers and/or foorters.




Hiya - the following support query was raised.

Our offices in Sydney are emailing excel files to our Melbourne offices.
When our Melbourne users receive the excel files - the users cant print out the files as the printer recognises the file pagesetup as letter.
& the Melbourne users have to reformat the excel files
which is time consuming.

The Sydney users have mentioned that they can print the excel files at their end & the page setup is A4.

I'm not familiar with excel...
Is there a setting in excel which substitutes letter paper size to set as A4?
Is there an excel template as in the word template which could be setup as A4 in Sydney but the excel template is setup as letter size in Melbourne?
Sydney have mentioned that the excel file could have been converted /transformed via email (which I doubt very much)

any ideas? Thanks in advance - Diana


Page 3 of 31.
Results 41...60 of 619