version

Hi All, I'm working on upgrades for a DB, and for my updated version I began with a blank DB and imported all the forms, queries and tables. I made a number of changes to the forms, but left the queries and tables alone. In the previous version, v.1.3, all my queries worked fine and were...

Hi, Hello Friends, I am the new member, I am very interested in this forum. Thanks. I Just want to know that Which is the best & compatible Excel Version for user point of view nowadays ? Thanks

I wanted to extend the functionality of the doubleClick to all the sheets in a workbook, rather than having duplicating code in multiple worksheets. 1 So clicked on "ThisWorkbook" in VBA Project manager. 2 Got a Code Window. 3 Clicked on "Workbook" from the dropdown ((General) 4 Got an error...

I created and administer a Microsoft Access Application -- there are about a dozen users. I created an accde file that i distributed to all the users to put on their respective desktops. Every time I make an update, the application identifies that there is a new version available, and a batch...

Good morning! My apologies for the somewhat cryptic Title but I was unsure just how to phrase this This macro saves a version of a file in a specific folder and names it filename - version - extension The version is incremented each time a change is saved. The new versions are saved with...

Hi All! I have a spreadsheet with more than 15K lines of data. This is the product of combining about 10 different versions of the same spreadsheet (there was no real version control before I started working on it). The data are grouped by content in cells in column A (VBA code to insert blank...

I am trying to query data from Access into Excel with the criteria for the Access query coming from Excel via VBA. I am using Access and Excel version 2016.

Hello! I had a macro in Outlook that was working perfectly well in suppressing the "No Subject" warning. Due to inferior hardware here at work the only way I can be sure my work is truly saved is to email it to my home email. I do this 50-60 times a day when I am on a project. For some reason...

Hi All, I'm in need of some Vba help (As usual) :) Id like to implement a version tracker into my spreadsheet. Basically, I have a workbook with multiple sheets, when I update any cell on the "communication plan" sheet id like a box to pop up that says something like "Changes will...

I have an Excel application written in Excel 2010 64 Bit. Everything has run fine for months but I needed to add a Chdir command and ran into a problem. I added in a Private Declare PtrSafe Function SetCurrentDirectoryA Lib "kernel32" (ByVal lpPathName As String) As Long to my code and...

I have the professional enterprise version of office 365 that I use for work. However I would like to purchase a home version with the full Power Query and Power Pivot capabilities. Does anyone know what version I should buy. Does it have to be a business version?

My macro runs fine until I turn on power-query. Once this is turned on I get an error message. How can I run the macro error free with power-query turned on? Win7/64+Office2013/32 Error Message: " See the end of this message for details on invoking just-in-time (JIT) debugging instead of...

Hi All I have a Userform that passes its values to the next empty row and now I need to update the version number column. If cell in column B is Draft then find last draft version and add 0.1 to the value in column A unless if last draft version is less than last Approved version then in that...

Good morning everybody. I have a spreadsheet which is made up of six identical, adjacent blocks of data, each of twenty columns or so. The structure of each block of data is identical. Within those six blocks of data, I need to be able to find a value (which can only appear once), and look up...

Hello All, I am asking what would MsgBox Application.Version return with Excel 2019? Thanks and Happy Thanksgiving for the members in the US.

Hi guys, I recently was upgraded to a windows 10 system with Excel 2016. I'm having a recurring issue when I'm working with large files (last happened on a 15mb file) where whenever I try to save the file, excel disappears. It just closes. I’m not getting “ File not Responding” message nor...

Good day Demigods, Hoping you can help with this. 'Workbook' is a macro-enabled template. What i want to happen is have a button on 'SheetA!' within 'Workbook', that when clicked on, it opens a new instance of 'Workbook' and copies the contents of a specific range of cells from the original...

Someone sent me a workbook to look at "because its no longer working". What they sent was an XLA file. They said it use to add a ribbon to their tool bar but now it doesn't work with the latest version of XLS. Is this just missing a tool pack or Add-in that needs to be activated in her latest...

I have this Excel file I created back in 2003 with various macros but I can't find the method of opening the actual macro file XLSM ! I am using 2010 version and would appreciate guidance on how to open it. I do have the developer tab in my ribbon. thanks Ron

Hi Each time I save a quite complex model as a new version, I get this error: It doesn't appear when I save the file normally (overwrite previous). it appears to relate to charts, the model has a lot of them. Some of them use 2 row column headers which has the effect of forcing the 2nd row...