Over 1 million tech questions and answers.

Excel workbook naming

Q: Excel workbook naming

I have an Excel (2010) template from which I need to create separate workbooks for our range of ocean-going vessels.

Requirement 1
Upon loading the template, I need to prompt the user to enter the name of the vessel.

Requirement 2
The name must be transferred to a particular cell, probably A1, in proper case.

Requirement 3
I then wish to save the workbook using the vessel’s name, in capitals, followed by a space, a hyphen, another space and then the rest of the filename – based on the name of the template.

Example 1: name of template Record of voyage.

Example 2: name of workbook OCEAN TRAVELLER - Record of voyage.

Any thoughts?

Read other answers
RELEVANCY SCORE 200
Preferred Solution: Excel workbook naming

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

RELEVANCY SCORE 70.8

Hello Everyone

I am having some difficulties finding a solution to my problem. I am hoping someone can help or lead me to the right direction.

I have a workbook called Data.xlsm, below is a sample:

ID, Name, commission
1 john 1000
2 eric 2000
3 ryan 3000

Now I have another excel file called Temp.xls which looks pretty much the same as Data.xlsm.

ID, Name, Commission
1 john 200
2 eric 300

I need a macro that will read the Temp.xls and grab the commissions and bring them to Data.xlsm. The commissions need to be summed based on ID.

The final Result on Data.xlsm should be as follows:
1 john 1200
2 eric 2300
3 ryan 3000

Any help would be greatly appreciated.

Thank you
 

A:Solved: Excel Macro - Upload Workbook value from Another Workbook based on ID

Just a quick and dirty solution

Make sure you place this in the same folder as your Temp.xlsm file and press the button

It will open Temp
update the data, if a new Id is in Temp it will add the data and set the commission values in Temp to 0 to avoid running it twice.

I hope the code explains itsefl.

Think of a macro of a step by step instrcution as you would say it out loud.
 

Read other 3 answers
RELEVANCY SCORE 70.4

Hello,
I have a master workbook with 20 worksheets. 5 worksheets in the worksbook are distributed to field reps, but the remaining 15 worksheets are not. What is the best practice for receiving the 5-worksheet workbook from the field rep and importing the data into the 20-worksheet master workbook? If I merely use Copy Sheet I am able to copy the worksheets into the master workbook but then I have to remove the pathname references in each of the copied worksheets in order to map the data in the master workbook - which is quite cumbersome. Suggestions?
 

A:Populating data from one Excel workbook to a master workbook

Hi jpirhalla, welcome to the forum.

Have you tried moving the sheets over. Dragging the sheet from the field reps back into the now-15-sheet book?
 

Read other 2 answers
RELEVANCY SCORE 68.8

I have two workbooks that I am using and I am trying to add one cell's data to another cell in another Excel workbook. It used to be as simple as beginning to "add" another cell's data(from another workbook you just migrate to the other workbook) into a different workbook. It isn't working like it used to in Excel 2003. Cant' speak of it for Excel 2007 as I never had it.

Any thoughts on why it won't work? Any way to make it work?

A:Excel 2010 - Workbook to Workbook Reference?

  
Quote: Originally Posted by Lewiedude


I have two workbooks that I am using and I am trying to add one cell's data to another cell in another Excel workbook. It used to be as simple as beginning to "add" another cell's data(from another workbook you just migrate to the other workbook) into a different workbook. It isn't working like it used to in Excel 2003. Cant' speak of it for Excel 2007 as I never had it.

Any thoughts on why it won't work? Any way to make it work?


Merging Data from Multiple Workbooks into a Summary Workbook in Excel

Looks like it's possible.

Also I would look at the DATA Tab under DATA TOOLS - CONSOLIDATE.

Read other 3 answers
RELEVANCY SCORE 66.4

Hello, advicer
I do not understand why sometime I cannot copy a range from a workbook to another workbook in EXCEL (but I can if i paste the range in the same workbook). My PC is in the network of the company using WinNT 4.1. Please help me
Many thanks
Qan
 

A:Excel: Cannot Copy from Workbook to Workbook

