Over 1 million tech questions and answers.

Variable Headers in Word 2013

Q: Variable Headers in Word 2013

I have tried following various tutorials online but either I am missing something or the solutions don't seem to work. I need to create a template to allow pre-printed stationery to be used for letters. In word it says you can create a header for the first page which is different to subsequent pages but when I try to set the header, even with the 'different first page' box checked altering subsequent headers alters the first page too. Anyone have a solution that I can make work?

Read other answers
Preferred Solution: Variable Headers in Word 2013

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.)


Good morning,

I recently upgraded from Office 2010 Pro to Office 2013 Pro. However, after the install, all of the office products are showing as <NAME> (desktop) - i.e. Word (desktop), Powerpoint (desktop). Yet, when they are opened, the program is shown as Word 2013, Powerpoint 2013, etc. When I try to pin a file to the taskbar, it pins it under the Word (desktop) program, but when I open that file, it opens in Word 2013.

I am able to pin both Word 2013 and Word (desktop) to my taskbar. I am ONLY able to pin files to Word (desktop), but files only open using Word 2013. Both options open the same program. It is frustrating to have one program pinned just to have files pinned, only to have those files open in another taskbar "tile."
Why are they separate? Is there any way to get rid of one?

Any assistance is GREATLY appreciated!


A:Updated to Office 2013 Pro: Word (Desktop) vs Word 2013

Hi PrimetimeHero welcome to Windows Seven Forums.

It does seem that you have a duplicate set of short cuts to your Office products.

Normally it is best to store your Office product files in your Documents Library, under their various Folder titles such as Word Documents, Excel Spreadsheets etc. This keep them all in the one area for easy location.

Check to see whether you have duplicate copies of the actual files & if so make sure they are up to date & correct & delete one of them. Then delete the duplicate Shot Cuts then open your Documents Folder in your Documents library. Then locate a file in Documents such as Word xxx & if you want to have a short cut to it on your Desktop, right click on it & use Send To (create Desktop short cut).

As your information is not really clear, perhaps you could post back with more info on where your various Office files are actually located.

Below is a screen shot of my Documents Folder to expalin what I have been saying.

Read other 9 answers

So i have been doing some research ever since reluctantly upgrading to office 2013. for the most part the process was painless save for a few minor tweaks the old outlook settings and all my data was picked up seamlessly by the new application.
my problem is that the new version cannot be set to only download message headers in IMAP and worse yet if you use the slider to limit offline data to 3 months or so there is literally no way i have found to locate older archived messages on the server short of directly logging into gmail or downloading years worth of messages in full just to find a single item.
so my main question is this.  would it be possible to write a COM Add-In for Outlook 2013 that forces the old header only behavior or if the feature was completely removed replaces it all together ?

A:Getting around outlook 2013's innability to only download headers in IMAP

The ability to download headers only is available in 2013 only with POP and Exchange accounts. http://www.outlook-apps.com/download-headers-only/
I'm not aware of any add-ins that will enable this behavior.

Read other 3 answers

I am having the exact same problem as in the post "Solved: Can't find Access Query when using Word mail merge." I am using Office 365 so I have the newest versions of both Word and Access.

When I try to mail merge starting with Access (right click the query and export to word merge), it tells me it "Could not find file 'C:\Users\Jeanne\Documents\My Data Sources.mdb'" I have a folder called My Data Sources. And yes, the database I want it to go to is in that folder. Of course the folder doesn't have a .mdb after it. What file is it looking for and why? The Access database ends in .accdb. I found some hint somewhere that that might be a problem, but I can't find how to fix it.

When I start the merge from Word, it finds the database fine, but only tables are listed. The link mentioned in the other post is broken, so I can't check that out.

I feel like I'm saying to my son "I'll see you at home" and he says "I can't find the dog." What dog? We don't have a dog, and I never said anything about a dog!!!

I am getting thoroughly fed up with Access! I am fairly tech savvy and can teach myself to do just about anything in excel just through trial and error or looking it up online, but every little thing I try to do in access gives me all sorts of problems!

A:Solved: Access 2013 Query to Word 2013 Mail Merge

Read other 13 answers

I'm working with a lengthy Word document and have struck a problem that I can't seem to fix. It is necessary that the header be (1) same font as body text, (2) aligned at upper right, and follow the format: author/title/page number.

