Search results for query: *

I am a longtime macro developer in extra basic. We are going to move to Reflections in a couple weeks and I am testing all the macros to ensure they will work. I've been fairly successful except for one problem and that is that I get a Extra basic error 55 or 58. The thing is not consistent...

I have many macros that open Word or Excel and I send data to those programs and retrieve data from them. However, I now need a macro where I can open the same text file (saved to the desktop) and after compiling data in Extra session, paste that data into the text file. I've been able to open...

We have a huge autotext file we need to share with multiple staff. We seem to be able to distribute the list of paragraphs, but staff can only insert onto their document if they access the drop-down list and select. They used to type some code and autocorrect would insert the text from that...

I'm trying to give a user the number of days beginning with the date the user provides up until today. I'll attach the code, but am really lost in trying to find the number of days in between the first month and this month. I'm sure there is a much cleaner way to do the other parts and am more...

Hi all, I want to run an Extra!Basic macro against data currently resides in an Access database. I don't know how to "getstring" data in Access then do what I need to do in Extra! then send confirmation/results to Access. So since I'm very comfortable doing the same process in Excel I thought...

Hi all, I want to run an Extra!Basic macro against data currently resides in an Access database. I don't know how to "getstring" data in Access then do what I need to do in Extra! then send confirmation/results to Access. So since I'm very comfortable doing the same process in Excel I thought...

Hi all, I'm working on a macro in EB where I've opened a specific workbook in Excel. At some point I want to insert a copy of one of the worksheets into the same workbook. I'll include the code I have so far that makes a copy of the worksheet and adds it, but it adds it to a new workbook. I...

In my code I send a Word doc to the printer. Then I close the doc and the Word app. Problem is I can't control how long to wait between sending the doc to the printer and closing the Word doc and then app. I've tried several variations, but here is one I'm working with now: Set objRange =...

I give the user a dialog box to add an unlimited list of 13 or so digit values. I get it all as one string that I dilineate with a space between each value. Now I want to parse out the string and assign each parsed value to a variable to run through another routine. I will loop through the...

I wish to develop a macro that will exchange info with a mainframe application and an online fillable PDF file. Has anyone tried this? If so, how did it work for you?

I'd like to use a dialog box to obtain up to 28 different pieces of data. We use a scanner here that I've recently found will scan data into a dialog box in Extra. Problem is everytime a data item is scanned into a cell in the dialog box, it sends the equivalent of an Enter key and the...

I have a macro that performs a mailmerge in Word. It chooses to print 2 or 3 copises of the merged letters, then closes document. My problem is I can't control the amount of time between when the macro command to print is sent and the close document command. Since the printer

I have a macro that performs a mailmerge in Word. It chooses to print 2 or 3 copises of the merged letters, then closes document. My problem is I can't control the amount of time between when the macro command to print is sent and the close document command. Since the printer gets a lot of use...

The macro I run opens a Word doc and after going through a routine, it prints the doc. Then I want to close the doc (not Word, just that doc) without saving the changes. The VBA code is: Documents.Close SaveChanges:=wdDoNotSaveChanges With minor differences mine would read: objDoc.Close...

I'm scraping info and sending it to a Word doc. I want to be able to send data to Word and then at some point put in a page break and start a new page. It can be in the same doc, just different pages. I use: objDoc.Content.InsertAfter Chr$(13 ) & Chr$(10) & Chr$(13) & Chr$(10) msgText =...

I need to run a macro that will facillitate a mail merge in Microsoft Word. I can open the doc I want the merge to occur in, but can't actually fire the macro. Any ideas? I'll include my current code for how I declare the objects. I'm still working in 6.5 I think so please be specific with...

I'm writing a macro where I want to perform several date functions. Essentially I use a GetString to pick up a date from the host, e.g., "01/15/04" 1. I'd like to determine if the mm/dd part of the date is prior to "12/31" and if so, change it to the last day of the month for said "mm" and...

Has anyone had a problem using a macro on a session that has enabled hotspots? I think that may be the problem a couple of my systems have. The macro works fine on a system without the hotspots enabled, but on one that does. Thanks