Read other 7 answers
RELEVANCY SCORE 60.8

Hello,

I've been working on a certain workbook and everytime a try to save it an error occurs:

Microsoft Excel for Windows has encountered a problem and needs to close. We are sorry for the inconvenience.

AppName: excel.exe AppVer: 9.0.0.2719 ModName: excel.exe
ModVer: 9.0.0.2719 Offset: 002aa2b3

HELP !!!

Thanks

Mark R

A:Excel 2000 .. When saving a certain workbook excel crashes

Hi, try running a repair from control panel>click on MS office and run change or repair if I remmber correctly.

Read other 1 answers
RELEVANCY SCORE 59.6

I have a workbook located on \\server\servershare\type2015
file name: TYPE.xlsx

how do i write the path of the table name in my query.

Any suggestions?
Thanks.
 

Read other answers
RELEVANCY SCORE 58.8

Hi everyone,

I have a question regarding the Book1 naming of excel when it opens a new workbook.
I looked around a bit but didnt find a direct answer. In some of my macros I open a new workbook and work with that, since im working with that macro, I most of the time have no other excel sheets open but when I have and I allready opend a new workbook the one that my macro opens is gonna be named Book2 and thats where the trouble begins. Is there a way to change the name of the newly added workbook without calling it by its name in the code. (something like Newylcreatedwb.Rename )

Thx, Stefan
 

A:Problem naming excel

Read other 14 answers
RELEVANCY SCORE 58.8

At the moment, I am creating a spreadsheet that can manipulate .csv files, mainly creating charts from them. I am making this as generic as possible, and at the moment have a problem with naming the data series. All the files that this spreadsheet will work with are in the same layout - the series names are in row 1. However, I don't know how many series there will be. This would be fine, except the series names are numbers, meaning that if I include them in the range for te spreadsheet, Excel plots them on the chart instead of using them as series names. Here is the code:
Code:



Sub CreateRelevantCharts()
Dim basebook As Workbook
Dim mybook As Workbook
Dim i As Long
Dim file_name As String
Dim filepath As String

file_name = Worksheets("Input_data").Range("d8").Value
instrreturn = InStr(1, Worksheets("Input_data").Range("d8").Value, Dir(Worksheets("Input_data").Range("d8").Value), vbBinaryCompare)

filepath = Left(file_name, instrreturn - 1)