Everything works fine until the page number reaches 100, then the first digit piles up on the / and I can't find a way to move the number over a space.

I hope somebody out there has dealt successfully with this problem and can help me out!

A:Word headers

Read other 7 answers

How do you insert different headers inside a document?

A:MS Word 2007 Different Headers

Same as you did in earlier versions.
Get in the edit header/footer mode and there you will see the different options.

You are going to need to have the files broke up into the different sections that you need if you are going for more that the "Different first page"

Read other 1 answers

0 4ll ><X0rZZZ

A:Multiple Headers in Word?

Sorry, I don't speak . . . Klingon?

Read other 3 answers

Can anyone advise how to exit having typed in the header text. In previous versions of Word Perfect, a screen top box had an exit tab. In the currect case, accessing the header is ok but after the entry is finished, there does not seem to be any way to return to the normal page. Clicking on the "Insert header/footer" doesn't work as the entry won't resopond

A:Word Perfect 12-Headers

Bill T. said:

Can anyone advise how to exit having typed in the header text. In previous versions of Word Perfect, a screen top box had an exit tab. In the current case, accessing the header is ok but after the entry is finished, there does not seem to be any way to return to the normal page. Clicking on the "Insert header/footer" doesn't work as the entry won't respondClick to expand...


How are you getting out of the program? (exiting the screen.) This is what I found from Word Perfect 12's Help Menu:

In working with Headers or Footers note that they do not display in Draft Mode. The document must be open in Page or Two Page View.

To View a header or footer: Click view and than click one of the following: (Uncheck Draft Mode if checked)


-Two Page

To Switch the document view, click View and than either page or two page.

To Edit the text in a header or footer: (Must not be in draft mode)

Click Insert/Header and Footer

Enable one of the following options:

Header A
Header B
Footer A
Footer B

Click Edit

Make any changes to the text

Click File, Close

If the document is displayed in Page View or Two Pages View you can also edit the header or footer by clicking anywhere inside the header or footer.

To Discontinue a Header or Footer, go to Insert Header/Footer enable the header or footer that you want to change and click discontinue. You can also remove a header or footer by removing its associated code from the Reveal Codes Windo... Read more

Read other 2 answers

Can anyone advise how to exit from a header when it has been completed? Previous versions of Word Perfect had an exit bar which when pressed, saved the header and returned you to the main body of the document. WP12 does not have this feature but there must be some way of doing it.
Also: The guide lines on WP12 are so faint they might as well be absent, Is there any way of making them properly visible?

Read other answers

I am using Word 2003 and I have created a template containing a header/footer combination with my company letterhead information. This was working fine but the problem I now have is that when I open a new document by loading the template the header and footer are not shown. I must switch into them (using View/Header and Footer)
and they then appear. After that they stay visible. Apparently I have accidentally changed something.

My question is whether anyone knows how to have the header and footer visible by default when I open a new document using the template.


A:Headers and Footers do not appear in Word

Read other 6 answers


Sorry if this has been answered elsewhere but Ive looked everywhere cant find the answer.

Is there anyway to have just a header in a document and not a footer?

I know you can have different headers/footers on each page etc and you can leave the footer empty and change how far it is away from the edge of the page but I cant seem to find a way of just inserting a header and no footer at all.

Any help will be accreciated its driving me mad

A:Is it possible to have only headers and not Footers (Word 2003)

Read other 9 answers

I have a short document (14 pages) written in Word 2000. Starting about the middle of the document, and only for a couple of pages before it reverts back to normal, the header somehow goes from being 1/2-inch high to something like 5 inches high. This of course means the first line of text is in the middle of the page.

If I select the offending header and try to adjust its margin with the vertical ruler, the change won't stick - when I release the mouse button the header immediately reverts to its large size.

What would cause this? And how can I fix it??

A:Solved: Headers in Word 2000

Read other 16 answers


I have created three small Word documents. I created the three documents seperately because I couldn't figure out a way to use the headers in the manner I hoped. Basically, I have a Reference Guide, Appendix A and Appendix B. I would like to have one document with those three headers as applicable. Is this posisble?

Thank you in advance for any replies.

A:Solved: MS Word - Multiple Headers?

Read other 9 answers

