Search results for query: *

Hi Remy, Yes, I would normally use <EraseEOF>, but I was wondering if there is a way to send that command through Excel...?

You're right; that isn't quite what I was looking for. We would like to prep/scrub the data in Excel - to input and delete as necessary. I think we'll just have to input the information in Excel to update the screen, or key in the appropriate number of [spacebars] into Excel to delete the...

If I am reading this correctly, it will delete/clear the data at (r,c) regardless of my Excel worksheet, right?

Hi Skip, Yes, that's correct. We are currently using this code to input information between 4 different fields, so when the macro says <enter> the screen gets updated. Thing is...some of the information we enter becomes obsolete or expires, so we need a way of quickly removing it specific...

I've got this code to scrub data in Excel and input it into the mainframe accordingly. I'm wondering if there's a way to use the same code&Excel worksheet to conversely delete these values - short of filling in the Excel worksheet with a horde of spacebars, is there something else I can use...

The messagep-rompts are basically only there to ask "Hey, what file am I working with here?" and we would enter/confirm the path (a default path and file is already suggested in the prompt). Then they'll ask, "Hey what sheet should I read off of this file?", and, "What row do I start at?". So...

Skip, thanks very much for your thoroughness and insight! I'm probably phrasing my question inadequately, but I'm really looking to stop the message prompts that pop up when the macro is ran. Basically, I want to turn them off to avoid the type of user-error you eluded to - misspelling...

Hello world, I just discovered and joined Tek-tips as it seems to be the perfect place for me, and as it turns out this would be my first time asking for support online. In short, I'm a total n00b. My question has to do with the following code - I've inherited it from someone long gone, and...