Application.ScreenUpdating = False
With Application.FileSearch
.NewSearch
.LookIn = filepath
.SearchSubFolders = False
.FileName = "relevant*.csv"
If .Execute() = 0 Then
MsgBox "No relevant data found"
Else: Set basebook = ThisWorkbook
For i = 1 To .FoundFiles.Count
FileName = .FoundFiles(i)
If InStr(1, FileNam... Read more

Read other answers
RELEVANCY SCORE 58.8

I have a remote user who is quite Excel savvy. She has used an existing workbook as a template for a new one and when she tried to alter a named cell she ran into problems. I talked her through the process of deleting the old cell name and adding a new one but a formula that referenced the named cell failed to work. I suggested she save and close the workbook and reopen it. This seems to have done the trick but she'd like to know if there's an easier way to do this for future reference. Is it simply that this process has to be followed if a sheet or book with a named cell is to be altered in this way?

Thanks in advance for any help you give.

N03L.
 

A:Naming cells in Excel

Some names are used in multiple worksheets, which is just plain bad form. Might what to choose that Show Dependents before renaming named ranges too.

Why delete the old name? Why not just add the new one? A cell can have two names.
 

Read other 1 answers
RELEVANCY SCORE 58

Hi

I am developing a sheet with circa 130 excel tabs and need to control the names of these from an index sheet.

So that if I change the intended tab title on the index page the appropriate sheet name will change automatically.

I have read previous posts but have not been able to get suggested solutions to work

Any ideas - thanks
 

A:Solved: Dynamic Excel Tab naming

Read other 8 answers
RELEVANCY SCORE 58

Hi to all,
I am using Windows XP, and have recently upgraded my Office 2000 to Office 2007
Working on Excel, I have named a few ranges in the NAME BOX (next to the formula bar) What is the easiest way to edit the name of the range or to clear the name of the range, without disturbing the contents of the range. I looked in the Help files, and was unable to find an answer.
Thanks
 

A:Naming ranges in Excel 2007

Hi there,

Click on the Formulas tab. In the Defined Names group, click on the Name Manager button. Find the defined name, select it and click Delete. That's it! Voila!
 

Read other 2 answers
RELEVANCY SCORE 58

So I have 3 sheets, the first 2 with just text (people's names) in column A going down. Both sheets have the same data, just in different, specific orders going down the column. In the third sheet I want to be able to return the row number that each specified text (person's name) appears in within the other sheets.

For example, in sheet 1, the word "Matt" might appear in A2, but in sheet 2, it appears in A8. On sheet 3, I want to show which rows "Matt" appears in on the other sheets. (2 & 8, respectively) The "2" and "8" would be displayed in separate cells.

My first thought was to assign names to each row based on what the text is in column A, then do something like =ROW(Sheet1!Matt). This is easy for just doing a few, but I have over 500 rows I'd like to name and multiple sheets to do it for. I'd need a function that does RowName=TextInColumnA. Is there a way to streamline this naming process?

If there is a completely alternative solution that is fine also.
 

A:Naming/referencing many rows in Excel

I would use the match function, its nice and simple.
 

Read other 1 answers
RELEVANCY SCORE 58

Help, I have a VB macro that creates a chart in Excel and obtains data from within another spreadsheet within the same workbook. The issue is that everytime I close and re-open the file and try to run the macro, the chart name changes and I get an error message. Is there a way to name the chart and call it up so the name will always remain the same, or how can I consistently call up the same chart. Obviously I am a novice, self-taught, programmer but I would really appreciate any help. Here is the code.

Sheets("Chart1").Select
ActiveSheet.ChartObjects("Chart 24").Activate
ActiveChart.ChartType = xlStockHLC
ActiveChart.SeriesCollection(1).XValues = FloatDates
ActiveChart.SeriesCollection(1).Values = FloatLows
ActiveChart.SeriesCollection(2).Values = FloatPriceChart
ActiveChart.SeriesCollection(3).Values = FloatHighs
ActiveChart.SeriesCollection(3).Select
 

A:Naming Charts in Excel 2010

Hi, welcome to the forum.
I think this link will be helpful

http://office.microsoft.com/en-us/excel-help/rename-a-chart-HA010223127.aspx
 

Read other 1 answers
RELEVANCY SCORE 57.6

Client has SharePoint 2010 project server.
When the user clicks on a Excel file, the file open in the browser and when the user click on "open in Excel" we receive the below message 
"To open this workbook, your computer must have a version of Microsoft Excel installed and your Web browser must support opening files directly from Excel in the browser."
Below is the browser version 


However when the same is tried/accessed through a browser deployed on a dev machine, it works normally. Below is the version of the IE on the DEV server

What is causing this to happen?
Is there any tool to check the difference between the IE settings on my Desktop and the dev box.

Satyam....

Read other answers
RELEVANCY SCORE 57.6

Can I rename the column headings in Excel? I was able to insert the name of each column in the first row and then freeze that row which works for now but I would like to insert a name at each column heading so when the data base is printed I don’t have that A,B,C column heading showing. I do want the row numbers printed though.
 

A:Solved: Naming column headings in Excel

Read other 8 answers
RELEVANCY SCORE 57.6

Good Morning,

I have a 17 page Excel workbook. 15 sheets are for entering materials etc for quotes. One sheet is for gathering final pricing, lead times etc from the 15.

The 1st sheet is for customer info, part numbers, etc. I am trying to make a macro that will automatically transfer each of up to 15 part numbers to their sheet tab and to position B2 on the same sheet. If I have 3 part numbers in this sheet (A, B, C) I would like sheet 1 to be "A" in the sheet tab and in position B2, Sheet 2 to be "B" in the sheet tab and in position B2" etc.

Thanks in advance.
CFLager
 

A:Solved: Naming Excel Sheet Tabs

Read other 16 answers
RELEVANCY SCORE 56.8

I am trying to utilize data cells on a sheet to name the worksheet tabs that follow it. I found a previous post asking for basically the same thing, however I was unable to follow the code suggestions that worked for that person. I have attached the spreadsheet I am using which will allow you to better understand what i'm trying to accomplish. In the file I am trying to name Tabs 2 - 9 using whatever data is entered into the first sheet (Data) cells B-6 through I-6. These will be dates entered into the data sheet and the dates would then appear as the name of the subsequent tabs. Thanks in advance for any advice you may be able to offer.

-2bit
 

A:Solved: Naming Excel Tabs Using Data Cells?

Read other 13 answers
RELEVANCY SCORE 56.8

My O/S is Windows Vista and I am running M/S Office 2000 Professional. In the past when using Windows XP I have been able to change which workbook opens when I open Excel. Now with Vista, I have designated 2 different workbooks to open when Excel begins however I cannot delete them form the Excel XLS folder. When I delete them, the screen shows that they are gone however when I strat Excel afterwards, they are back! How can I dlete them and install a new workbook. The standard process shown in the Excel help files is not working. Thank You.
 

A:Excel Startup Workbook

Closing duplicate...........replies here: http://forums.techguy.org/business-applications/672809-revise-excel-startup.html
 

Read other 1 answers
RELEVANCY SCORE 56.8

Hello guys.
Please guide me through building my own tool in Excel.
I need to have workbook WK 1 with macro to modify another workbook WK2 which already have macros in it.
That is my plan : WK1 should have several command buttons first is to find person by ID from WK 2 , copy entire row with persons details to WK1 list 1, another button same but copy entire row to WK1 list 2, than when both lists created, I must have third command button which will : for each person in List1 WK1 will change value in cell 1 in WK2 from none to 1 and cell 10 enters =today date, for each person in List2 WK1 will delete value in first cell of the row in WK2.

I am keep loosing the track of what would be most simple way to do those steps, WK 2 file name is changing every day with date in beginning of the name of file,
 

A:Need help Excel 2 modify other workbook

Read other 13 answers
RELEVANCY SCORE 56.8

When I attempted to save an Excel workbook, I couldn't because the file name had changed to a number. What should I do?
 

A:Can't Save Excel Workbook

Read other 7 answers
RELEVANCY SCORE 56.8

Tech Support Guy,

I have a question regarding linking two Excel (I am using Office 2003) workbooks and varying worksheets.
Here's what I want to do, using a macro, create a link to a cell in workbook A/worksheet X to workbook B/worksheet X (where X is variable).
Now creating a link is easy, except I want the "link" itself to appear in workbook A.
I tried the following:
Workbooks("Workbook A.xls").Worksheets(Worksheet A).Cells(6, 4).Value _
= Workbooks("Workbook B.xls").Worksheets(Worksheet A).Cells(57, 3).Value
However, Excel places the value instead of the link in the cell. I want both, meaning, you see the value in the cell, but when you highlight the cell, you see the link to the 2nd workbook.

I have also tried the the following:
Workbooks("Workbook A.xls").Worksheets(Worksheet A).Cells(6, 4).Value _
= "='[Workbook B.xls] Worksheet A '!R57C3"
This gets me what I need except as I mentioned, the worksheets vary and I have not been able to figure out how to do use a variable worksheet name in this example.
I appreciate your help in solving this problem
Take care,
RJ
 

A:Excel Workbook Question

See if using the indirect function is the solution?
 

Read other 1 answers
RELEVANCY SCORE 56.8

Hi,

I am using Office 2013. I have a workbook which has to be shared. I want to protect it in a way that none of the options can be changes (like I have enabled 'track changes'. 'highlisght changes from users' etc). I do not want that someone turn off the 'track changes' option or as a matter of fact any other option.

They, however, should be able to edit the workbook. Is it possible?

I tried searching but could only see an option to protect workbook structure but noes not protect options.

-regards
 

Read other answers
RELEVANCY SCORE 56.8

I have a shared workbook that when some people open it the formatting does not show the same. Example I have hidden columns, but they don't see them hidden
 

Read other answers
RELEVANCY SCORE 56.8

I have two workbooks I'm trying to combine in a VBA macro. The first excel spreadsheet is just simply a sheet of 30 columns of data and 5k rows. It adds a new row every day.

The second sheet will be the model with the macro. I would like to write a script that will use a sort of vlookup to the data sheet to pull in specific parts of the datatable instead of searching through the whole big sheet.

For example, see attached. The Model tab lets you input a date or dates in the C column and then it would have to somehow search another WORKBOOK, not within this one as the example shows (for simplicity). Any ideas would be much appreciated.
 

A:Call Excel Workbook in VBA

Read other 9 answers
RELEVANCY SCORE 56.8

I write a few macros for other users, and right now I just request that they rename the workbooks each month (or however often they run it) to the same names and then offer a reminder at kick-off. Something like:
Code:
If MsgBox("Are the workbooks saved as 'Workbook_1.xlsx' and 'Workbook_2.xlsx', and are they both open?", vbYesNo) = vbNo Then
End
End If
Windows("Workbook_1.xlsx").Activate
Range("a3").Select
Etc, Etc
Otherwise, I don't know how to make changes or run actions based on workbooks whose names might change. But is there a better way? I've had some people - those least familiar with automation - forget to rename, ignore the message, and then call with problems. Perhaps there's a way, instead, that asks them to name as variables whatever the sheets are called, though this might require some hand-holding, such as a list of what workbooks are open? I don't know. I'm open to suggestions - just putting it out there.

Thanks!

Windows XP
Excel 2007
 

A:Excel VBA: Prompt for workbook?

Read other 10 answers
RELEVANCY SCORE 56.8

Howdy, kinda new here. Anyway, I've got a doozy I can't seem to figure out. We just installed dual-monitors and now Excel is coming up saying "Not enough resources to display completely." It does this even when Excel is just started, with the blank, new workbook. There doesn't seem to be any screen real-estate issues since there's now double the screenspace. Any thoughts or ideas to try would be greatly appreciated.

-Ted
 

A:Not enough resources for Excel, even with a new workbook.

Read other 13 answers
RELEVANCY SCORE 56.8

Hi,

I am working on an Excel 2002 report. I need to be able to create a copy of the workbook, strip it down a bit (for uploading purposes), and let the user save it as he/she pleases.

Is it possible to make an active copy of a workbook without saving it?
Excel VBA help is not being very "helpful" on this matter.

Thank you,
ABentsionov
 

A:Copy Excel Workbook

Hello, welcome to the board!

It is always best if you work from a saved file. This is just generally a good idea. Is there a reason you do not want to save the workbook? You need to save to do what you want. There is a way, but it is more convuluted than just saving your file.
 

Read other 3 answers
RELEVANCY SCORE 56.8

Hi there

Sometimes I click on the X to close the workbook and I accidentally press NO when the computer prompts me to save the workbook since it usually comes up in a yellow box that does not really capture my attention. This usually happens when I'm in a hurry or late at night when I'm half asleep. Is there some code that makes a message box pop up with a message that says in big bold letters "YOU FORGOT TO SAVE YOUR FILE" when I click on the X to close the workbook? If so, this will save me a lot of headackes.

Mario
 

A:Save Excel workbook.

I am no guru, however I did find this in the hep wizard of MS Excel. Hope it is of some help to you.

Save workbooks automatically as you work
On the Tools menu, click AutoSave.
If the AutoSave command is not on the Tools menu, you must install the AutoSave add-in.
How?
Select the Automatic save every check box.
In the Minutes box, enter how often you want Microsoft Excel to save workbooks.
Select any other options you want.
 

Read other 3 answers
RELEVANCY SCORE 56.8

I created an Excel workbook to monitor my investments. One of the work sheets contains a long column of currency values from an annuity investment with each row showing daily values.

Presently, I manually copy the daily value of that investment and paste it into worksheet # 2 that contains all of my investments. Worksheet # 2 daily refreshes, updates and totals all investments.

My question is this: is there a formula that would automatically copy and paste the daily annuity values from worksheet # 1 into worksheet # 2 without having to manually copy and paste? If so, could you please guide me through the steps to accomplish this?

Many thanks for your prompt attention and cooperation.
Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Professional, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM)2 Quad CPU Q8200 @ 2.33GHz, Intel64 Family 6 Model 23 Stepping 10
Processor Count: 4
RAM: 4028 Mb
Graphics Card: NVIDIA GeForce 9800 GT, 1024 Mb
Hard Drives: C: Total - 476837 MB, Free - 414208 MB; D: Total - 114439 MB, Free - 21161 MB;
Motherboard: Intel Corporation, DG43GT
Antivirus: avast! Antivirus, Updated and Enabled