I have just finished writing a thesis, but have decided to put an auto header on every page (MsWord). So far, as I enter the auto header into the first page, that's all I get. How do I get it to auto header every page?

A:auto text (headers in Word)

Read other 7 answers

I use Word 2002 and need a document with a header on page one, but not on page 2. As advised I use View>Header and Footer>, and then click Layout on the toolbar. As instructed I click Different first page. I've made a template with this header but documents created with this template still have the header on the second page.
I've also tried recreating the document template from scratch and replacing the original, but the same problem reappears.
I attached a zipped copy of this template.
I would warmly appreciate any suggestions.


A:Solved: Discontinue headers in Word

You may be neglecting one extra step. If you choose to have a different header on the first page only, you will need to set up the first page and then the other pages. You may need to go to page two, select Header and Footer and blank out the information for the remaining pages to create a blank header. Then your check in "Different First Page" will use the page one data on the first page only.

There's a good (but old) tutorial here.

Read other 3 answers

I planned to seek help from TSG about finding an easier way of getting into headers in the MSWord 2007. Word had changed rather drastically from the previous version and I found the new version unnecessarily complicated when it came to dealing with headers.

But before posting, I decided to look at the situation very carefully once more so I could describe the issue accurately. Lo, and behold, I discovered the existence of something called the "Quick Access Toolbar." Now maybe you knew all about that, if so, this post is not for you.

Right-click on an empty place on the top menu bar to the right of the menu items (Home, Insert, Page Layout, etc). When you do that, you will see a menu window appear that provides these options: "Customize Quick Access Toolbar," "Show Quick Access Toolbar Above (or below) the Ribbon," and "Minimize the Ribbon" (The Ribbon being the entire collection of menu icons and subdivisions).

In the Customization Window that appears, you can select items from the extensive list of items in the left column and move them to the "to be included" (my term) column on the right by means of a directional arrow betweem the columns in the middle. You can also remove things you don't want by selecting them in the right column and using the directional arrow between the columns to move them back into the "items from which to select" column on the left.

Note that you can change the order of how the s... Read more

Read other answers

An odd request perhaps but I have a document with a header set but I have one page where I don't want the header to show (and no its not the first page as I know I can surpress that one), is that possible to do in a quick and easy way ?


A:Solved: Word - Headers & Footers

One way would be to start a new section with the page (Insert -- Break). But what should happen after the page? (is it the last one? )

Read other 2 answers

Hello Wizz kids,

I have created some word templates. The first page has a header and a footer. I would like further pages to be either totally blank or with only the footer.

I cant seem to work this out. Can anyone help me out?



A:Microsoft Word. Headers And Footers.

Hi Constantine,The easiest way that I can find to do this is to create "Sections" in your Template/Document. By using Sections you can create different Headers or Footers for each Section.Check this link out, you should get the general idea.HTH

Read other 6 answers


I am using Mircosoft Word 2000 and when I try to create headers and footers in my document by selecting view - headers and footers the document opens in print preview not print layout and I am unable to edit the headers and footers.

Can anyone please offer some assistance?

Thank you.


A:Headers and Footers Word 2000

You should be able to change the view in the same area as the footers/headers. Near the top of the pull down menu there are areas that indicate normal - web - print etc. Also at the bottom of your page are buttons showing the different view modes for your document. Hit the normal view and you should be able to work on your headers/footers.

Read other 1 answers

At work, when we send out proposal documents (Word 2002 Office XP) we send them out in two different ways- as paper printouts and as pdfs. My boss is very particular about the company branding so when we send out paper versions they must be printed on letter-headed paper. When we send out pdfs we set up headers and footers that look like the letter-headed paper. Unfortunately this means that whenever we create a proposal we end up editing two documents, one with headers and footers, one without. This is time consuming and has led to differences between the versions in the past.

- Ideally, we would just edit the version with the header and footer, and then be able to hide them when printing onto paper- I can't find a button in Word to do this!
- I've tried to persuade the boss to just print the pdfs onto normal paper for the paper versions, bur apparently this isn't good enough
- I've tried inserting an image of the letter-headed paper as a watermark (which could easily be removed for printing to paper) but even I can see the result isn't good enough quality- it also isn't very flexible.

Has anyone got any bright ideas that could help? I've read on these forums about Master Documents but I don't really understand what they are- could they be the answer?

