Pages

Search

Excel Help Forum - Excel Programming / VBA / Macros: Trouble with an algorithm. Multiple data sets based on date.

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Trouble with an algorithm. Multiple data sets based on date.
I have looked into several different ways of solving this and have not been able to identify a solution as of yet. I have attached an example of the kind of data sets that I am working with as well as an example of the algorithm which I am currently using to analyze these data. The information is...

Excel Help Forum - Excel General: viewing pictures in excel

Feed2Mail notification - new post on Excel Help Forum - Excel General
viewing pictures in excel
This may be a simple issue but it has me stumped. Suddenly when I open excel files, pictures are no longer displayed. Some had been inserted from a tiff file but others had been pasted in. For the inserted pictures there is the message: "The linked image cannot be displayed. The file may have been...

Excel IT Pro Discussions Forum: Comments don't stay with row in external data table upon refresh

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Comments don't stay with row in external data table upon refresh
I have a table of data obtained via query from an external ODBC data source. I've added a column at the right where I make comments. When I refresh the table the comments do not stay with the original row. Can anyone explain why and how to fix this?

Excel Help Forum - Excel Programming / VBA / Macros: File System Object Issue.

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
File System Object Issue.
Greetings: The code below is used to copy a folder and all its contents. It works great and is quite fast when run across a local drive, and even when run across a shared drive close to me in the network tree, if I'm using the right term. The problem is that when I run it across a shared drive...

Excel Help Forum - Excel Charting & Pivots: Use of data from drop down menu and date ranges for pivot table

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Use of data from drop down menu and date ranges for pivot table
Hello, I'm new on the forum and appreciate the help. I created a weekly marketing count report in Excel 2004 (Mac) that counts new prospects sorted by marketing source (where they heard about us). The marketing sources are on a drop down menu to make it quick and easy for our staff members to add a...

Excel Help Forum - Excel Programming / VBA / Macros: Running a macro when the workbook name changes

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Running a macro when the workbook name changes
I have a macro that reads Workbook 1 and puts certain info into Workbook 2. The problem is that Workbook 1 changes its name depending on the week we're in. Workbook 1's name right now is Consolidated 2012-08-18 to 2012-08-24 V2.xls but as you can tell, that's from August. Workbook 2's name is...

Microsoft Word - subject - line spacing in Word 2010

Microsoft Word - subject - line spacing in Word 2010


subject - line spacing in Word 2010

Posted: 25 Oct 2012 09:32 AM PDT

I am a traditional touch typist.   I am used to using the Enter key to move down to the next line - the original position for the "return key" on the traditional typewriter.   I have tried to use this to move down one line when entering an incomplete line of text but I find the next line of entry is double space between lines.   The single line entry works fine when entering a full line of text as the system automatically finds its way to the next line but how can I move down only one line space to enter text which does not fill the space - margin to margin.   For instance - entering an address which is obviously not going to spread across from margin to margin.