<edited by moderator (etaf) to reduce font size - not required default forum font size is adequate >
 

A:Excel investment workbook

Read other 9 answers
RELEVANCY SCORE 56

I have an Excel macro that opens another workbook. If the macro errors out, how can I close the second workbook that was opened?
 

A:Excel Macro -> Close Second Workbook

Read other 12 answers
RELEVANCY SCORE 56

Hi guys. I am not quite familiar with Excel, so would appreciate some help with this, even if this might seem like a simple question enough to many of you.

I received an Excel file from a colleague for updating of data. There was a dotted border surrounding the whole workbook which prevents any editing of sorts beyond the dotted border.

Is the dotted border a result of my colleague protecting the workbook?

Thanks for the help.

Regards,
Terry
 

A:Dotted border around Excel workbook

The dotted border is probably due to page breaks. Protection is a separate issue -- you can check if the worksheet is protected by hovering over "Protection" under the "Tools" menu.
 

Read other 2 answers
RELEVANCY SCORE 56

I would like to know if it is possible to take my primary workbook (workbookA) and make a secondary copy of it with a different name (workbookB), that will automatically update when workbookA is changed. I need to do this because I will have multiple users running macros that will reference WorkbookA and at the same time the quality department needs to be able to check the workbookB for changes (which will be just be a copy of workbookA). If they open the file that is being referenced by others it will throw errors for the other users.