Thanks for your help

A:Solved: Hiding Word Headers for Printing

Read other 6 answers

In with with headers in MS Word,

How do you set them up so that the first page of the document does not show the header information, (i.e such as a term paper's cover sheet) but the remaining pages show the header?


A:Solved: Surpressing Headers in Word 2003?

Take a look in the Word 2003 Help files under "Insert headers and footers" It has a section with instructions on creating a different first page header or footer.

If your document is divided into sections, click in a section or select multiple sections you want to change. Click anywhere if your document is not divided into sections.

On the View menu, click Header and Footer.

On the Header and Footer toolbar, click Page Setup .

Click the Layout tab.

Select the Different first page check box, and then click OK.

If necessary, click Show Previous or Show Next on the Header and Footer toolbar to move into the First Page Header area or First Page Footer area.

Create the header or footer for the first page of the document or section.
If you don't want a header or footer on the first page, leave the header and footer areas blank.

To move to the header or footer for the rest of the document or section, click Show Next on the Header and Footer toolbar. Then create the header or footer you want.
Click to expand...

Read other 3 answers

So I know this should be very easy. I have a 285-page novel manuscript I'm formatting for submission. I have page numbers that start on the 3rd actual page, which is where Chapter 1 begins. I have a header but it only appears on those first two pages; it stops before Chapter 1. How do I have the header appear on every page of the doc? I googled it but it's confusing....it took awhile to get the page numbering right, because I wanted it to start where it does....I'm afraid if I mess with the header as it is, I'm in for more frustration. A simple step-by-step would be appreciated. Thanks!

Read other answers

A work friend has just told me she has a 34 page document and needs to change the text in the headers in three different "chunks" throughout the document. So, eg., the first 10 pages would read differently to the next 10 pages etc. in terms of what is typed into the headers.

We tried using section breaks and clicking Same as Previous on the H/F floating toolbar but it did not help.

Help would be appreciated.

Thank you - Julie

A:Word 97 changing text in subsequent headers

Read other 8 answers

I am using Word 2010. I created two double sided templates. the first with no colors in the H/Fs. The 2nd has colors in H/Fs.

I took the first no color template and created the one with color. Now when I go to insert a section break at the end of the colorful template (4th section) the old no color footer pops in. It happens when inserting a page break or odd section break. When I insert an even section break I get the current odd footer (but the next page needs to be even).

I tried deleting the old header and footer and replacing them with the correct ones. I also right clicked and selected "remove header/footer" but it didn't make any difference.

Is there a way to clean out these old headers and footers? (I checked they are not in my building blocks for inserting h/fs either). This template will be distributed to multiple authors and it would be better to have nothing appear than some old header/footer design.​

A:Old headers pop up in double-sided Word 2010 file

Read other 7 answers

How do I merge 2 Word docs into one that have different headers and footers without changing them? I am not experienced in Macros, so would prefer a way to do it without getting into that. I am using Windows Office 2007 Professional.

Read other answers


After banging my head against the wall and fighting with Visual Basic to create a template full of fancy bells and whistles for my client, I've come up against a probably simple, but amazingly annoying issue.

When I apply my template to a document, the headers and footers don't appear. I don't understand. (Yes, I click View --> Headers, Footers.) They're not there.

I go back to the template. They exist. I create a new document. They exist. I apply the template to a document with no headers/footers (or in some cases existing headers/footers) and nothing.

If it were just for me, I'd come up with a workaround. But I need to hand this template off to a client who needs to work with it. Cutting and pasting, etc, isn't going to do it.

Surely there is a way to make the headers and footers appear when applying to an EXISTING document.

Thank you so much, in advance, for any help you might provide.


A:MS Word Custom Templates: Headers, Footers Not Appearing

Welcome to the forum. If you post the Word document as an attachment we can better look at it. I think you cannot post attachments until your 7th post or so though. If you mail me the document and let me know on the forum, then I will post it up here for you. Also if you feel uncomfortable posting the document, just post the code instead.

Read other 1 answers

I have had trouble formatting Word 2003 documents so that the header is suppressed on the first page but the footer prints. It is probably some little thing that I am missing. I am a dyed-in-the-wool WordPerfect fan and use Word only as a last resort, so am not familiar with some of the fine points of the latter. To briefly summarize: I have gone to the View / Headers and Footers menu and entered the desired text for the header and the footer. Then I have gone to the Page Layout button and run into trouble there. If I click on First Page different, I suppress printing of both the header and the footer. I have tried choosing "From this point forward" and then entering header text on the second page rather than the first, but either both header and footer are blank on the first page, or if I unclick the box for First Page Different, then the header displays as well as the footer. I will appreciate any help.

A:Solved: Formatting Headers/Footers in Word 2003

Sounds like what you need is a section break. At the end of the first page, insert a section break - make sure you make it a page section break. This will allow you to have different headers for each section. On page 2 (which is now the first page of section 2), enter your header. On the header and footer toolbar, there is a "link to previous" button. It's selected by default, so you'll have to unselect it. The header might have automatically been put onto the first page; if so, go to page one and delete the header. As long as the "link to previous" button is not enabled, this should delete the header on only the first page, leaving you with the footer on all pages. Let us know if you need clarification on any of the steps since you're not used to using Word. Good luck!

Read other 3 answers

Suddenly, Word 2007 does not display the header and the footer of any document. I can see in print preview!

Any idea how to solve this issue?



A:Solved: Word 2007 Doe not Display Headers/Footers

Read other 13 answers

If I open up a link which has a word document, IE 11 will download and open it. If i then leave word open and then go to another link to and try to download
and open up another word document, the window doesn't become active and it sits minimised in the taskbar flashing. If I click on it to give focus it opens and shows the document I downloaded. This is very annoying. Does anyone have any ideas? I have tried
loading both word in safe mode and IE with no addins and still get the same behaviour.

Read other answers


I am trying to find a way to use VBA to copy some information (including text, tables, bookmarks, etc.) out of a Word document and then use it several times in the same document without relying on it remaining in the clipboard the whole time.

Currently what I am doing is cutting the range out of the document, pasting in back in, changing all the bookmark names, and then pasting the range in again (this preserves the original bookmark names for later copying and pasting). As you might imagine, this is not a very quick process when it has to be done over and over again and there are quite a few bookmarks.

Is there some type of a variable that I could use to store this information and then insert it when I need it? I have tried a Range variable, but if I use a range variable for the original and then delete the original, the range variable essentially holds nothing. I need a way to keep all that information in storage.

An additional note. I found that I could paste the contents into an access object frame and this could be later used to retrieve the information, but this isn't a very elegant solution, and I don't want to have to rely on this. Isn't there a comparable data type that could store this stuff?



Read other answers

I have an interesting question...

I'm doing some Word macro programming, and I'm trying to find the Word variable that contains a specific value that I'm looking for...

(Backing it up a little more, in the TrackChanges mode I have changed the font on a phrase- say "The report is overdue." This causes Word to annotate this phrase with a "Formatting" change in the TrackChanges mode. I'm trying to find that specific MS Word variable that annotates that "Formatting" change (I think it may be "FormattedText"...).

That said, what I'm specifically wishing I could do is run my macro on my Word doc, pause the execution of the macro, and then be able to do a "Find" command of some kind (within the macro/debug context) that would allow me to search through the MS Word macro variables attempting to find the specified value (in my case the text "The report is overdue.")- and hence determining which MS Word variable "contains" that value.

Does such a thing exist?

Thanks in advance!!

Read other answers

I made the Easy Transfer using the ET cable yesterday. The files and setting of my old Windows 7 computer are now in my new Windows 7 computer. I have Microsoft Word 2013 on my new computer but it's empty. How can I get the documents from Word 2003 on my old computer to the new one?

I also have a lot of documents on my Works version 9 on the old computer. Can I transfer these to Word 2013? I suppose I could do it all manually but I'm hoping that someone knows of a trick to do the job fast.

A:New Windows 7 computer - how do I transfer old Word to Word 2013?

Word does not contain any documents which could be moved. I assume you are talking about the list of recent documents, shown either when Word is run (1st screenshot below) or later if File > Open is selected (2nd screenshot).

Recent Documents when Word 2013 is launched:
Recent Documents when user selects File > Open:
As Word saves by default to your personal Documents folder, if Easy Transfer had no issues they should already be in Documents folder under your personal user account folder (default location C:\Users\Your_Username).

If you are using the Windows Libraries, you can also find them from Libraries > Documents.

The Recent Documents list populates as you go; you need first open a document in Word on your new computer for it to appear on the list. The same with your Works files.


Read other 1 answers

Hi guys,
I need help to get a variable in a form field and pass it to a macro I created in Word 2003.
My macro is actually doing what the "Find and replace" function is doing. This works without any problem.

What I want to do:
Create one field where the user enters his company name.
Create one button for submit. The company name entered by the user is sent to the macro which will replace "company X" in the whole document.

What I did;
Create the field.
Create the submit button and assign the macro.

What I can't do:
get the variable submitted by the user and send it in my macro.

Hope it was clear enough....
Any help would be appreciated.

Thanks a million!!

A:(Word) Pass variable from field to macro

Read other 10 answers

Hi folks
Please bear with me, I haven't used Windows for a long time now, switched to Linux 2002 so I am a complete newbie in this area.
I need to create a script on a server running Windows Server 2008R2, and I simply can't find good how-tos (googled for 2 days now...)

What I want to do is to automatically move files to a different directory.
The files are sent in via ftp to a ftp-server (OpenSuse), the ftp-directory is mounted in Windows using Windows-services-for-NFS.
To know that the ftp-transfer is completed before the file is moved, a controlfile is created by a script on the ftp-server after a succesful upload.
So, when file " gustav\myfile.txt.dl_complete_02122012 " exists, then move " gustav\myfile.txt " and " gustav\myfile.txt.dl_complete_02122012 " to " D:\transport\gustav\ "
Create the directory " D:\transport\gustav " if it doesn't exist.

Get a list of files recursively is no problem - works with " for /R %%d in (*.*) do echo %%d "
Now I need to do 2 things:
1) extract the directory from the lines that " FOR .. " gives, without " Z: "
2) read the filename including ".dl_complete", and get the filename of the original file - " myfile.txt " in this example.