I cannot change the habit of a lifetime as a traditional typist and need to be in control of line spacing of my own choice - not what the computer and Mircrosoft thinks I need.   Please give me the option of using my keyboard as a traditional typist and leave the gismos to those who are not keyboard savvy.   Is this too much to ask.   Please tell me how to turn off the facility which is turned on to accommodate the new generation and let me decide when I want single line spacing and double ( by the time honoured method of pressing the return key twice.

 

 

 

 

 

Custom Template location of Word in Office 2013

Posted: 25 Oct 2012 06:10 AM PDT

Where can I find my custom Word templates in Office 2013?

Word 2007, I cannot view the full content of the first page of a document when in the print view but when in full screen view i can see the full contents of the first page of the document

Posted: 24 Oct 2012 03:29 AM PDT

I have a few documents in word 2007 that once opened i cannot see part of the contents on the first page in the print view (default), i can see the full content of the second page fine.

 

When in full screen view i can see the full content of the first page fine.

 

I need to edit these documents but in full screen view i cannot make the changes i need to.

 

Does anyone have any ideas?

 

Office SP3 installed, and latest compatability pack has been installed.

Word 2010 Mail Merge - missing for every fourth record by clicking Preview Result

Posted: 23 Oct 2012 11:48 PM PDT

Hi, I have done the mail merge by inserting the <<NEXTRECORD>> field.  It shows me first three record on page one.  Record number  forth, eight, twelve etc. are missing.  However, record number 5, 6 & 7 are shown on page two and record number 9, 10 & 11 are on page three and so on.  The following is the format that I created.  Please advise.  Thank you.

«CUSTOMER»

«cust_add_1», «cust_add_2», «cust_add_3»

«Cust_add_4» «Cust_add_5» «Cust_add_6»

«go_1_name»

«go_1_add_1», «go_1_add_2», «go_1_add_3»

«go_1_add_4» «go_1_add_5», «go_1_add_6»

«jt_1_name»

«jt_1_add_1», «jt_1_add_2», «jt_1_add_3»

«jt_1_add_5» «go_1_add_5», «jt_1_add_6»«Next Record»

 

«CUSTOMER»

«cust_add_1», «cust_add_2», «cust_add_3»

«Cust_add_4» «Cust_add_5» «Cust_add_6»

«go_1_name»

«go_1_add_1», «go_1_add_2», «go_1_add_3»

«go_1_add_4» «go_1_add_5», «go_1_add_6»

«jt_1_name»

«jt_1_add_1», «jt_1_add_2», «jt_1_add_3»

«jt_1_add_5» «go_1_add_5», «jt_1_add_6»«Next Record»

 

«CUSTOMER»

«cust_add_1», «cust_add_2», «cust_add_3»

«Cust_add_4» «Cust_add_5» «Cust_add_6»

«go_1_name»

«go_1_add_1», «go_1_add_2», «go_1_add_3»

«go_1_add_4» «go_1_add_5», «go_1_add_6»

«jt_1_name»

«jt_1_add_1», «jt_1_add_2», «jt_1_add_3»

«jt_1_add_5» «go_1_add_5», «jt_1_add_6»«Next Record»

 

"how can I save an MS word file that is not responding"

Posted: 19 Oct 2012 05:30 PM PDT

The file is open and just not responding

How can I insert a comment attached to two or more non adjacent segments of text that have been selected?

Posted: 19 Oct 2012 02:39 PM PDT

In microsoft word in order to insert a comment I must first select some piece of text.
I want to insert a comment that is related to chunks of text that are not adjacent, but if I select texts and use the "new comment" command this comment gets attached to the last selected chunk of text.
E.g: in the following text, bolded words represent selected words.

Dogs are the most friendly animals in the world ...
... (more text, probably not related) ...
Cats are so repulsive that ....

Then, I click on "new comment" and the bubble shows up but gets linked just to the last selected piece of text. However, what I want is the comment be linked to both words, for example to say: they both are mammals.

Formatting a section footer in a Word Macro

Posted: 19 Oct 2012 02:10 PM PDT

I am trying to create a macro that inserts a new section into a word document changes the new section to landscape and format the header and footer of the new section.  The macro records OK but when  it runs it formats the page number (by changing the tab setting) in the previous section.  I cannot find a way to stop this.  The formating is done after unlinking the header and footer from the previous section

 

The logic is:

Insert section at cursor

Change orientation to Landscape

Edit new section Header and unlink it from the previous section

Move to Footer

Edit new section footer and unlink it from the previous sectiion

Change the right align tab from 6" to 9" (basically right aligning the page number in the landscape section) - its this bit that adjust the footer in the previous section when the macro runs.

Close footer and return to the main document in the new section.

 

Can anyone help me with the necessary code to make the macro adjust the correct footer tab settings?

 

Thanks

Is there a way to link page numbers in TOC to headings on other pages?

Posted: 19 Oct 2012 12:41 PM PDT

 If headings can be linked, can/will page numbers self correct when changes are made? If so, how is it done. I have Office 2010.

What free products can I use to work on a Word document?

Posted: 19 Oct 2012 10:44 AM PDT

Split From: Install error with Office Customer Preview on Windows XP

what can i use? do you have any other free word products just need it for a couple  of days to do a paper

How do I change the tab options to hide or show as drop downs?

Posted: 19 Oct 2012 10:36 AM PDT

I want to use screen capture with minimal interference from ME Word. I don't want the File, Hone, Insert ... drop down options to show on the screen as they take up too much space. In View, "Full screen" is too narrow (and obviously not full screen) and I just don;t see any option to achieve what I want.

Data collection feature?

Posted: 19 Oct 2012 10:06 AM PDT

Something came up before when I was saving a document, asking about sending data to Microsoft? NOT to do with error reports. I don't remember the name of the feature, but I think I hit never ask me again. I want to know how private my documents actually are. Does anyone know the name of the feature and what information it actually takes? Would it make all content in a document available if I had clicked yes? And if so, how I can turn it off for sure?

Two active cursors in a MS Word table

Posted: 19 Oct 2012 09:46 AM PDT

In a MS Word table I have two active cursors showing up.  When I do something with one the action is repeated with the other.  For some reason the text has been mirrored.  Any thoughts?

My Microsoft Word and Excel starters won't open.

Posted: 19 Oct 2012 08:30 AM PDT

They were both working fine until yesterday. Now it says "cannot open Microsoft Word" or "cannot open Microsoft Excel"

Formatted Autocorrect entries will not save.

Posted: 19 Oct 2012 08:18 AM PDT

When I put in plain text entries into my auto correct 2010 Word, they always save when I close out of Word.  When I put in formatted  text in my autocorrect and if I close out of Word they are gone.  As long as I have any kind of Word document open, the formatted text will save, just lose them when I log off or close my Word program.  I need both plain text and formatted text to save in my autocorrect Word 2010. Thanks