Is there a simple way to do this without using a reference in every cell?

I am using Excel 2007 on an XP Machine.

Thanks,
Allen Jones
 

A:Create a Reference Workbook In Excel

Is there a simple way to do this without using a reference in every cell?

Click to expand...

That's kind of what I was gonna suggest
 

Read other 1 answers
RELEVANCY SCORE 56

Got a file that I can make multiple updates to, multiple saves. Then I make one more modification and save and.... it just WILL NOT SAVE any more modifications. Not a HUGE file, under 5,000 kB.

Suggestions?
 

A:Excel 2010 workbook not saving...

Read other 13 answers
RELEVANCY SCORE 56

I am copying an excel worksheet from an existing workbook to a new workbook using a macro. The sheet contains a Private Sub. I want the new workbook to have the Private Sub password protected. Is there a way of writing this into the macro of the originating workbook?
 

Read other answers
RELEVANCY SCORE 56

It seems to me that I used to be able to set up my own default Excel books and worksheets. I would set formats, toolbars, footers, etc. the way I liked them then save the sheet as “sheet1.xlt” and the workbook as “book1.xlt”, and put these in the XLstart folder. That way, when I opened a new workbook, or inserted a new sheet, the sheets are formatted they way I want them. But that doesn’t seem to work now. I’m using Excel 97 and Win XP. Before I was using Excel 97 and Win98. Did I miss a cog somewhere? It’s been a long time since I did this and perhaps I missed a step.

