Hello
Am using the below excel VB code to transfer the output from SAP to excel but am encountering an issue at the last step where SAP comes up with SAVE AS dialog box asks the destination/path to save the file. I need this step as a part of automation too......please help
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Please Login or Register to view this content.
Last edited by arlu1201; 09-10-2013 at 02:22 AM. Reason: Use code tags in future.
Application.DisplayAlerts = False 'IT WORKS TO DISABLE ALERT PROMPT
ORPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by wenqq3; 09-10-2013 at 03:59 AM.
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
thanks for the instant reply but my concern was to overrule the "save as" pertains to SAP.......the steps am performing are as follows
1.executing report in SAP by feeding in relevant parameters.
2.output comes up.
3.saving the report in spreadsheet form....at this point the SAVE AS dialog box pops up in SAP to save the file at desired destination. Once my loop hits this step, everytime I have to save the file manually and then loop moves on further.I want to overcome the step of SAVE AS dialog box.....macro should save the file automatically which am not able to accomodate in my automation steps.
Is there any one who can help me on my below concern????
Can anybody help me with the VB code to run Hyperion from Excel 2010?
@ ajt0107
Pls don't bump your thread every 1 hour. we can be elastic to forum rules but not so much....
If your question has not been answered within a day, consider adding another post with any additional information you believe is relevant. If you think your post is good as is, just reply to your own thread with the words "Bump no response", which will bring it to the top of the forum.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Dear Ajit,
Did you find a solution to this problem. i'm facing the same issue with SAP 7.10 and I don't have an option to upgrade SAP to apply an alternate solution
Regards
Mir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks