Ditutup

Write some Software

I am having a lot of problems running code that works as expected in Excel 2010 and below, but not in Excel 2013 and above. I believe the problems are related the SDI introduced in Excel 2013

As a simple example, create a new workbook and insert the procedure Test() found at the end of this message.

Save the workbook as a macro enabled workbook.

Run Test() under Excel 2010 or below, and ThisWorkbook will be active at the conclusion of Test().

Run Test() under Excel 2013 or 2016 and this [login to view URL] will be active at the conclusion of Test().

What can be done to make this workbook active at the conclusion of Test() when run under Excel 2013 or 2016?

I have a large application that has similar problems. I am looking to hire an expert to help me fix them. Anyone who can provide a solution to make Test() work as expected under Excel 2013 and 2016 will be considered.

Sincerely

Matt Hurley

BudgeTools LLC

805 376 8090

Sub Test()

[login to view URL] = False

[login to view URL](1).Range("A1").Value = _

[login to view URL] & " should be Active at the end of Test()"

[login to view URL]

[login to view URL] [login to view URL] & "\[login to view URL]", 51

[login to view URL] [login to view URL] & "\[login to view URL]"

Workbooks("[login to view URL]").Sheets(1).Range("A1").Value = _

"[login to view URL] should be NOT Active at the end of Test()"

Workbooks("[login to view URL]").Sheets(1).Range("A1").[login to view URL] = 255

[login to view URL] = True

[login to view URL]

' Run Test() under Excel 2010 and below _

and this workbook will be active at the conclusion of test().

' Run Test() under Excel 2013 or 2016 _

and this [login to view URL] will be active at the conclusion of test().

'What can be done to make this workbook active at the conclusion of test() _

when unning Excel 2013 or 2016?

End Sub

Kemahiran: Excel, Visual Basic untuk Aplikasi

Lihat lagi: software write mq4, software write chip epson, useful software write book, excel, visual basic for apps, microsoft excel, software write web specs, free software write user guide, software write edid, free software write company profile, software write websites idea, write sentence years work, software write book images, software write books, software write protection, free software write book, software write book, solution carry work reservation system, samples write words quality work, flash poker server software lobby solution

Tentang Majikan:
( 6 ulasan ) United States

ID Projek: #11651651

15 pekerja bebas membida secara purata $52/jam untuk pekerjaan ini

deepbluetech

Hi Matt, I am an Excel macro expert and would be happy to assist you. I was successful in tweaking the Test() code to make it work as desired under Excel 2016. Let me know and we can discuss. Regards, Arul

$50 USD / jam
(199 Ulasan)
7.3
$55 USD / jam
(252 Ulasan)
7.6
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$50 USD / jam
(259 Ulasan)
7.0
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega Lagi

$50 USD / jam
(191 Ulasan)
6.7
rengrish

Hi , Fix is simple. I found the issue. Please check the link [login to view URL] Add below to close Book2, since new book created it will activate Book2 only. Solution is to c Lagi

$50 USD / jam
(134 Ulasan)
5.8
ZeusMan

Hello, I’ve carefully gone through your job posting Write some Software. I'm an expert in Advanced Excel VBA programming techniques. I am very much interested in your project with all of your requirements. I am a Lagi

$55 USD / jam
(73 Ulasan)
5.9
abhinovpankaj

Hello, I have been working as freelancer since last ~ 3 years,prior to this was working with a MNC as an Sr. Software Professional. The project is Product based development and integration of the product with vari Lagi

$55 USD / jam
(44 Ulasan)
5.4
prabakarm23

I have 7 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I Lagi

$55 USD / jam
(50 Ulasan)
4.7
laurajiannaras

Dear Matt, I do NOT want to be awarded this project, but I am very curious to know what solution will be appropriate for your situation. I have no idea why the problem is occurring in Excel 2013, and firmly believe Lagi

$55 USD / jam
(6 Ulasan)
3.7
brentmccaw

I am sure I can find much more elegant solutions to the issue but I have found that this works. 'The only way to reset the Excel 2013 state is to hide/show the active window [login to view URL]("[login to view URL]").Acti Lagi

$55 USD / jam
(1 Ulasan)
3.1
TulyakovN

Hello. Understand, how to do this job. Skills in VBA, experiance of working in word, excel, access. No problem with this job and those tasks from discription.

$50 USD / jam
(5 Ulasan)
2.8
ToniKdao

Try replacing [login to view URL] with [login to view URL] at the end of your code. I'm ready to discuss working on your project if you are interested. There is a lot of Excel VBA development in my background.

$50 USD / jam
(0 Ulasan)
0.0
workspaceitaus

Hello, I m Tahsinul Alam, completed Masters in Software Engineering now working as one of the project manager of WSIT-Austalia software firm located in Melbourne,Australia. We have 13 different teams to work in dif Lagi

$55 USD / jam
(0 Ulasan)
0.0
seekdeveloper

Hi, I have read your post and understood your requirement. I have great experience working on /Visual Basic/PHP/MySQL/HTML5/jQuery/Laravel/Wordpress/Magento/Joomla/Drupal/AngularJS/node.js/CSS3/Java/Python/Django Lagi

$50 USD / jam
(0 Ulasan)
0.0
gopapra

Hi Matt, I have close to 16 years of experience in VB, VB.NET and VBA development. I have started developing VBA Macro for Excel 2000 and still developing the same for Excel 2016. Over the years, I have learned all Lagi

$50 USD / jam
(0 Ulasan)
0.0