Don
 

A:Excel 97 Default Workbook/Sheets

Read other 6 answers
RELEVANCY SCORE 56

Using Excel 2010. I regularly download data from a database which have to be sorted by

column 1 - cell color blue on top, then
column 1 - cell color orange on top, then
column 4 - value, from newest to oldest

the data is always downloaded automatically to a workbook named "ABC", and the worksheet is always automatically named ABC#, with the # changing automatically.

the macro is saved in the personal folder. I tried to record using absolute and then as relative reference. the macro NEVER works when I tried to run in any new downloaded workbook or even I recreated the same data in a new untitled workbook.

the number of columns is always the same but the number of rows varies. there are about (7) cell colors, but only the blue and the orange need to be on top

the recorded macro always indicate the name of the worksheet and workbook on which it was created. is this why it does not work on any other workbook or worksheet?

any help will be appreciated
 

A:Excel Macro Won't Open in Different Workbook

Read other 14 answers
RELEVANCY SCORE 56

I'm a novice user of Excel 2007 at best, but as an intern at a local company, I've been tasked to figure out a way to have a pre-filled e-mail sent when one of our users presses a radio button. I would also need to send along some specific information from certain cells.

The e-mail would be going to a specific person every time, and I'd like for the employees to only have to choose "Yes" in a radio button for "Send E-mail", then have a confirmation window come up before it is sent out.

