office 2010

Hello, I have to migrate a very old excel file with many macros from Office 2010 to Office 365 (Office 2010 being no longer supported). The Excel file works perfectly on Office 2010. When I run the VBA compiler, I get the following error message: Compile error Variable not defined Here is the...

Hello, I have this stupid problem where I cannot change the date formatting. Can someone help me. I'm going crazy...:rofl::rofl::rofl: I check in google to see if I can solved my problem. I could see a lot of people has a trouble change date format but it doesn't solved mine. Here is what I...

I'm trying to sort through and import a number of bar-delimited text files into an Excel spreadsheet, and running into trouble with the Dir function. My code follows: Option Explicit Dim wbMonthly, wbYTD As Workbook Dim strFileName, strType, strPrd, strFile As String Dim lngBlank As Long...

Hi, I'm getting the following message appear: - The code for the Timer I've taken from the link supplied in the following post http://www.mrexcel.com/forum/excel-questions/351089-how-do-i-make-macro-run-every-minute.html and I've used the example from Pearson Software Consulting Here is the...

First, thank you for looking at my post! I have a simple macro in a worksheet that I use every day for keeping track of working on projects. It has worked since I wrote it without trouble, until I did the Office 2010 updates yesterday. Now it does not run at all. There were several updates...

I have a very simple and - it seems to me - reasonable wish: I want to buy - for a newly acquired PC (windows 7) the package "Office 2010" for the simple reason that we are three to four people who like to work on our Excel and Word files with the identical software. I do *not* want to have one...

Hi, I just installed WIN7 and OFFICE 2010 and when I run macro I got error like: Run-time error '1004': [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. do you know which driver in office is missing ???

Hello, I have a simple question but can't figure it out. I have a sheet with locked cells (a template essentially) and I want to be able to paste data into the unlocked cells of this sheet without unprotecting it however Excel won't allow this. Any help is appreciated. Thanks in advance!

HI, I am a newbie at excel programming, I am using Office 2010. I was able to successfully embed an excel workbook on powerpoint. I wanted to ask about controlling the number of rows visible on the embedded excel workbook. I had tried resizing the handles on the OLE object but it resizes the...

Hi folks, This problem is driving me crazy. Please help! I have a macro in Excel and when it finishes, I want to send myself and a colleague a simple text email advising the macro has finished running. The issue I've got is he is using WinXP and Office 2007, whereas I am using Win7 and Office...

Embarrassing, but I have a report due tomorrow and all I havve remaining is typing the links in the cells. The range I'm using has the text formatted to Georgia 9.5px (black)... I do not mind the hyperlinks turning blue, in fact, I expected it; However, the cell sizes do not accommodate...

Word > Excel 2010 question so I have a document that lists names and addresses like this: Bob Smith 2010 Main Street BR, LA 70808 and I want to create an excel document with columns like Name, address, city, state, zip but I cant just import it into excel the way it is or it all goes into 1...

Hello, I am looking for someone to write code to push information in a single cell on an excel document to multiple locations on a word document. so the info is a job number and i would like it to be entered the one time in the excel document ant then placed in the word document on the cover...

Hi, Hoping someone out there might be able to help! I have been using a piece of VBA code in powerpoint for 10 years now which ecentially goes through all the objects in powerpoint, finds the linkedobjects and replaces the existing source string (shape.linkformat.sourcefullname) with a new...

I have an issue that I constantly get the "macros have been disabled" popup when trying to run my macros and it isn't even constant in the fact that it only stops running macros on one workbook and continues to allow them on others workbooks sometimes. The trust center is still set to allow...