As a sidenote, when we attempted to execute excel.exe via the command line, we got a Windows message stating that another workbook couldn't be opened due to lack of memory or disk space :shock: So, as a workaround, we used VB to open the file and we had no problem. It would be beneficial, however, t...

Addendum: 618k is good, 1.3mb fails.

Hello, and Happy Holidays! I'm having an issue opening an Excel Workbook that is sized approx 1.6 meg. Using the XLOpen command, I always get 'ERR' back in the handle variable. The workbook is comprised of 9 different tabs. I can trim the workbook down to a smaller size, and open it just fine. Secon...

Well, I finally found someone with the same issue.

Here is their post:
https://superuser.com/questions/562598/ ... -opens-the

Will update if I don't kill my pc while jerking with the registry.

Also, there are no dialogs being shown. In fact, even when I set the macro to make the spreadsheet visible, I cannot see it. I only know it's open by a) task manager, and b) manually opening it gets me 'it's locked for editing' message.

So, just as a test, I copied the workbook, removed all sheets except 1, removed the column with the hyperlinks, and could (using the macro script) open the workbook, visibly see the spreadsheet, pick a cell and display the contents. So the hyperlinks are the culprit. Possibly excel is checking for a...

Hi, Marcus, The links go to specific directories on a Google Drive to display a set of available documents. I don't know how to tell if the workbook is 'busy' - so I'm looking for some debug things I can do. The links to Google drive are the only thing I can think of that might be getting in the way...

Hi, We're working with an Excel workbook that is giving us problems. Our code (minimally, as we can't get past the open), is as follows: let>ws-name-file=C:\Users\Administrator\Desktop\sandy.xlsx XLOpen>ws-name-file,1,ws-work-handle Wait>1 MessageModal>opened file XLGetCell>ws-work-handle,MIDLAND,1,...

Marcus,

I know I've said this before:

You are my favorite person in the whole world at this particular point in time.

thanks for the quick response - Sandy

Does anyone know a way to force Excel 2016 to open an earlier versioned workbook (.xls) NOT in read only mode?? I don't believe I want the user to change their 'trusted' settings or 'protected' settings. I'm using the workbook only as a temporary place to store data during a macro run. Alternatively...

Hi,

I want to position an Input dialog box. Can I do this using the MSG_XPOS and MSG_YPOS? Or do I have to build my own dialog box?

Thanks

Quick question: If I have a script that will open an application, and I need to have the script execute twice at the same time, will the use of window handles work even if I'm using image recognition to find things on a window? I'm thinking the script will (loosely): set WIN_USEHANDLE on launch an a...

Secure location. Yes, well. It's been mentioned. And nixed. I can see under View System Windows a parent and a tree, and the crosshairs dropped on the inputbox highlights an entry on the tree, and the listing on the tree gives me a number, and a name, so I should be able to then access it as a contr...

Is a frame treated the same as a window in MacroScheduler? Can I use window calls in the same way? I'm working with an application that was written in MAGIC :shock: - a language developed many, many, many years ago as a rapid application development tool. It appears to be database driven (like Micro...

Hi, I have a 64 mg XML file that I need to turn into a text file delimited by...whatever. Is XMLParse the command I need? Does XMLParse work with a file? The documentation doesn't elaborate much :cry: Or, do I go with a VB script? What would you suggest? Thanks for any and all consideration - Sandy