Search results for query: *

Told you I wasn't very savvy on that! I knew that, but I'm not clear on the Excel version. Right now I'm trying to get 40 macros converted to Reflections from Extra. Micro Focus created a session that allows 3270 files such as quick pads and macros to run but I am running into some problems...

I see. Then the user goes in and saves it to their Normal, etc. I'm afraid my users are not as sophisticated. But I'll work on it. Thank you Jeane

Yes, I've been advised of this since day-1. So I do have a similar loop I use when I'm sending to the mainframe. In this case, I'm only working in Excel. I am interested in creating the code in Excel instead of Extra, except I have problems distributing the Excel macro. The way I deploy macros...

Ok, I've made your edits. You think tightening up the code might help? I thought I had to use the activate and select to access the Excel object specifically. But I'll try not to leave it viewable and see if doesn't go through faster. Jeane

I'll try it! Thank you! Jeane

Thanks for the advice Skip. My fear is that I have a download script that is run when around 200 staff log into their system each day. I know how to develop in Extra but not so much in VBA. Plus we have so many security issues that Office macros won't generally download. So I put the code in...

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...

You need to use both carriage return and line feed in my experience. Try this: Sub Main msg1 = "Add a carriage return and a line feed" & chr(10) & chr(13) msg1 = msg1 + "and see if it works for you." & chr(10) & chr(13) msg1 = msg1 + "Good Luck." msgbox msg1 End Sub

Yeah! It worked! Thanks so much.

I don't think there is a date data type in Extra... is there?

Ok... Don't I feel dumb?? Ok, well I did this and I'm still missing something. Any ideas?? Code ------------------------------- Sub main Dim str1 as String, nextweek, msgtext str1=InputBox$("Enter the return received date:") str1=CVDate(str1) str2 = Date()...

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...

Ok. Thanks. I was looking at this through Access Help last week. Just got to put it all together. Thanks

Thanks. I did finally post in Access site you recommended. I also wondered if anyone had some EB code that ran against and Access database they could share so I could try out that route. Thanks again.

I always perform the SaveAs when I want to determine the location. I turn off the alerts, but it's the best way I find to be specific in the save location.

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...

The previously provided code does not work for me in eBasic. I do believe it is the "=:" that stops it. It will accecpt the "=" but not the ":". Can someone help me with simply referencing between multiple sheets in a workbook within the same sub or between subs in the same macro? Thanks