What it all boils down to is " how do I assign a part of a line to a variable? "
As mentioned I have searched a lot but haven't found anything useful.
I'm not asking for you ... Read more

A:Script to assign part-of-word to a variable

Read other 8 answers


I keep getting this message every time I am trying to attach a word doc into an email. Check temp environment, sims ok, followed instruction to move the folder, every thing ok until I have to get the temp internet file, its not there. I am using windows 7. Can anyone one help?
Many thanks in advance


A:word could not create the work file. Check the temp environment variable

Regedit>HKEY_CURRENT_USER\Software\Microsoft\Windows\Current Version\Explorer\User Shell Folders>make the cache variable --- %USERPROFILE%\AppData\Local\Microsoft\Windows\Temporary Internet Files

Read other 7 answers

Every time I open Word this pops up. I can no longer insert pictures of clipart into my documents and I looked into the system properties/environment variables but am at a loss....someone who knows what this means please inform me as to what needs to be done so that my
program begins to work properly again. Thank you.

A:Error : Word could not create a work file. Check Temp Environment Variable

There is some sort of problem with the Windows temp folder (perhaps deleted by mistake?). To check (and fix if needed) right click on "my computer" and select "properties". In the box that opens click on the "advanced" tab. Now click the button near the bottom marked "environment variables". The path to the Windows temp folder will be shown at the top part of the box. Check to see if the path actually exists or edit it to a folder of your own choosing. Check both "TEMP" and "TMP" and, if you alter them, make them use the same folder. Okay your way out and reboot. Now try the programs you are having difficulty with.