Is this possible? Does anyone have any code for a similar function?
 

Read other answers
RELEVANCY SCORE 56

Microsoft Excel 2003 - I need help creating a macro that will link a workbook file with hundreds of other workbooks to create a customer list. All my workbooks are in C:\Documents 2007\Bids\BID____.xls. All files begin with "BID". All workbooks are identical and I only need information from certain cells. (i.e. G8, A6, G6, etc.). I want all the information from each file to go onto one row of the customer list - a new file's information on each row. Does anyone know how to do this? I have spent all day working on it and am about to go out of my mind. I would really appreciate any help. Thanks.
 

A:Excel - Need Workbook Linked to Many Workbooks

Read other 16 answers
RELEVANCY SCORE 56

Greetings everyone,

I have a question I am hoping you can help me with.

I create Excel reports, where the first sheet is a Menu and a second sheet contains data. The Menu refers to the second page, and based on which options the user selects on the Menu, a graph on the menu page updates with the relevant information from the second data sheet.

I am wanting to publish this Menu sheet such that it can be accessed and used on a webpage -- therefore, it needs to refer to the second sheet. However, I would like to keep that second data sheet 'locked' so that it cannot be accessed on the webpage at all.

Is this possible?

(PS - I know I have to use Excel 2003 to publish an interactive workbook ... unless anyone has discovered a way to do this with 2007, which dropped this great feature).

Many thanks in advance.
 

A:Publishing interactive Excel workbook - help please

You could make the sheet Hidden or via code XLSheetVeryHidden but the data will always be available.
 

Read other 1 answers
RELEVANCY SCORE 56

Good Day Moderator,
just got to the core... I've problem to open an excel workbook which contain macros from visual basic at run-time. Thats it, I don't know what properties or method that I should used.

