Search found 40 matches

by SandyDoss
Fri Dec 21, 2018 6:26 pm
Forum: General Discussion
Topic: Limit to Excel Workbook size?
Replies: 3
Views: 5872

Re: Limit to Excel Workbook size?

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...
by SandyDoss
Thu Dec 20, 2018 11:11 pm
Forum: General Discussion
Topic: Limit to Excel Workbook size?
Replies: 3
Views: 5872

Re: Limit to Excel Workbook size?

Addendum: 618k is good, 1.3mb fails.
by SandyDoss
Thu Dec 20, 2018 10:42 pm
Forum: General Discussion
Topic: Limit to Excel Workbook size?
Replies: 3
Views: 5872

Limit to Excel Workbook size?

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...
by SandyDoss
Wed Mar 07, 2018 3:23 pm
Forum: Beginners
Topic: Excel errors
Replies: 7
Views: 6607

Re: Excel errors

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. :evil:
by SandyDoss
Tue Mar 06, 2018 4:34 pm
Forum: Beginners
Topic: Excel errors
Replies: 7
Views: 6607

Re: Excel errors

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.
by SandyDoss
Tue Mar 06, 2018 4:32 pm
Forum: Beginners
Topic: Excel errors
Replies: 7
Views: 6607

Re: Excel errors

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...
by SandyDoss
Tue Mar 06, 2018 3:39 pm
Forum: Beginners
Topic: Excel errors
Replies: 7
Views: 6607

Re: Excel errors

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...
by SandyDoss
Tue Mar 06, 2018 12:11 am
Forum: Beginners
Topic: Excel errors
Replies: 7
Views: 6607

Excel errors

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,...
by SandyDoss
Wed Oct 11, 2017 9:05 pm
Forum: Beginners
Topic: Microsoft is not my friend today
Replies: 2
Views: 3219

Re: Microsoft is not my friend today

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
by SandyDoss
Wed Oct 11, 2017 7:41 pm
Forum: Beginners
Topic: Microsoft is not my friend today
Replies: 2
Views: 3219

Microsoft is not my friend today

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...
by SandyDoss
Tue Sep 19, 2017 10:15 pm
Forum: Beginners
Topic: Do the MSG_ parameters work with the Input dialog?
Replies: 2
Views: 3479

Do the MSG_ parameters work with the Input dialog?

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
by SandyDoss
Wed Aug 09, 2017 6:15 pm
Forum: Beginners
Topic: Multiple execution of the same script
Replies: 1
Views: 2560

Multiple execution of the same script

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...
by SandyDoss
Wed Aug 09, 2017 5:37 pm
Forum: Beginners
Topic: Frames vs Windows
Replies: 2
Views: 3190

Re: Frames vs Windows

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...
by SandyDoss
Tue Aug 08, 2017 4:10 pm
Forum: Beginners
Topic: Frames vs Windows
Replies: 2
Views: 3190

Frames vs Windows

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...
by SandyDoss
Thu Jun 08, 2017 4:16 pm
Forum: Technical / Scripting
Topic: XMLParse
Replies: 1
Views: 2101

XMLParse

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
Sign up to our newsletter for free automation tips, tricks & discounts