Read other 6 answers

Is there any known reason a user of workbook would get the error code 91, but someone else does not?
I cannot really debug the code since I am not getting the error and it's not practical for me to be at the users' machine, nor for me tell them which step to take to help me debug it.

A:Solved: Excel VBA error code 91: Object variable or with block variable not set

Read other 9 answers

I recorded a macro and run the same code below which works.
So, I saved it as an xla add-in and ran the same code. It creates the pivot table
but I get the error below when it is about to fill the data for the row

Run-time Error '91':Object Variable or With block variable not set

This error on the procedure Sub Test() below occurs at line ActiveWorkbook.PivotTableWizard.
Any suggestion on how to fix this error?

Sub Test()

ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _
"print_logs!R3C1:R6C40").CreatePivotTable TableDestination:="", TableName:= _
"PivotTable1", DefaultVersion:=xlPivotTableVersion10

********* Error Message shows when executing line below

ActiveWorkbook.PivotTableWizard TableDestination:=ActiveSheet.Cells(3, 1)
ActiveSheet.Cells(3, 1).Select
ActiveSheet.PivotTables("PivotTable1").AddFields RowFields:="Comment", _
ColumnFields:="Paper Size"
ActiveSheet.PivotTables("PivotTable1").PivotFields("Total Pages").Orientation _
= xlDataField
End Sub