For your illustration, perhaps I should write some of them in here ( hope you don't getting bored with this )

dim strFile as String
dim objExcel as Excel.Application

strFile = InputBox("Please input your excel file full path :","C:\")

Set objExcel = CreateObject("Excel.Application")

With objExcel
.DisplayAlerts = False
.Workbooks.Open strFile

MsgBox "Your name is : " & .ActiveSheet.Range("D1")

.ActiveWorkbook.Close False
.Quit
End With

While trying to process the Msgbox's function, it said that "Object variable or With block variable not set", just like if the object has not successfully created.

Do you have any idea with this ? I really don't know what to do.
Thanks a lot for your help and have a nice day

Best Regards.
 

A:Open an excel workbook which contain macro from vb

I don't claim to do VBA, but I dabble.

In the first place, if you are creating this code in an Excel file, I don't think you need to declare Excel as the application at all.

I think you should be creating a workbook object and not an application object.

I just tried it out, and I get that darn Error 429, but I think that's better than what you're getting.
 

Read other 1 answers
RELEVANCY SCORE 56

I have a workbook that I want to share with many people so they can all edit at same time. When I share it, they cannot run macos, it errors out with

"Error 1004 Application defined or object defined error"

Any ideas on how to overcome this?

Thanks!
ASM
 

A:Excel - Shared Workbook Macro

The macro is supposed to create hyperlinks... is this a no no? this is excel 2007...
 

Read other 1 answers
RELEVANCY SCORE 56

hi,

i have a Excel workbook that consist of 3 worksheets and there are some formulas in each of those sheets.

the problem is that each time I open the workbook there will be a "update link" message that appear (pls see the attachment). that's strange 'cause I have never inserted any links before.

is there a way to display all the links that are present in the worksheet and prevent this message from re-appearing?

thank you
 

A:Cannot Find the Links in Excel Workbook

Try Bill Manville's add-in -- http://www.oaltd.co.uk/MVP/MVPPage.asp
 

Read other 2 answers
RELEVANCY SCORE 56

I'm having the dreaded "shared workbook" issues.
 
I have many users at different points in the week complain about issues with a shared workbook. May it be slow to open, slow to save, random crashing, loss of data, loss of changes, I get it all!
 
I've found going to each computer to try to diagnose and/or repair excel is futile. Does anyone have any insight as to how I can get around this? I was thinking either find out how to use Microsoft Access with their workbooks or convincing the management to assign one person in their team to do the excel spreadsheet updates.
 
Your help will be GREATLY appreciated.

A:SHARED EXCEL WORKBOOK CORRUPTION

Just got off the phone with Microsoft which was no help. It seems like there are no fixes whatsoever for this issue. I'm leaning more towards using Access with the workbooks to alieviate this issue. However any help will be appreciated.

Read other 1 answers
RELEVANCY SCORE 56

Hi,

I have Excel 2007 and want to use MS Outlook 2007 for emailing. However, I do not want to email the whole workbook but only one sheet,or sometimes just a small selection and this does not seem possible at the moment.

I can copy one sheet over to a new workbook and then email the new workbook but I wondered if there was a quicker way to do it. I have heard that there are Add-Ons that can be downloaded which allow for only one sheet to be emailed. I found one called RDB Mail but as I went through the procedure I got warnings that it may have been an unsafe site so I did not continue with it.

Does anyone know of a safe way to do this? And, has anyone heard of RDB Mail (I found it on a Microsoft site) and, if so, is it safe?

A:Emailing only one sheet from an Excel workbook

Have no idea about RDB Mail. As for emailing one sheet? Does it have to be as an attachment, or can the sheet be embedded in the email?
If it can be embedded try the following for emailing from Excel:

Step One: Next to the save icon there is an icon that looks like a letter and envelope. Click this icon.
Step Two: Excel will prompt, and ask if you want to send just the active page/current sheet, or the entire workbook.
Step Three: Excel should copy the sheet to a new email message in your default email program.

If the spreadsheet needs to be an attachment? I don't know of any other way than creating a new single sheet workbook as you stated.

Maybe someone else has a tip or clue I'm unaware of.

Read other 6 answers
RELEVANCY SCORE 56

Please forgive me if I am using incorrect terms here. I use Adobe Acrobat/Distiller (Version 5) to convert documents to pdf format. The problem comes when I have a large Excel workbook with 20 or so worksheets (tabs at the bottom of the page). When I try to convert them into pdf (File-Print-Distiller) I get 20 or so files.

First question-Is there a way to convert a multiple worksheet excel file into 1 pdf file? (Without the tedious "insert pages" function I am using right now)

Second question- Is there a way to convert multiple Word documents into 1 pdf file? (Once again without tedious "insert pages" function) Before you ask, no I cannot make all the Word documents into one file.

Third question-If there is no way to do the other two...is there a way to convert multiple adobe pdf into one without "insert pages".

Now since last time I got a bunch of "if it's not broke don't fix it comments" I am posting this statement. "Insert pages" is great and works great to get a couple of pdf files together. Try doing it for over 250 files and see how fun it is.
 

A:How do I print an entire excel workbook to pdf

If the worksheets are all < 1 page "long", then File -- Print -- Entire Workbook worked for me using CutePDF (can be found on Google).

OpenOffice has "Export to PDF" ; it did handle > page-long sheets for me, but baulked at some print settings, so it could depend on how fancy your sheets are (http://www.openoffice.org/).

>> I cannot make all the Word documents into one file.

Are you saying Insert Subdocument doesn't work in your version of Word?

HTH,
Andy
 

Read other 2 answers