Thanks PHV,
Yep, the macro recorder helped; it let me build some basic code. Then, by browsing this website I found some other snippets to patch in there.
Cheers to all
Paul
The app i am running that uses VBA doesn't have a macro recorder. But you have givenme an idea, could i record the macro in Excel and then patch the majority of the code into my other 'host' application (something called RSView)?
Thanks...
Hi all,
I'm trying to use VBA to open an existing Excel 97 workbook, Update the links in the workbook, and then SaveAs the workbook with a filename that is just the current date. Then, quit Excel.
The excel file that needs to be opened is in the same directory that the 'save as' file will...
Thanks Murugs, my Internet browsing is fine, so it appears to be some other issue.
I may have solved my problem (jury is still out) by making a change to my wireless router config. Oddly enough this was identified on MSN's knowledgebase. My particular model of Linksys router is NOT on the...
Win XP Pro, ver. 5.1.2600 service pack 1
Outlook 2002
For years I used to get my POP3 email by means of a dialup account (MSN.com).
Recently I installed a broadband connection from a local ISP (Wispertel.net). They are not affiliated with MSN. I set up my Outlook mail account the same way...
Hail bcastner! We are not worthy, not worthy!
I have been lurking on this thread, and others on tek-tips which are similar to it regarding Wifi issues; where your Wifi connection has a great signal, good connection, pings OK, etc. etc... but the Internet is a no-go. Been working on this...
Excellent, Wray, thanks, it worked as you wrote it.
Now, can the table_array parameter be in a seperate spreadsheet? Not sure how to define that.
Thanks again...
Using Excel 2000:
I have a "master" spreadsheet that contains Part Numbers and their associated data. The PN's are all in collumn A, and the data that corresponds with the PN's reads across (3 additional collumns of data).
I want to start a 2nd spreadsheet that allows me to type in...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.