A:Solved: Run-time Error '91':Object Variable or With block variable not set When Runin

change ActiveSheet to ActiveWorkbook.ActiveSheet

Read other 1 answers

Hi All,

Excel VBA
Error : Run Time Error 91 - Object variable or With block variable not set

I have a userform with some textboxes and Command Buttons. When I add
the record, I receive an error message. The Code I wrote on Command Button to save the data into worksheet is as follow:
Private Sub cmdAddScore_Click()

Dim LastRow As Object
Dim LastRow1 As Object
Dim ws As Worksheet
Dim ws1 As Worksheet
Dim RESPONSE As Double

Set ws = Worksheets("Matches")
Set ws1 = Worksheets("Schedule")
Set LastRow = ws.Range("A65536").End(xlUp)
Set LastRow1 = ws1.Range("H65536").End(xlUp)

RESPONSE = MsgBox("Do you want to save this record?", vbYesNoCancel)

If RESPONSE = vbYes Then

LastRow.Offset(1, 0).Value = txtMatchNumber.Text 'Column A
LastRow.Offset(1, 1).Value = Format(txtMatchDate.Text, "dd.mmm.yy") 'Column B
LastRow.Offset(1, 2).Value = Format(txtMaxOvers.Value, "00.0") 'Column C

If optBattingFirst.Value = True And txtTeam1Name.Top = 150 Then
LastRow.Offset(1, 3).Value = "BF" 'Column D
ElseIf optBattingFirst.Value = False And txtTeam1Name.Top = 180 Then
LastRow.Offset(1, 9).Value = "BS" 'Column J
End If

If txtTeam1Runs.Top = 150 Then
LastRow.Offset(1, 4).Value = txtTeam1Name.Text 'Column E
LastRow.Offset(1, 5).Value = txtTeam1Runs.... Read more

A:Solved: Run Time Error 91 - Object variable or With block variable not set

Read other 13 answers

Ive recently installed a new font (Bengali) named BanglaWord in my machine and was writing happily using it. But suddenly yesterday when I tried to open a file consisting 18 pages, it started showing error [Run-time error 91: Object variable or with block variable not set] and then [Error in text filter: Unknown format (1-1d01)]. And while I tried to open the file by first opening the word application and from there by selecting the file in my desktop, it is showing [Run-time error 5: Invalid procedure call or argument].
Please help me fix the issue and recover the file. Its very important to me. Ive already written the first 18 pages of my first novel.
Thanks in advance.

A:Run-time error ‘91’: Object variable or with block variable not set

Read other 16 answers

I have a user form with 2 textboxes and 3 command buttons. I have 3 worksheets in this workbook. the main worksheet is where the userform is located and the other two worksheets contain data. It's a check in/out macro that i'm going for here. When the user enters their id in textbox1, the macro should check in worksheet2 to verify that the employee id is in fact valid. When the user enters in a serial number in textbox2, the macro should check worksheet3 to verify that the serial number is valid AND that it has not already been checked out.
Any help would be GREATLY appreciated! I've been stumped on this for a week now!

I've copied and pasted my code below. Where I'm receiving the error is highlighted in red text.

Private Sub Label1_Click()

End Sub

Private Sub cmdclear_Click()
'save workbook
'Blank text boxes
txtemp.Value = ""
txtscan.Value = ""
'Disable in and out buttons until there is data in there
cmdout.Enabled = False
cmdin.Enabled = False
End Sub

Private Sub cmdin_Click()

Dim rng1 As Range
Dim rng2 As Range

Set rng1 = Range("AB2:AB215")
Set rng2 = Range("AC2:AC88")

