version

Hello, I am creating a worksheet that I want to export as a pdf when I am finished. I want it to go into the current directory, but it is dropping into "My Documents" in one way and one directory up in the second version. I could get around the thing in the second version, but it is also adding...

According to J. Walkenbach: That's exactly what happens when I check the value of any public and static variables in the Watch window. Public slxRibbon As IRibbonUIPublic Declare Function InternetGetConnectedStateEx Lib "wininet.dll" (ByRef lpdwFlags As Long, ByVal lpszConnectionName As...

Hi All, I have searched the forum and found some US postcode versions, but i am looking for a post code calculator in miles for the UK by road. Does one exist for mileage by road. I have seen some mention API ( i am clueless about), so am looking for a legal version as i saw it mentioned...

Hi everybody! I know that this question has been rarely discussed over the internet and still has no solution. Many users know about really great add-in MOREFUNC with very useful functions. But it works only in 32-bit Excel version. So right now 64-bit version of Morefunc is been looking by...

I have a .xlam file that will likely be updated to newer versions. I would like to include a version number in the name of the add-in such that someone browsing either the list of add-ins ("Developer->Add-Ins") or list of references ("Visual Basic"->"Tools"->"References") will see the version...

I have two sets of two columns, in column A I have an ID and in column B I have a version. I pulled another set of IDs and versions, column D has the ID and column E has the version. I need to compare these two sets of lists. I have to match up the IDs from A and D and then pull the...

Hi All, I've got a couple of hundred spreadsheets that have a default worksheet listing dates. Is there a vba, batch file script that will copy a new version of that worksheet to every spreadsheet in a single directory? The worksheet is named exactly the same "Holidays". thanks in advance

Sorry I am not sure where to begin even asking for help, let alone explaining what I am trying to do. The Process I have a form made on excel that requires both text and numbers. The form has two variations. Form A starts a new Request and can yield multiple tracking#s per request. (seperate...

An odd one I have a file with several macros in it, when I used buttons on the worksheet an assign macros then when I save as the file(It is under development, so I regularly save new version with a new name) it works fine. I have now removed the button on the worksheet and moved all the...

Hi, I'm looking for recommendations for spreadsheet version control that works on both Windows and Apple operating systems. Found this provider: https://xltools.net/excel-version-control/ which does all required, but it's only compatible with Windows. Thank you in advance, Jack

Hi I get this message on a number of workbooks and want to try and stop them, anyone know why this happens and how do I stop it The name 'Generic name' already exists. Click Yes to use that version of the name, or click No to rename the version of 'Generic Name' you're moving or copying I...

I am tring to change color of a cell in a cell range("A10:F100") when ever a cell in a range is updated from previous value by formula due to change in other worksheet in earlier version of office(before 2007). Please help in this regard

Hi all - I run a wildlife rehabilitation nonpropfit and I'm reasonable computer savvy but barely know any Access at all. I inherited an Access database of all of our 10,000+ animal intakes when I arrived, and I just realized that volunteers have been making additions/changes in two different...

Is it possible to import a single cell from one Excel file to another, such that each time I open a specific .xlsx file, it will import the value from the most recently saved version of a different file (either opened or unopened)? Any guidance here is greatly appreciated. Thanks, Sam

I just found out that I would have uninstall my 64 bit Windows Office 16 with the 32 bit version because one of the databases we have was written in the 32 bit version. Will my Excel 64 bit files open in the 32 bit application without losing any functionality? I have some formulas in some...

Hi If you write an excel application that will be distributed to a high number of people. You dont know what excel version they use etc. How do you go to be sure the application will work for the highest possible number of people?

Hi, I was wondering if anyone here knew of an alternative to the Print2Excel software which has been retired and no longer for sale: http://print2excel.com/ I have a client that was using the free version but would like to purchase the paid version but is, obviously, not able to do so...

I manage an Excel document that is stored on a SharePoint that approx. 60 users access each day. They are to download the file daily and run it locally. The file has several references to other workbooks and at times I need to make changes to the references as well as regular updates. I’m...

I recently created an excel workbook that contains a user form that opens as soon as the app opens. This works fine on my desktop app but it appears to not be working when it opens in the excel online version. I basically have VBA code: Private Sub Workbook_Open() ufmTripSignup.Show End Sub...

this occurs when copying and pasting from one worksheet to another worksheet (impossible for me to confirm but I strongly believe the sheet being copied from was created in 2003 Version and is being pasted into file created in 2010 Version - if that matters. Also integrated with a database...