If rng1 = txtemp.Value And rng2 = txtscan.Value Then
Worksheets("Scanner Inventory").Activate
eRow = Sheet1.Cells(Rows.Count, 3).End(xlUp).Offset(1, 0).Row
Cells(eRow, 1).Value = txtemp.Text
Cells(eRow, 2).Value = txtscan.Text
'Time Stamp
eRow = Sheet1.Cells(Rows.Count, 3).End(xlUp).Of... Read more

A:Run-Time error '91': Object variable or With block variable

You have to "Set" the range
Set rng1 = Worksheets("Employees").Range("B2:B215")


Read other 1 answers

In Excel 2003 I have a Sub that updates the Access database where the data is stored that keeps returning Error 91 Object Variable or With block Variable Not Set. I have been over and over my code and I cant find where it is happening. When I run it I'm not catching anything, it doesn't offer for me to debug it and no rows are highlighted. I can't even step into it to debug it. The code is:

Sub UpdateDataInDB(pRow As Integer)
'Purpose: Updates the database with changes made in spreadsheet.
'Parameter: pRow is the row with new data to be added.

On Error GoTo ErrHandler

' Turn off screen updates
Application.ScreenUpdating = False

' Variables for connecting to Database.
Dim cnt As ADODB.Connection
Dim ocmd As ADODB.Command
Dim rst1 As ADODB.Recordset
' Variables for data
Dim stDB As String, stSQL As String
Dim stConn As String
Dim wbBook As Workbook
Dim wsSheet1 As Worksheet
' Variables to hold data for Update
Dim iID As Integer
Dim sClient As String
Dim sClientName As String
Dim sCSECase As String
Dim sDateOfVisit As String
Dim sTimeOfArrival As String
Dim sCountyCode As String
Dim sRevSpecialist As String
Dim sProcess As String
Dim sReasonEstablishment As String
Dim sReasonCompliance As String
Dim sAssistingRevSpecialist As String
Dim sTimeIn As String
Dim sTimeOut As String
Dim iNumberOfCases As Integer
Dim sDocumentType As String
Dim sOtherComments As String
Dim sOutcome As String

'Assign values from Cells to va... Read more

A:Error 91 Object Variable or With Block Variable Not Set

Can you post your sample workbook with the code attached? When I copy and paste the code from your last post into a brand new workbook I do not get any errors and I am able to step through it without any issues.


Read other 3 answers


I am getting the following error when I load the page shown below:
Object variable or With block variable not set.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object variable or With block variable not set.

Source Error:

Line 215: Response.Write ("<option selected value=""" & MonthCheck(MonthCount) & """>" & MonthCount & "</option>" & vbCrLf)
Line 216:Else
Line 217: Response.Write ("<option value=""" & MonthCheck(MonthCount) & """>" & MonthCount & "</option>" & vbCrLf)
Line 218:End If
Line 219:
I'm stuck, I'm thinking it must be something to do with the Function, MonthCheck, but I'm not making much of it. Any help would be greatly appreciated, thank you.
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Page Language="vb" AutoEventWireup="false" Codebehind="person_edit.aspx.vb" Explicit="True" Inherits="Contractors.person_edit" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html lang="e... Read more

Read other answers

Unable to add attachment as not at home. Will try to do once home but will be like 2 hours at least.

Please could someone help with the below:

In a word document is it possible to do the following:

1) if "no" is selected from a drop-down menu, can you add rows to a table to ask further questions

2) if a checkbox is ticked can it trigger a sentence to display in a text field. Ultimatey if 10 checkboxes are ticked I would like it to generate 10 sentences

Please note this is for Word 2013 and not Excel.

A:Word 2013


Read other 1 answers

Hope someone out there is familiar with Word 13 cause I got a big problem.

I'm turning my documents into ebooks. The one document had justified right margins. I finally undid them (don't ask...I can't remember) but now all my words are spaced funny. Is there a way to fix that?

A:Help with Word 2013

Click the Home tab.

Highlight the text you want to realign.

Look at the Paragraph section in the ribbon bar. The lower section has four text alignment settings, from left to right: Left, Centered, Right, and Fill. IF you click Fill, it will add spaces between the words on each line to align the leftmost word and rightmost word with the document margins. To undo do that, just click the Left alignment symbol in the ribbon bar.

Read other 6 answers

I have a 70 page document and all of a sudden, I can no longer enter footnotes because the footnote block is greyed out. I must be a putz but I can't fix it and I have a deadline. Any help please.

Read other answers